The Carbondale Hospital is considering the purchase of a new

The Carbondale Hospital is considering the purchase of a new

The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows:
  
Year
1
2
3
4
5
Mileage
3,000
3,950
3,500
3,750
3,700
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 one decimal place). (Hint: You will have only 3 years of matched data.)
c) The forecast for year 6 using a weighted 2-year moving average with weights of .40 and .60 (the weight of .60 is for the most recent period) = (?) miles (round your response to the nearest whole number).
The MAD for the forecast developed using a weighted 2-year moving average with weights of .40 and .60 = (?) miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)
d) Using exponential smoothing with alphaa = .20 and the forecast for year 1 being 3,000 , the forecast for year 6 = (?) miles (round your response to the nearest whole number).
If you could show me how to solve this with the answers that would be very helpful. Thanks!

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.

Discount Code: CIPD30

Click ORDER NOW..