Using Excel:

The owner of Auto Company wants to forecast car sales. Sales for the preceding six years is shown in the table below. a. Using three year moving average method, forecast sales for the fourth to sixth year. b. Using simple exponential smoothing with a = 0.2 and forecast for the third year of 800, forecast sales for the fourth to sixth year. c. Using MSE which is a better forecasting method?