Please give an explanation for each question; preferably through excel is possible. Thanks!

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: 1 2 3 4 5 Year Heart Transplants 46.0 48.0 53.0 56.0 58.0 The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries. a) Using exponential smoothing with a of 0.60 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year 1 2 3 6 4 5 50.4 53.8 Forecast 42.0 44.4 46.6 56.3 For the forecast made using exponential smoothing with a = 0.60 and the given forecast for year 1, MAD = 4.8 surgeries (round your response to one decimal place). Using exponential smoothing with a of 0.90 and the given forecast for year 1, the forecasts for years 2 throug 6 are (round your responses to one decimal place): Year 1 2 3 4 5 6 Forecast 42.0 45.6 47.8 52.5 55.7 57.8 For the forecast made using exponential smoothing with a = 0.90 and the given forecast for year 1, MAD = 3.5 surgeries (round your response to one decimal place). b) Forecasts for years 4 through 6 using a 3-year moving average are (round your responses to one decimal place): Year 4 5 6 Forecast 49.0 52.3 55.7 For forecasts made using a 3-year moving average, MAD = 6.4 surgeries (round your response to one decimal place). c) Forecasts for years 1 through 6 using the trend-projection method are (round your responses to one decimal place): Year 1 2 3 4 5 6 Forecast 45.8 49.0 52.2 55.4 58.6 61.8 For forecasts made using the trend-projection method, MAD = 0.6 surgeries (round your response to one decimal place). d) Based on the comparison of MAD, the best forecast is achieved using the Trend-Projection method