1. The following gives the number of pints of type B blood used at Woodlawn Hosp

Question

1. The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks WEEK OF August 31 September 7 September 14 September 21 September 28 October 5 PINTS USED 360 389 410 381 368 374 a) 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. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = .2

Explanation / Answer

a) Demand for week of Oct 12 using a 3 wk moving average = (374+368+381)/3 = 374.33

b) 3 wk weighted moving average forecast for the week of Oct-15 = (0.6*374+0.3*368+0.1*381)/(0.6+0.3+0.1) = 372.9

c) Forecast for 7-Sept = 360 + (360-360)*0.2 = 360

Forecast for 14-Sep = 360+(389-360)*0.3 = 365.8

Forecast for 21-Sep = 365.8+(410-365.8)*0.2 = 374.64

Forecast for 28-Sep = 374.64+(381-374.64)*0.2 = 375.91

Forecast for 5-Oct = 375.91+(368-375.91)*0.2 = 374.33

Forecast for 12-Oct = 374.33+(374-374.33)*0.2 = 372.9

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.