I need instructions on how to do this on excel please.

pie exponential ers for 7 smoothing with a = 0.2. Assume that the forecast for b. Forecast the sales for July using simple exponential smoothing with a = 0.4. Assume that the forecast for C. Which of the two forecasting methods should James Triton use? Compute the MAD to help James decide. a. Forecast the sales or February (F) is the nave forecast. 8 12 February (F) is the nave forecast. 4. Trinity General Hospital had the following number of patient admissions during the past 8 weeks: 2 Week 3 4 5 | 6 7 120 145 95 112 130 110 100 140 Patient Admissions ing a. Develop a 3-week weighted average forecast for Week 4 through 9 with weights of W, = 0.5, W2 = 0.3, and W, = 0.2 b. Forecast patient admissions for Week 9 using simple exponential smoothing with a = 0.2. Assume that the forecast for Week 4 (FA) is the nave forecast. c. Use the MSE to determine which of the two forecasting methods is more accurate