Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Month 11 15 35.753 -20.753 20.753 430.667 138.35%
Month 12 40 32.640 7.360 7.360 54.175 18.40%
Month 13 55 40.771 -10.771 10.771 116.024 35.90%
Month 14 35 39.156 -4.156 4.156 17.270 11.87%
Month 15 25 38.532 -18.532 18.532 343.449 92.66%
Month 16 55 35.753 -20.753 20.753 430.667 138.35%
Problem 11-23
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Month 1 50 55.000
Month 2 35 51.750 -16.750 16.750 280.563 47.86%
Month 11 15 24.471 -9.471 9.471 89.702 63.14%
Month 12 40 18.315 21.685 21.685 470.244 54.21%
Month 13 55 26.119 3.881 3.881 15.063 12.94%
Month 14 35 28.642 6.358 6.358 40.429 18.17%
Month 15 25 32.775 -12.775 12.775 163.189 63.87%
Problem 11-23
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Month 1 50 55.000
Month 2 35 50.250 -15.250 15.250 232.563 43.57%
Month 10 20 34.727 -14.727 14.727 216.883 73.63%
Month 11 15 20.736 -5.736 5.736 32.906 38.24%
Month 12 40 15.287 24.713 24.713 610.741 61.78%
Month 13 55 20.774 9.226 9.226 85.114 30.75%
Month 14 35 29.539 5.461 5.461 29.826 15.60%
Month 15 25 34.727 -14.727 14.727 216.883 73.63%
Month 16 55 20.736 -5.736 5.736 32.906 38.24%
Problem 11-23
