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

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!