The following table shows the actual demand observed over the last 11 years:
Year 1 2 3 4 5 6 7 8 9 10 11
Demand 6 9 4 7 11 8 13 14 10 13 6
b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place).
Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Forecast | 6.3 | 6.7 | 7.3 | 8.7 | 10.7 | 11.7 | 12.3 | 12.3 | 9.7 |
c) Using the 3-year weighted moving average with weights 0.15, 0.35 and 0.50, using 0.50 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places).
Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Forecast |