Part 2: Capacity and Forecasting

Chalmers Regional Hospital has recorded its demand for type B Blood Units as follows for the past six-week period:

Part 2 Table
Week of	Units
April 10	340
April 17	389
April 24	406
May 1	394
May 8	414
May 15	422

With the data provided, calculate the number of units that will be required for the week of May 22, using a rolling three-week average.

Using the same data, calculate a weighted average for the rolling three-week periods, using the weighting values of 10% for the oldest period, 30% for the next oldest period, and 60% for the most recent period. What forecast would this provide for the week of May 22 and, also, for the week of May 29?