The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows. Week 1 2 3 4 5 6 VA The value of the forecast will remain the same. OB. The value of the forecast will increase. OC. The value of the forecast will decrease, Actual No. of Patients 27 29 36 20 24 35 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 metho 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 28.67 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? 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 1 2 3 4 5 6 VA The value of the forecast will remain the same. OB. The value of the forecast will increase. OC. The value of the forecast will decrease, Actual No. of Patients 27 29 36 20 24 35 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 metho 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 28.67 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? 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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing