Question: Two different forecasting techniques were used to forecast the demand for cases of bottled water in a store. Actual demand and the two sets of

Two different forecasting techniques were used to forecast the demand for cases of bottled water in a store. Actual demand and the two sets of forecasts for the seven periods are as follows:

Forecast Demand
Period Demand F1 F2
1 71 70 71
2 75 72 71
3 70 73 70
4 72 74 71
5 74 75 73
6 76 77 78
7 81 78 78

a-1.Calculate the MAD for each set of forecasts.(Round the final answersto 2decimal places.)

F1

F2

a-2.Which technique appears to be more accurate? (Click to select) F1 F2

b-1.Calculate the MSE for each set of forecasts.(Round the final answersto 2decimal places.)

F1

F2

b-2.Which technique appears to be more accurate? (Click to select) F1 F2

c-1.Calculate the MAPE for each set of forecasts.(Round the final answersto 2decimal places.)

F1

%

F2

%

c-2.Which technique appears to be more accurate? (Click to select) F2 F1

d-1.Do all three of forecast errors provide the same conclusion (i.e., are they consistent) in this case? (Click to select) No Yes

d-2.Do you expect consistent results in every case? (Click to select) Yes No , (Click to select) F1 F2 will have lower MSE than (Click to select) F1 F2 if obs 7 for F1 was 83.

e. In practice,eitherMAD, MSE, or MAPE would be employed to compute a measure of forecast errors. What factors might lead a manager to favour one?

MAD (Click to select) is more sensitive to large forecast errors. is easy to calculate. is easy to understand.
MSE (Click to select) is easy to calculate. is more sensitive to large forecast errors. is easy to understand.
MAPE (Click to select) is more sensitive to large forecast errors. is easy to calculate. is easy to understand.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To analyze the accuracy of the two forecasting techniques F1 and F2 for the demand of bottled water well calculate three error metrics Mean Absolute Deviation MAD Mean Squared Error MSE and Mean Absol... 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

Students Have Also Explored These Related General Management Questions!