The Questions (you can also find these on the excel sheet) Sheet name: Forecasting 1 Given the following data in the table (you will see it in excel): a) develop a 3 year moving average to forecast demand from year 4-10 (2 points) b) Develop a 3 year weighted moving average forecast for year 4-10, using a weight of 2 for the most recent year, and a weight of 1 for the other 2 years. (3 points) c) Use exponential smoothing with a smoothing constant of 0.2 to forecast through to year 10. Assume the forecast for Year 1 was 175. (3 points) d) Which of the methods seems better? Why? (2 points) Year Demand 1 193 23 2 107 3 160 4 191 5 191 6 100 7 140 8 192 9 119 10