Forecasting 2 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Period 1 4
Period 2 8
Problem 11-13(a)
Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Period 1 4
Period 2 8
Period 3 6
Period 4 6 6.000 0.000 0.000 0.000 0.00%
Period 5 9 6.667 2.333 2.333 5.444 25.93%
Problem 11-13(a)
Forecasting 4 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Period 1 4
Period 2 8
Period 3 6
Problem 11-13(a)
Forecasting 3 period weighted moving average
Input Data Forecast Error Analysis
Period Actual value Weights Forecast Error
Absolute
error
Squared
error
Absolute
% error
Period 1 4 1
Period 2 8 1
Period 3 6 2
Problem 11-13(b)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 4 6.000
Year 2 8 5.200 2.800 2.800 7.840 35.00%
Problem 11-13(c)