Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
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
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
Year Mileage
1 3,100
2 4,000
3 3,500
4 4,000
5 3,700
Forecast the mileage for next year using a 2-year moving average__________
Round your answer to the nearest whole number; for example, 1234
Find the MAD for your forecast in part (a)__
Round your answer to the nearest whole number; for example, 123 .
Use a weighted 2-year moving average with weights of .4 and .6 to forecast next year’s mileage. (The weight of .6 is for the most recent year.) __
What is the MAD of this forecast? __
Round your answer to the nearest whole number; for example, 123 .
Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,100 miles, and a =.5
Round your answer to the nearest whole number; for example, 1234 .
© BrainMass Inc. brainmass.com March 21, 2019, 4:30 pm ad1c9bdddf
https://brainmass.com/business/business-management/forecasting-for-carbondale-hospital-purchase-of-new-ambulance-188892
Attachments
Question 3.docx
Solution Preview
here is the solution to your problem. Excel file contains the calculations and word file contains the answers.
Question 3: (1 point)
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 …


