Do it in excel sheet

Homework 2 (Forecasting) - Protected View ut Formulas Data Review View Help rom the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing B H A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 03) 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: a) Forecast the mileage for next year (6th year) using a 2-year moving average. b) Find the MAD based on the 2-year moving average (Hint: You will have only 3 years of matched data.) 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 MAD results from using this approach to forecasting? (Hint: You will have only 3 years of matched data.) d) Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,000 miles, and a 5. Year 1 2 3 4 Mileage 3000 40 3400 3800 3700 5 21 R gi 03 04 to search