Homework: Hw2... Question 4. Problem 4.5 HW Score: 30 O Points: 0 of 3 Boints Part 4 of 5 Save The Carbondale Hospital is considering the purchase of a new ambulance The decision will rest putly on the anticipated mileage to be driven next year The mles chven during the past 5 years are as follows Year 1 2 3 4 5 Mileage 3.100 3,950 3.450 3,800 3,750 5) Using a 2 year moving average, the forecast for year 6 = 3775 miles fround your response to the nearest whole number) b) If a 2 yow moving average is used to make the forecast, the MAD based on this = 100 mies (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 0 35 and 65 the weight of 0.65 is for the most recent penod) - 3768 miles (round your response to the newest whole number) The MAD for the forecast developed using a weighted 2 year moving average wth weights of 0 35 and 065 -miles fround your response one decimal place) Print You will have only 3 years of matched data)