please only excel formulas

year 4). 8. a. Develop a 3-year simple moving average forecast (starting in C. Develop an exponential smoothing forecast using a forecast of 5. Use the data from problem 4. b. Develop a weighted moving average forecast using the weights 0.5 and 0.5. 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? H C E D B M4-1(P10.5) a 0.7 B- 0.4 (d) TAES 3 5 Year ED Visits (a) (b) 3-yr SMA WMA(5,5) 0.7 (0) ES 74,000.00 #VALUE! F TAES T 0.50 74,000.00 1 2. 7 3 9 3 4 5 75,000.00 72,800.00 76,000.00 76,400.00 78,000.00 77,300.00 79,200.00 78,000.00 81,000.00 81,500.00 6 7 8 1.50 2.00 3.00 4.00 5.00 6.00 7.00 8.00 0.50 1.50 2.00 3.50 4.50 5.50 6.50 11.50 8.50 9 10 11 Year 10 11 12 13 14 15 16 17 18 e 19 20 21 22 23 24 25 26 27 28 29 (Actual Demand Forcast)^2 3-yr SMA WMA(5,5) ES TAES 1 2 3 4 5 6 7 9 10 7 7 n MSE 30 31 32 33 34 35 36