Question

In: Other

​The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows:

The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows: 

WEEKACTUAL NO. OF PATIENTS
165
262
370
448
563
652

Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three periods ago. 

a) What is the value of your forecast? 

b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? Explain why.

Solutions

Expert Solution

a) using the 4 period weighted moving average method,

F(7) = 0.333*Actual(6) + 0.25*Actual(5) + 0.25*Actual(4) + 0.167*Actual(3)

= 0.333*52 + 0.25*63 + 0.25*48 + 0.167*70

= 56.756

b) if the ratio is 20:15:15:10

The weights will be 0.333, 0.25, 0.25 and 0.167

Hence the forecast will be same again

c) using the new weights

F(7) = 0.4*52 + 0.3*63 + 0.2*48 + 0.1*70

= 56.3


Related Solutions

The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks...
The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks of this       year are as follows: Week                   Actual # of Patients 65 66 70 58 63 54 Compute a simple exponential smoothing forecast for week 7 with ?=.5.   Assume the forecast for week 1 is 65. b)Compute MAPE. c)What is the interpretation of your answer in part b)?
The actual demand for the patients at Omaha Emergency MedicalClinic for the first 6 weeks...
The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows:  Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three periods ago.  a)...
During the last 10 hours a total of 23 patients arrived at an emergency clinic with...
During the last 10 hours a total of 23 patients arrived at an emergency clinic with one doctor. The average time for the doctor to examine a patient is 21.5 minutes.   What is the average number of patients waiting to be assisted? What is the average time waiting to be assisted (in minutes)? What is the probability there are no patients waiting? What is the probability there are at most 2 patients waiting? Please provide the answer as: =x.x patients...
If the ovaries are removed in the first 6 weeks of pregnancy, there will be a...
If the ovaries are removed in the first 6 weeks of pregnancy, there will be a miscarriage and the embryo will be lost. If they are removed later in the pregnancy, the pregnancy can go to full term without the baby being affected. Explain the difference
You are the nurse manager of an outpatient medical clinic. Your patients are diagnosed with heart...
You are the nurse manager of an outpatient medical clinic. Your patients are diagnosed with heart failure. You have noticed that recently, patients have seemed unhappy with the care they receive in your office. You want to design a quality improvement project to increase patient satisfaction with their office visit. You do not know specifically why patients are unhappy. You will create a plan to gather information to help you understand why patients are unhappy with their care. Please do...
Red Royal Industrial is evaluating the medical clinic project. During year 1, the medical clinic project...
Red Royal Industrial is evaluating the medical clinic project. During year 1, the medical clinic project is expected to have relevant revenue of 647,200 dollars, relevant variable costs of 207,600 dollars, and relevant depreciation of 63,700 dollars. In addition, Red Royal Industrial would have one source of fixed costs associated with the medical clinic project. Red Royal Industrial just signed a deal with Orange Valley Consulting to develop an advertising campaign for use in the project. The terms of the...
The actual demand data for an item at a local retailer during the past six weeks...
The actual demand data for an item at a local retailer during the past six weeks are shown below: WEEK ACTUAL DEMAND (number of units) Six weeks ago 202 Five weeks ago 201 Four weeks ago 199 Three weeks ago 200 Two weeks ago 203 One week ago 198 THIS WEEK ACTUAL DEMAND NOT KNOWN Determine the demand forecast for THIS WEEK using each of the following methods: a. A 3-week moving average. [3] b. A 4-week weighted moving average...
A large medical clinic is working on improving waiting times for patients. While some delays are...
A large medical clinic is working on improving waiting times for patients. While some delays are inevitable, for example due to doctors having to deal with urgent cases, having patients wait more than 15 minutes past their appointment time is considered excessive. Through patient surveys the clinic management has learnt that only 25% of the patients were able to see their doctor without waiting more than 15 minutes; 5% said they had to wait over 60 minutes. The clinic management...
The client has come to the clinic for her first prenatal visit at 18 weeks gestation....
The client has come to the clinic for her first prenatal visit at 18 weeks gestation. After the nurse explains the prenatal visit schedule. The client states, “I don’t really see any need to come back until I go into labor.” How should the nurse respond? A woman who had twins, then one preterm infant, and is now pregnant again, what is her OB score? (GP TPAL). The client who is 28 weeks gestation complains of fatigue. She reports difficulty...
c) Patients arrived at hospital emergency department follows a Poisson distribution with a mean of 4...
c) Patients arrived at hospital emergency department follows a Poisson distribution with a mean of 4 patients per hour. i. In any 90 minutes period of time, find the probability that exactly 10 patients arrived. ii. Find the standard deviation of the number of patients arriving at the hospital.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT