using the following data in excel compute the following forecast. show excel formulas

a. Forecast for Years 2-7 using Exponential Smoothing with =0.6 (Let the Initial Forecast for Year 1 be 45 , the same as the annual demand b. Forecast for Year 2-7 using Exponential Smoothing with =0.4 (Let the Initial Forecast for Year 1 be 45 , the same a5 the annual demand. c. Projected Forecast for Year 7 using regression. Note: When asked to develop a regression equation, you can use the SLOPE and INTERCEPT functions in Excel to come up with the " a " and " b " and then create the equation from that. d. Three-period weighted moving average forecast for Year 7 using the weights . 5,4, and . 1 with the largest weight used for the most recent demand. e. Last period (naive forecast) for Year 7 . f. Three period moving average forecast for Year 7