Please solve every step

Use the data from Bodville General Hospital for the past 5 years below. You are the hospital's manager, and are considering the best forecasting methods. Accordingly, you need to calculate the forecasts as instructed, and the errors for each method. Begin error calculation in year 3, so all methods are compared for the same years. Note: For each forecasting method, calculate these measures and keep one decimal: i. Average forecast error ii. the mean absolute percent error (MAPE), iii. Mean squared error (MSE), a. Exponential smoothing, with a=0.75. Let the initial forecast for year 1 be 46 . b. Trend projection (hint: you need to create a regression equation using MS Excel) c. Two- year weighted moving average, using weights 0.6 and 0.4 , with more recent data given more weight. d. If Avg forecast error is chosen, which forecasting method should it choose? e. If MAPE is chosen, which forecasting method should it choose? f. If MSE is chosen, which forecasting method should it choose