Question: -Please show work if you do by hand or excel. I see this problem else were but doesn't explain how you get it Year Heart

-Please show work if you do by hand or excel. I

-Please show work if you do by hand or excel. I

-Please show work if you do by hand or excel. I see this problem else were but doesn't explain how you get it

Year Heart ste 45.0 52.0 52.0 56.0 57.0 Year Forecast 2 43.4 3 48.6 4 50.6 5 53.8 6 55.7 41.0 Year Forecast 1 41.0 2 44.6 3 51.3 4 51.9 5 55.6 6 56.9 Year4 5 6 Forecast 49.67 53.33 55.00 Year 2 3 4 5 6 Forecast TO T 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: The director of medical services predicted 6 years ago that demand in year 1 would be 41.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) For the forecast made using exponential smoothing with a = 0.60 and the given forecast for year 1, MAD = 5.18 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): For the forecast made using exponential smoothing with a = 0.90 and the given forecast for year 1, MAD = 3.55 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) For forecasts made using a 3-year moving average, MAD = 5 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)

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!