PLEASE SOLVE USING EXCEL (also Show the formulas Used)

Consider the quarterly sales data for Worthington Health Club shown below: Quarter Total Year 1 2 3 4 Sales 1 6 1 2 7 16 2 9 3 4 16 32 3 9 3 7 14 33 4 16 12 12 7 21 56 5 17 7 12 30 66 a. Develop a four-period moving average model and compute MSE for your forecasts. Do not round intermediate calculations. Round your answers to two decimal places. Time Period Observation Forecast 1 6 2 1 3 2 4 7 5 9 6 3 7 4 8 oc 16 9 9 10 3 11 7 12 14 13 16 14 12 15 7 16 21 17 17 18 7 19 12 20 30 MSE (4-period) b. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. Alpha MSE 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 The model based on a smoothing constant of -Select-0.10.20.30.40.50.60.70.80.9ltem 27 is the best. How does this model compare with the moving average model? The -Select-single exponential smoothing4-period moving averageltem 28 model has the lowest MSE