Homework: Homework 1: Forecasting core: 0.47 of 1 pt Problem 4.2a 4 of 8 (8 complete) The following table shows the actual demand observed over the last 11 years: Year 1 2 4 5 7 9 10 3 6 6 8 8 8 8 12 11 7 Demand 8 10 7 11 11 10 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 fround your responses to one decimal place). 7 Year Forecast 4 8.0 5 6 7.7 8.0 8 9 10 11 12 10.0 10.3 11.0 10.3 8.7 8.7 c) Using the 3-year weighted moving average with weights 0.10, 0.25, and 0.65, using 0.65 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Year 4 5 7 8 10 11 12 Forecast Score: 0.5 of 1 pt 5 of 8 (8 complete) Problem 4.3a The following table shows the actual demand observed over the last 11 years: 1 3 6 9 11 Year Demand 2 2 9 4 10 5 11 7 13 8 14 10 9 6 4 8 9 Using exponential smoothing with a = 0.40 and a forecast for year 1 of 5.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). Year 1 3 4 2 5.4 5 7.4 6 8.9 7 8.5 8 10.3 9 10 11.8 10.7 11 10.0 12 8.8 Forecast 5.0 6.8 5.7 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers). Year 2 3 3 5 6 7 8 9 11 12 10 D Forecast Homework: Homework 1: Forecasting Score: 0.4 of 1 pt 6 of 8 (8 complete) Problem 4.5 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 3 4 5 2 4,050 Mileage 3,000 3,400 3,800 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3775 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 = 116.67 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 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = miles (round your response to the nearest whole number)