The actual number of patients at Omaha Emergency Medical Clinic for the first si
ID: 467584 • Letter: T
Question
The actual number of patients at Omaha Emergency Medical Clinic for the first six weeks of this year follows: Clinic administrator Marc Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago. What is the value of your forecast? The value of the forecast is 69.08 patients (round your response to two decimal places). If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? The value of the forecast will remain the same. The value of the forecast will decrease. The value of the forecast will increase. What if the weights were 0.60, 0.20, 9.10, and 0.10, respectively? Now what is the forecast for week 7? The value of the forecast is patients (round your response to two decimal places).Explanation / Answer
4-month weighted average method
n-month weighted average = [(weight for period n)(sales in period n)]/weights
a.
Week
Actual No. of Patients (At)
Weight (Wt)
Wt x At
1
67
2
68
3
77
0.167
12.859
4
59
0.25
14.75
5
66
0.25
16.5
6
75
0.333
24.975
Total
1
69.084
For recent period given weight of 0.333, 0.25, 0.25,and 0.167 respectively
F7 = 69.084/1
F7 = 69.084
b.
Week
Actual No. of Patients
Weight (Wt)
Wt x At
1
67
2
68
3
77
10
770
4
59
15
885
5
66
15
990
6
75
20
1500
Total
60
4145
For recent period given weight of 20, 15, 15, and 10 respectively
F7 = 4145/60
F7 = 69.084
Thus, the forecast value remains same
c. Revised Weights
Week
Actual No. of Patients
Weight (Wt)
Wt x At
1
67
2
68
3
77
0.1
7.7
4
59
0.1
5.9
5
66
0.2
13.2
6
75
0.6
45
Total
1
71.8
For recent period given weight of 0.6, 0.2, 0.1, and 0.1 respectively
F7 = 71.8/1
F7 = 71.8
The value of Forecast is 71.8 patients
(Note: Please provide more visible images of questions)
Week
Actual No. of Patients (At)
Weight (Wt)
Wt x At
1
67
2
68
3
77
0.167
12.859
4
59
0.25
14.75
5
66
0.25
16.5
6
75
0.333
24.975
Total
1
69.084
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.