ZuoTi.Pro
Question

The past sales history for Store 6 is provided in the table below. Adjust this data...

The past sales history for Store 6 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years.  Report the re-seasonalized forecast period 36.

Month Year Period Store 6
January 1 1 56602
February 1 2 72016
March 1 3 104245
April 1 4 100981
May 1 5 95962
June 1 6 83167
July 1 7 62842
August 1 8 60116
September 1 9 41353
October 1 10 34862
November 1 11 58860
December 1 12 51528
January 2 13 75343
February 2 14 86926
March 2 15 94059
April 2 16 91248
May 2 17 106624
June 2 18 94814
July 2 19 79936
August 2 20 79917
September 2 21 54855
October 2 22 48695
November 2 23 55117
December 2 24 65077
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Below is the screenshot of the formula applied to get the result -

Abhishek Rai Excel Book2 File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do XCut Auto 11

Below is the screenshot of the desired result -

Book2 Excel Help File Home Insert Page Layout Formulas Data Review View Tell me what you want to do gt Cut ab Wrap Text A A C

0 0
Add a comment
Know the answer?
Add Answer to:
The past sales history for Store 6 is provided in the table below. Adjust this data...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The past sales history for Store 7 is provided in the table below. Adjust this data...

    The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years.  Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November...

  • The past sales history for Store 7 is provided in the table below. Adjust this data...

    The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years.  Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November 1...

  • Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018...

    Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018 August 2018 What is the forecast demand for March 2019 considering trend and seasonality? January 2019 25,990 February 2019 24,260 19,940 20,860 Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018...

  • 1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...

    1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...

  • The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16,...

    The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.

  • PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2...

    PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2 : "February", 3 : "March", 4: "April", 5 : "May", 6 : "June", 7 : "July", 8: "August", 9 : "September", 10 : "October", 11: "November", 12 : "December" } . Prints out all the items, both key and value, in the dictionary Prints out all the keys in the dictionary Prints out just the values in the dictionary Loops though using the keys...

  • Here are the data for the past 21 months for actual sales of a particular product:...

    Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 330 285 February 450 385 March 455 355 April 455 410 May 410 440 June 435 350 July 400 390 August 310 300 September 355 395 October 480 November 555 December 540 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third...

  • Coding in C++ Write a program using structures to store the following weather information: - Month...

    Coding in C++ Write a program using structures to store the following weather information: - Month name - Day of month (Monday, Tuesday, etc) - High Temperature - Low Temperature - Rainfall for the day Use an the input.txt file to load the data into weather structures. Once the data for all the days is entered, the program should calculate and display the: - Total rainfall for the data - Average daily temperatures. (note: you'll need to calculate the days...

  • The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...

    The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 180.44 $ 626.46 February 180.49 632.84 March 202.81 561.38 April 219.75 551.30 May 188.05 491.58 June 212.77 484.78 July 246.46 609.09 August 193.09 532.86 September 224.87 510.36 October 215.67 610.82 November 200.39 583.73...

  • The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...

    The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 180.44 $ 626.46 February 180.49 632.84 March 202.81 561.38 April 219.75 551.30 May 188.05 491.58 June 212.77 484.78 July 246.46 609.09 August 193.09 532.86 September 224.87 510.36 October 215.67...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT