Please write the formulas in Excel and show the steps

1) San Jose State University had received the following number of applications to its Engineering program in the last 5 years. a) What would the 2021 forecast be if made at the end of 2020, using two year moving average method. b) Generate a forecast of demand for the year 2022, using two year moving average method. Calculate MAD, MSE. c) Apply exponential smoothing with a smoothing constant of 0.9 to generate a forecast for demand in 2022. Consider the forecast same as demand for 2017. Calculate MAD \& MSE. d) What would the 2022 forecast be if made at the end of 2021, using exponential smoothing with =.2 and a forecasted value of 12,000 applications for the year 2017? e) Which of these forecasts do you prefer and why