Please Show work on excel step by step!!

The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past several years. The hospital's administration is seeking the best method to forecast the demand for such surgeries in year 6. The data for the past five years are shown below. Year 1 2 3 4 5 Demand 45 46 52 57 59 The hospital's administration is considering the following forecasting methods. Begin error measurement in year 3, so all methods are compared for the same years. i. Exponential smoothing, with a = 0.6. Let the initial forecast for year 1 be 45, the same as the actual demand. ii. Exponential smoothing, with a = 0.9. Let the initial forecast for year 1 be 45, the same as the actual demand. iii. Trend projection with regression. iv. Two-year moving average. v. Two-year weighted moving average, using weights 0.6 and 0.4, with the more recent data given more weight. If MAD is the performance criterion chosen by the administration, which forecasting method should it choose