Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Forecasting 3 period moving average
Input Data Forecast Error Analysis
Period Actual Value Forecast Error
Absolute
error
Squared
error
Absolute
% error
Month 1 9
Month 2 12
Month 3 14
Month 4 811.667 -3.667 3.667 13.444 45.83%
Month 5 13 11.333 1.667 1.667 2.778 12.82%
Problem 11-22(a)
0
2
4
14
16
12345678910 11 12 13
Time
Moving Average
Forecasting 3 period weighted moving average
Input Data Forecast Error Analysis
Period Actual value Weights Forecast Error
Absolute
error
Squared
error
Absolute
% error
Month 1 9 1
Month 2 12 2
Month 3 14 3
Month 4 8 12.500 -4.500 4.500 20.250 56.25%
Month 5 13 10.667 2.333 2.333 5.444 17.95%
Problem 11-22(b)
0
2
4
6
14
16
1 2 3 4 5 6 7 8 9 10 11 12 13
Period
Weighted Moving Average
