Page 1 of 1

The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated

Posted: Wed Jul 06, 2022 6:06 am
by answerhappygod
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
3,950
3,500
3,850
3,800
Part 2
​a) Using a​ 2-year moving​ average, the forecast foryear 6​ =
38253825
miles ​(round your response to the nearestwhole​ number).
Part 3
​b) If a​ 2-year moving average is used to makethe​ forecast, the MAD based on this​ =
91.791.7
miles ​(round your response to one decimal​ place).​ (Hint: You will have only 3 years ofmatched​ data.)
Part 4
​c) The forecast for year 6 using a weighted​ 2-year movingaverage with weights of
0.45 and 0.55 ​(the weight of 0.55 is for the mostrecent​ period) =
enter your response here __________________________miles​(round your response to the nearest whole​ number).