Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Forecasting 3 period weighted moving average
Input Data Forecast Error Analysis
Period Actual value Weights Forecast Error
Absolute
error
Squared
error
Absolute
% error
Week 1 22 1
Week 2 26 3
Problem 11-20(a)
Forecasting Exponential smoothing
Input Data Forecast Error Analysis
Period Actual value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Week 1 22 22.000
Week 2 26 22.000 4.000 4.000 16.000 15.38%
Problem 11-20(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
Week 1 22 1 22.744 -0.744 0.744 0.553 3.38%
Week 2 26 2 23.366 2.634 2.634 6.938 10.13%
Week 3 23 3 23.988 -0.988 0.988 0.977 4.30%
Problem 11-20(c)
