Question: Please show me how to complete this problem in excel Thanks! As you can see in the following table, demand for heart transplant surgery at
Please show me how to complete this problem in excel 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:
| Year | 1 | 2 | 3 | 4 | 5 |
| Heart Transplants | 45.0 | 52.0 | 55.0 | 57.0 | 58.0 |
The director of medical services predicted 6 years ago that demand in year 1 would be 41.0 surgeries.
a) Using exponential smoothing with 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 | 4 | 5 | 6 |
| Forecast | 41.0 | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
For the forecast made using exponential smoothing with = 0.60 and the given forecast for year 1, MAD =
enter your response here
surgeries (round your response to one decimal place).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
