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

80.2K

Verified Solution

Question

General Management

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:

Year12345
Mileage3,0004,0503,4003,8003,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)

Answer & Explanation Solved by verified expert
4.4 Ratings (812 Votes)
Do give a    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students