Marianne Kramer, the owner of Handy Man Rentals, rents carpet cleaners to contra
ID: 455427 • Letter: M
Question
Marianne Kramer, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here.
Week 1 2 3 4 5 6 7 8 9 10
Rentals 22 21 19 24 24 14 20 35 14 17
a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average (Enter your responses rounded to two decimal places.)
Week Forecast
6 ____
7 ____
8 ____
9 ____
10 ____
What is the forecast for week 11?
b. The mean absolute deviation as of the end of week 10 is ____ rentals. (Enter your response rounded to two decimalplaces.)
Explanation / Answer
a. Forecast for week 11 = 21.50
b. MAD = 7.15
Simple Moving Average 4-period Forecast P11 22 MAD = |et|/n MAD 7.15 Ft = (Dt-1 + Dt-2 + Dt-3+ Dt-4)/4 Period Demand Forecast Error Abs Error P Dt Ft et |et| 1 22 2 21 3 19 4 24 5 24 6 14 22.0 -8.0 8.0 7 20 20.3 -0.3 0.3 8 35 20.5 14.5 14.5 9 14 23.3 -9.3 9.3 10 17 20.8 -3.8 3.8 11 21.5 -6.8 35.8Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.