Question: Please Help with the last forecast All is right except the last step please help compute the MAD as well for the last step As

Please Help with the last forecast All is right except the last step please help compute the MAD as well for the last step

Please Help with the last forecast All is right

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: 3 Year Heart Transplants 1 2 46.0 50.0 4 5 57.0 57.0 55.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): 1 2 3 3 4 5 6 Year Forecast 42.0 44.4 47.76 52.104 55.04 56.2 For the forecast made using exponential smoothing with a = 0.60 and the given forecast for year 1, MAD = 4.7392 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 through 6 are (round your responses to one decimal place): Year 2 3 1 1 42.0 4 5 54.5 56.7 6 57 Forecast 45.6 49.6 For the forecast made using exponential smoothing with a = 0.90 and the given forecast for year 1, MAD = 3.3 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 5 6 4 50.33 Forecast 54 56.33 For forecasts made using a 3-year moving average, MAD = 4.835 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!