Please answer the following in excel format while showcasing the equations used:

2. VCS, a pharmacy, is preparing for the upcoming flu season. VCS sells a flu shot that CDC has guaranteed will be extremely effective during the upcoming season. The flu shot comes in a single-packaged standard vial. VCS is trying to determine how many vials to order for the upcoming season. VCS wants to use the following past data to determine number of flu shots to order. 2 a) Compute the forecast for season 7 using exponential smoothing, an initial forecast for season 4 of 628406 and =0.2, and calculate the MAD, MSE, and MAPE. b) Use trend projection and develop a forecast for the upcoming season. 2. VCS, a pharmacy, is preparing for the upcoming flu season. VCS sells a flu shot that CDC has guaranteed will be extremely effective during the upcoming season. The flu shot comes in a single-packaged standard vial. VCS is trying to determine how many vials to order for the upcoming season. VCS wants to use the following past data to determine number of flu shots to order. 2 a) Compute the forecast for season 7 using exponential smoothing, an initial forecast for season 4 of 628406 and =0.2, and calculate the MAD, MSE, and MAPE. b) Use trend projection and develop a forecast for the upcoming season