Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
How would you do this correctly on excel ? The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of
How would you do this correctly on excel ?
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 AN Actual No. of Patients 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 88.50 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 decrease. XB. The value of the forecast will increase. c*c. The value of the forecast will remain the same. c) What if the weights were 0.60, 0.20, 0.10, and 0.10, respectively? Now what is the forecast for week 7? The value of the forecast is 90.60 patients (round your response to two decimal places)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669907a288111_994669907a210b7b.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started