1. Three-period moving average forecast for periods 11-13. See table 2 as an example below.
2. Develop a two period weighted moving average forecast for periods 11-13. Use weights of 0.3 for month 11, 0.5 for month 12, and 0.7 for month 13 consecutively. See table 3 as an example below.
3. Develop an exponential smoothing forecast ( α = .3). Your forecasts are already calculated from exercise I. See table 4 below.
Month(X) Actual
Demand(Y) Forecasted
Demand Seasonal Index Moving Average Weighted Moving Average Exponential Smoothing
X Y
1 8
2 12
3 25
4 40
5 50
6 65
7 36 56
8 61 63
9 88 70
10 63 78
11 85
12 90
13 95