Year 1 2 3 4 5 6 7 8 9 10 11
Demand 7 9 5 9 13 8 12 13 9 11 7
1. Plot above data on a graph. Do you observe any trend, cycles or random variation?
2. Starting in year 4 and moving to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data
3. Starting in year 4 and moving to year 12, forecast demand using a 3-year moving average with weighs of 0.1, 0.3 and 0.6, using 0.6 for the most recent year. Plot your forecast on the same graph as the original data
4. As you compare forecast with the original data, which seems to give better results?