Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management

Authors: William J Stevenson, Mehran Hojati

4th Canadian edition

978-1259270154, 1259270157, 978-0071091428

More Books

Students also viewed these General Management questions

Question

What is the work environment like? Friendly/collegial?

Answered: 1 week ago