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
1666969
2757072
3697070
4717168
5687171
6717269
7747271
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)
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)
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)
d-1. Do all three of forecast errors provide the same conclusion (i.e., are they consistent) in this case?
(Click to select)
d-2. Do you expect consistent results in every case?
(Click to select)
,
(Click to select)
will have lower MSE than
(Click to select)
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)
MSE
(Click to select)
MAPE
(Click to select)

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!