The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 23 2 3 4 5 6 87 89 96 80 86 93 Clinic administrator Dana 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. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? O A. The value of the forecast will increase. B. The value of the forecast will remain the same. OC. The value of the forecast will decrease. c) What if the weights were 0.50, 0.20, 0.20, 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).
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 23 2 3 4 5 6 87 89 96 80 86 93 Clinic administrator Dana 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. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? O A. The value of the forecast will increase. B. The value of the forecast will remain the same. OC. The value of the forecast will decrease. c) What if the weights were 0.50, 0.20, 0.20, 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).
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...
Related questions
Question
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows:
Week
|
Actual No. of Patients
|
1
|
87
|
2
|
89
|
3
|
96
|
4
|
80
|
5
|
86
|
6
|
93
|
Clinic administrator Dana 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.Part 2
a) What is the value of your forecast?
The value of the forecast is
enter your response here
patients (round your response to two decimal places).Part 3
b) If instead the weights were
20,
15,
15,
and
10,
respectively, how would the forecast change?The value of the forecast will increase.
The value of the forecast will remain the same.
The value of the forecast will decrease.
Part 4
c) What if the weights were
0.50,
0.20,
0.20,
and
0.10,
respectively? Now what is the forecast for week 7?The value of the forecast is
enter your response here
patients (round your response to two decimal places).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 9 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,