Carbondale Hospital Considering Purchase New Ambulance Decision Rest Partly Anticipated Mi Q34743577

The Carbondale Hospital is considering the purchase of a newambulance. The decision will rest partly on the anticipated mileageto be driven next year. The miles driven during the past 5 yearsare as​ follows:

                                                                                                                 

Year

1

2

3

4

5

Mileage

3,000

4,000

3,400

3,750

3,800

​a) Using a​ 2-year moving​ average, the forecast for year 6​ =? miles ​(round your response to the nearest whole​ number).

​b) If a​ 2-year moving average is used to make the​ forecast,the MAD based on this​ = ? miles ​(round your response to onedecimal​ place). ​ (Hint: You will have only 3 years of matched​data.)

​c) The forecast for year 6 using a weighted​ 2-year movingaverage with weights of 0.40 and 0.60 (the weight of 0.60 is forthe most recent​ period) = ? miles ​(round your response to thenearest whole​ number).

The MAD for the forecast developed using a weighted​ 2-yearmoving average with weights of 0.40 and 0.60 ​= ? miles ​(roundyour response to one decimal​ place).  ​(Hint: You will have only 3years of matched​ data.)

​d) Using exponential smoothing with alpha α​=0.20 and theforecast for year 1 being 3,000​, the forecast for year 6​ =? miles​(round your response to the nearest whole​ number).

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply