##### Budgeting and Forecasting HW Question

label Business
account_circle Unassigned
schedule 1 Day
account_balance_wallet \$5

Using the table “Computer Sales Time Series”, calculate the forecast for computer sales (in thousands) for Week 13 using a three day weighted moving average. Use a weight of .40 for the most recent observation, .35 for the second most recent, and .25 for the third most recent.

 Computer Sales Time Series Week Sales (in thousands) 1 2 2 4 3 5 4 3 5 6 6 7 7 5 8 8 9 4 10 2 11 3 12 5
Jul 10th, 2015

Thank you for the opportunity to help you with your question!

Using three day weighted moving average,

To find value for 13th week, we will use values of 12th, 11th and 10th week

Forecast for computer sales in 13th week =( (0.4*5) + (0.35*3) + (0.25*2) )/(0.4+0.35+0.25)

= (2 + 1.05 + 0.5) / 1

Forecast for computer sales in 13th week = 3.55  (sales in thousands)

Please let me know if you need any clarification. I'm always happy to answer your questions. Kindly best this answer if it has helped you.
Jul 10th, 2015

Awesome job! I appreciate the fact that you showed your work. Thank you so much! :)

Jul 10th, 2015

...
Jul 10th, 2015
...
Jul 10th, 2015
Oct 23rd, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer