Answer a: Forecast of a period with n period moving average = average of last n periods demand
Absolute deviation= |Forecast - Actual|
MAD= mean absolute deviation= sum of absolute deviation/no. of periods
Year, t | Actual , At | 2 period moving average forecast, | Absolute deviation= |Forecast - Actual| |
1 | 3050 | ||
2 | 4000 | ||
3 | 3500 | 3,525.0 | 25.00 |
4 | 3800 | 3,750.0 | 50.00 |
5 | 3700 | 3,650.0 | 50.00 |
6 | 3,750.0 | ||
41.7 | |||
MAD |
Answer b: Weighted Forecast of 6th period = (0.6*sales of most recent period + 0.4*sales of next most recent period) = 0.6*3700 + 0.4*3800 = 3740
Score: 0.2 of 1 pt 3 of 10 (10 complete) HW Score: 84.33%, 8.43 of 10...
Need some help, show steps please 3 of 7 (5 complete) HW Score: 38%, 38 of 100 p Score: 5 of 25 pts Problem 4.5 Question Help 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 Mileage 4,050 3,400 3,750 3.000 a) Using a 2-year moving average, the forecast for year 6...
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: Year12345Mileage3.0504,0003,5003.7503.700a) Using a 2-year moving average, the forecast for year 6 = 3,725 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 = 33.3 miles (round your response to...
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 2 3 4 5 Mileage 3 comma 0003,000 3 comma 9503,950 3 comma 4503,450 3 comma 7503,750 3 comma 7503,750 a) Using a 2-year moving average, the forecast for year 6 = 3750 miles (round your response to the nearest whole...
i need last one 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 4 3,400 Mileage a) using a 2-year moving average, the forecast for year 6-3775 miles (round your response to the nearest whole number. b lf a 2-year m oving average is used to make the forecast, the MAD based...
Can someone help me figure out part C? 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 Mileage 2 4,000 4 5 3,050 3,500 3,800 3,750 a) Using a 2-year moving average, the forecast for year 63,775 miles (round your response to the nearest whole number) b) If a 2-year moving average...
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 2 3 4 5 Mileage 3,000 3,950 3,500 3,750 3,750 a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make...
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: 3000 2: 4050 3: 3500 4: 3850 5: 3800 a) Using a 2-year moving average, the forecast for year 6 = 3825 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make...
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 2 3 4 5 Mileage 3,000 4,000 3,400 3,850 3,750 Using a 2-year moving average, the forecast for year 6 =________ miles (round your response to the nearest whole number).
"The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.45 and 0.55 = __ miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)" Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...
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 2 3 4 5 Mileage 3,100 4,000 3,500 3,800 3,700 d) Using exponential smoothing with alpha α =0.50 and the forecast for year 1 being 3,100, the forecast for year 6 =___miles (round your response to the nearest whole number).