Question: Consider the actual sales shown in Table P-2 along with one-step-ahead forecasts produced by Winters' method and by a regression model. a. Construct the combined

Consider the actual sales shown in Table P-2 along with one-step-ahead forecasts produced by Winters' method and by a regression model.

Consider the actual sales shown in Table P-2 along with

a. Construct the combined forecasts of sales produced by taking a simple average of the forecasts produced by Winters' method and the regression model.
b. Construct the combined forecasts of sales produced by taking a weighted aver-age of the Winters' forecasts and the regression forecasts with weights w1 = .8 and w2 = 1 €“ w1 = .2.
c. Using the actual sales, determine the MAPEs for the Winters' forecasts and the regression forecasts.
d. Repeat part c using the combined forecasts from parts a and b. Based on the MAPE measure, which set of forecasts do you prefer?

TABLE P2 ActualWinters' Regression Month Sales Forecasts Forecasts 15,502 4,586 5,263 2 6,535 5,944 6,008 3 7390 6,706 6,832 4 4,388 4,530 4886 5 452 5010 4918 6 5,679 6,574 5.630 7 8,578 8,46 7963 8 7.088 6.415 5,942 9 4,839 4457 5.156 10 4,050 4,638 3819

Step by Step Solution

3.40 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b c Winters forecasts MAPE 98 Regression forecasts MAPE 77 d Averaged ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

628-M-S-L-R (5888).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!