Question: . Read Section 8 . 2 ( 4 1 7 - 4 2 1 ) 2 . Use Excel file, BB 8 A Data.xlsx ,

. Read Section 8.2(417-421)
2. Use Excel file, BB 8A Data.xlsx, attached.
3. Plot actual demand versus forecast demand by plotting both, Actual and
Forecast in order of time index.
4. Based on the chart identify periods of forecast with high error ( in a text
box).
5. Calculate three measures of forecast accuracy (error):
a. MAE - Mean Absolute Error = MAD: Mean Absolute Deviation
b. MAPE - Mean Absoluter Percent Error
c. MSE Mean Squared Error. Read Section 8.2(417-421)
2. Use Excel file, BB 8A Data.xlsx, attached.
3. Plot actual demand versus forecast demand by plotting both, Actual and
Forecast in order of time index.
4. Based on the chart identify periods of forecast with high error ( in a text
box).
5. Calculate three measures of forecast accuracy (error):
a. MAE - Mean Absolute Error = MAD: Mean Absolute Deviation
b. MAPE - Mean Absoluter Percent Error
c. MSE Mean Squared Error

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!