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,050 | 3,400 | 3,800 | 3,700 |
?a) Using a? 2-year moving? average, the forecast for year 6?= ? miles ?(round your response to the nearestwhole? number).
?b) If a? 2-year moving average is used to make the? forecast,the MAD based on this? = ? miles ?(round yourresponse to one decimal? place). ? (Hint: You will have only 3years 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 yourresponse to the nearest whole number)
The MAD for the forecast developed using a weighted 2-yearmoving average with weights of 0.40 and 0.60 = ?miles (round your response to one decimal place) (Hint:You will have only 3 years matched data.)
d) Using exponential smoothing with ? = 0.20 and the forecastfor year 1 being 3,000 the forecast for year 6 = ?miles (round your response to the nearest wholenumber)