Garish Motors sells new and used automobiles. Sales of new cars over the past 50 weeks are given in the
Question:
Garish Motors sells new and used automobiles. Sales of new cars over the past 50 weeks are given in the following table (week 50 is the most recent).
.png)
a. Compute a forecast for sales next week by using a 4-week moving average. What is the forecast? What is the MSE for the last five observations?
b. Can you reduce the MSE for the last five observations by changing the moving-average window? (Try 5- to 10-week windows.)
c. Compute a forecast for sales next week by using exponential smoothing with α = 0.25. What is the forecast? What is the MSE for the last five observations?
d. Can you improve the MSE for the last five observations by changing the smoothing constant α?
This problem has been solved!
Step by Step Answer:
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker