please provide step by step directions in excel format and any needed for formula

D E F G K B M4-1(P10.5) M CT C 0.7 Year B 0.4 (d) TAES T 0.50 (a) (b) 3-yr SMA WMA(-5,5) ED Visits 0.7 (c) ES 74,000.00 TAES F 74,000.00 1 75,000.00 2 72,800.00 376,000.00 4 76,400.00 5 78,000.00 6 77,300.00 7 79,200.00 8 78,000.00 9 81,000.00 10 81,500.00 11 e Year (Actual Demand-Forcast)^2 3-yr SMA WMA.5,5) ES TAES 8 1 2 3 4 5 6 7 8 5 9 10 n MSE 7 8 9 90 31 32 33 34 35 36 37 38 39 a. Develop a 3-year simple moving average forecast (starting in b. Develop a weighted moving average forecast using the c. Develop an exponential smoothing forecast using a forecast of 5. Use the data from problem 4. weights 0.5 and 0.5. year 4). 74,000 visits for year 1 and a = 0.7. d. Develop a trend-adjusted exponentially smoothed forecast using an initial forecast of 74,000 visits for year 1 and an initial trend adjustment of 0.5. The smoothing constants selected are a = 0.7 and = 0.4. e. Compute the MSE for each one of the aforementioned methods (disregard the first data point for the exponential smoothing and trend-adjusted exponential smoothing models). Based on your results, which forecasting method would yield the best results? Using that method, what is the forecast for next year