Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Semester 1 2.4
Semester 2 2.9
Semester 3 3.1
Problem 11-14(a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Semester 1 2.4 2.400
Semester 2 2.9 2.400 0.500 0.500 0.250 17.24%
Semester 3 3.1 2.550 0.550 0.550 0.303 17.74%
Problem 11-14(b)
Forecasting 3 period weighted moving average
Input Data Forecast Error Analysis
Period Actual value Weights Forecast Error
Absolute
error
Squared
error
Absolute
% error
Semester 1 2.4 0.000
Semester 2 2.9 0.500
Problem 11-14(d)