Marianne Kramer, the owner of Handy Man Rentals, rents carpet cleaners to contra
ID: 3356232 • 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. 1. Week1 2 3 Rentals 19 20 31 10 15 5 17 27 18 18 31 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 6 Forecast 10 What is the forecast for week 11? rentals. (Enter your response rounded to two decimal places.) rentals. (Enter your response rounded b. The mean absolute deviation as of the end of week 10 is to two decimal places.) 1: Definition Moving Average Forecast- The sum of demand across immediate past n-periods divided by the number of periods D+D-1+D-2n+1Explanation / Answer
Answer:
MINITAB used
Moving Average
number of periods:
4
t
Rentals
4MA
1
19
2
20
3
31
4
17
21.75
5
27
23.75
6
18
23.25
7
18
20.00
8
31
23.50
9
11
19.50
10
15
18.75
Forecasts
Period
Forecast
Lower
Upper
11
18.75
3.03587
34.4641
Accuracy Measures
MAPE
43.2793
MAD
7.3750
MSD
64.2813
Moving Average
number of periods:
4
t
Rentals
4MA
1
19
2
20
3
31
4
17
21.75
5
27
23.75
6
18
23.25
7
18
20.00
8
31
23.50
9
11
19.50
10
15
18.75
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.