*Please show steps in EXCEL* Step by Step

The annual demand for lime bags at McCall's Garden Supply for the past 11 years is provided below: Year 1 Bags ('000s) 4 8 6 2 3 4 6 5 6 9 8 7 7 8 9 9 13 14 10 11 16 12 a. Use 2-year, 3-year, and 4-year moving averages to forecast demand in year 12. b. Forecast demand with a 3-year weighted moving average in which demand in the most recent year is given a weight of 2 and demands in the other two years are each given a weight of 1. C. Forecast demand for year 12 by using exponential smoothing with a smoothing constant of 0.4. Assume that the forecast for year 1 is 6,000 bags to begin the procedure. (10 pts) d. Which of the methods analyzed here would you use for year 12 and beyond? Answer by making forecasts for years 5-11 using each of the above methods and then calculating the mean absolute percent error (MAPE)