Using the data below, complete the following questions by hand or in Excel (note: I want to see all of your work to be able to give partial credit):

Period	Month	Actual Issues Remediated
1	March	355
2	April	234
3	May	267
4	June	189
5	July	301
6	August	222
7	September	245
8	October	432
9	November	324
10	December	187

1. Use a 3-month moving average model to forecast issues remediated for periods 6-10. (15 points)

2. Use a 5-month moving average model to forecast issues remediated for periods 6-10. (15 points)

3. Use an exponential smoothing model with a =.2 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). (15 points)

4. Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5) (15 points)

5. Compare the forecasts in questions 1 through 4. Which is best? Why? Support your answer. (20 points)

6. Starting with your solution to question 4, complete a double smoothing model for periods 6-10 for issues remediated. Again here, assume a beginning forecast of 320 for period 5. How does this model perform compared to question 4? Support you answer with statistics. (15 points)