EXCEL FORMAT!

Week 1 N34567 000 2 8 9 10 11 12 Sales 16 22 18 23 20 16 20 19 20 20 15 25 a. Show the naive forecast, and an exponential smoothing forecasts using a = 0.2, and a 3-month moving average forecast. b. Compare the MAE, MSE, and MAPE on the models c. Make a conclusion on which model to use. d. Find the alpha (smoothing constant) that minimizes the MSE