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

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

Forecast Demand
Period Demand F1 F2
1 67 70 70
2 75 70 71
3 69 70 72
4 71 71 73
5 68 71 70
6 70 71 73
7 74 72 73

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

F1
F2

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

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

F1
F2

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

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

F1 %
F2 %

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

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 77.

e. In practice, either MAD, 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 understand. is more sensitive to large forecast errors. is easy to calculate.
MAPE (Click to select) is easy to understand. is more sensitive to large forecast errors. is easy to calculate.
Two different forecasting techniques were used to
c-2. Which technique appears to be more accurate? d-1. Do all three of forecast errors provide the same conclusion (i.e., are they consistent) in this case? d-2. Do you expect consistent results in every case? will have lower MSE than if obs 7 for F1 was 77. e. In practice, either MAD, MSE, or MAPE would be employed to compute a measure of forecast errors. What factors might lead manager to favour one

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!