Question

In: Other

The following table gives the number of pints of type A blood used at Damascus Hospital...

The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: 

Week OfPints Used
August 31350
September 7389
September 14408
September 21378
September 28371
October 5374

a) The forecasted demand for the week of October 12 using a 3-week moving average =pints (round your response to two decimal places). 


b) Using a 3 -week weighted moving average, with weights of 0.20,0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12=_______ pints (round your response to two decimal places and remember to use the weights in appropriate order - the largest weight applies to most recent period and smallest weight applies to oldest period.)


c) If the forecasted demand for the week of August 31 is 350 and α = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places).

Week OfPints UsedForecast for this Date
August 31350350
September 7389350.00
September 14408359.75
September 21378
September 28371
October 5374
October 12-


Solutions

Expert Solution

a) Using the three period moving average method

F(October 12) = {Actual(September 21) + Actual(September 28) + Actual(October 5)}/3

= (378+371+374)/3

= 374.33

b) Using the 3 week weighted moving average method

F(October 12) = 0.5*Actual(October 5) + 0.3*Actual(September 28) + 0.2*Actual(September 21(

= 0.5*374 + 0.3*371 + 0.2*378

= 373.9

c) using the Exponential Smoothing method

F(September 21) = 0.25*Actual(September 14) + (1-0.25)*F(September 14)

= 0.25*408 + 0.75*359.75

= 371.81

F(September 28) = 0.25*378 + 0.75*371.81

= 373.36

F(October 5) = 0.25*371 + 0.75*373.36

= 372.77

F(October 12) = 0.25*374 + 0.75*372.77

= 373.08


Related Solutions

The following table gives the number of pints of type A blood used at Damascus Hospital...
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week OfPints UsedAugust 31350September 7372September 14408September 21378September 28366October 5378a) The forecasted demand for the week of October 12 using a 3-week moving average = _______  pints (round your response to two decimal places).
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks Week OfPints UsedAugust 31360September 7370September 14410September 21381September 28366October 5378 a) The forecasted demand for the week of October 12 using a 3-week moving average = _______  pints . b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = _______ points.  (round...
3) The following gives the number of pints of type B blood used at Woodlawn Hospital...
3) The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: WEEK OF PINTS USED August 31 360 September 7 389 September 14 410 September 21 381 September 28 368 October 5 374 Forecast the demand for the week of October 12 using a 3-week moving average. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and α =...
The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks.
The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks.WEEK OFPINTS USEDAugust 31360September 7389September 14410September 21381September 28368October 5374a. Forecast the demand for the week of October 12 using a 3-week moving average.b. Use a 3-week weighted moving average, with weights of .1, .3, and .6 using .6 for the most recent week. * Then, forecast demand for the week of October 12.c. Compute the forecast for the week of October...
1. The following table gives the systolic blood pressure and age of patients. Systolic Blood Pressure...
1. The following table gives the systolic blood pressure and age of patients. Systolic Blood Pressure Age 131 34 132 36 122 30 119 32 123 26 115 23 137 37 a) Determine an r value for this data and classify the value as weak, moderate, or strong. b) Based on your calculated r value, what can you say about the slope of the regression line? c) Determine the model equation. This is also called the regression line or the...
Researchers at a hospital lab are studying the relationship between blood type and a type of...
Researchers at a hospital lab are studying the relationship between blood type and a type of surgical procedure. Typically, they hypothesize that distribution of blood type of people undergoing surgery should be similar to that of the population it serves. The distribution of the population that the hospital services is: 44% type O, 45% Type A, 8% Type B and 3% Type AB. They have blood type data on 187 patients who underwent the surgery at that hospital as follows:...
The following table gives the projected number of workers in various categories in Springfield in 2020....
The following table gives the projected number of workers in various categories in Springfield in 2020. White Black Asian Latino Male 49,813 6,089 2,786 10,042 Female 36,021 6,673 2,088 5,662 Total 85,834 12,762 4,874 15,704 What is the total number of workers represented in the table? workers (a) Use the table to find the following probabilities. One of the represented workers is chosen at random. Find the probability that the person is Latino. (Round your answer to five decimal places.)...
The following table is used for a number of questions below. The table above shows the...
The following table is used for a number of questions below. The table above shows the responses of a survey of teenagers aged 14-18 when asked at what age they thought they would become financially independent. Age of Financial Independence Number of Responses 16-20 191 21-24 467 25-27 244 28 or older 42 What do the teens expect is the probability of being financially independent before age 25? A recent Gallup poll found that only 14 percent of 24- to...
A woman has blood type A. Her partner has type O. She gives birth to a...
A woman has blood type A. Her partner has type O. She gives birth to a child with type O. What was the chance their child would have that blood type? Select one: a. 100% b. 50% c. 25% d. 0% e. Can’t be determined A woman has blood type A. Her partner has type A. She gives birth to a child with type A. What was the chance their child would have type A blood? Select one: a. 100%...
IV. The following table gives the frequency distribution of the number of hours spent per week...
IV. The following table gives the frequency distribution of the number of hours spent per week on activities that involve sports and/or exercise by a sample of 400 Americans. The numbers are consistent with the summary results from the Bureau of Labor Statistics' American Time Use Survey (www.bls.gov). Hours per Week Number of People 0 to less than 3.5 34 3.5 to less than 7.0 92 7.0 to less than 10.5 55 10.5 to less than 14.0 83 14.0 to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT