Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Problem 11-19 (a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Problem 11-19 (a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 440.000
Year 2 525 478.000 47.000 47.000 2209.000 8.95%
Problem 11-19 (a)
Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480
Problem 11-19 (b)
Forecasting Linear trend analysis
Input Data Forecast Error Analysis
Period
Actual value
(or) Y
Period number
(or) X
Forecast Error
Absolute
error
Squared
error
Absolute
% error
Year 1 480 1 484.800 -4.800 4.800 23.040 1.00%
Problem 11-19 (c)