Bed and capacity KPIs
✓ Verified
Across 304 calendar days, bed occupancy was 85.1% against a target of 85%, with an average length of stay of 5.00 days and a turnover interval of 0.87 days (11,073 discharges; 55,371 patient days). Occupancy ranged from 2.4% in Ward 8 to 131.7% in Ward 4. At the target, 214.3 beds would be needed against 214 staffed beds (net gap 0.3). In 25 of 130 unit-periods occupancy exceeded one hundred percent, which points to patient days being credited to the discharge month rather than true over-occupancy. Between Jan–Jun and Jul–Oct, occupancy moved from 88.5% to 80.1% and the average length of stay from 5.42 to 4.44 days (change -0.99).
| Ward | Beds | Occupancy % | ALOS | Discharges | Gap at 85% |
|---|---|---|---|---|---|
| Ward 4 | 26 | 131.72 | 3.82 | 2,722 | 14.29 |
| Ward 7 | 31 | 100.66 | 6.63 | 1,431 | 5.71 |
| Ward 10 | 5 | 97.96 | 10.27 | 145 | 0.76 |
| Ward 6 | 31 | 94.39 | 5.96 | 1,493 | 3.42 |
| Ward 2 | 30 | 93.62 | 5.50 | 1,553 | 3.04 |
| Ward 9 | 6 | 87.83 | 8.26 | 194 | 0.20 |
| Ward 5 | 10 | 83.98 | 7.15 | 357 | -0.12 |
| Ward 1 | 31 | 66.60 | 5.05 | 1,244 | -6.71 |
| Medical ICU | 5 | 64.08 | 6.01 | 162 | -1.23 |
| Ward 3 | 18 | 60.18 | 2.83 | 1,163 | -5.26 |
| Ward 11-BMT | 8 | 54.85 | 6.44 | 207 | -2.84 |
| Surgical ICU | 7 | 22.37 | 1.40 | 341 | -5.16 |
| Ward 8 | 6 | 2.41 | 0.72 | 61 | -5.83 |
| Period | Occupancy % | ALOS | Discharges / month | Turnover |
|---|---|---|---|---|
| Jan–Jun | 88.50 | 5.42 | 1,053.17 | 0.70 |
| Jul–Oct | 80.13 | 4.44 | 1,188.50 | 1.10 |
- ✗ No values above 100%
- ℹ Transfers counted as discharges
- ℹ Patients still in bed at the period end
XmR control chart
✓ Verified
An XmR control chart of PatientDays/BedDays over 10 periods had a centre line of 85.15, an upper control limit of 117.33 and a lower control limit of 52.96. 0 points fell outside the limits and 0 special-cause signals were found. The series shows common-cause (normal) variation only. Note: the check “enough periods” did not pass.
| Month | PatientDays/BedDays | Moving range |
|---|---|---|
| Jan | 71.63 | |
| Feb | 89.04 | 17.40 |
| Mar | 79.27 | 9.76 |
| Apr | 97.43 | 18.16 |
| May | 101.07 | 3.64 |
| Jun | 93.05 | 8.02 |
| Jul | 99.80 | 6.75 |
| Aug | 83.22 | 16.58 |
| Sep | 63.86 | 19.36 |
| Oct | 73.09 | 9.23 |
- ✗ Enough periods
XmR control chart
✓ Verified
An XmR control chart of PatientDays/Discharges over 10 periods had a centre line of 5.04, an upper control limit of 7.19 and a lower control limit of 2.90. 0 points fell outside the limits and 0 special-cause signals were found. The series shows common-cause (normal) variation only. Note: the check “enough periods” did not pass.
| Month | PatientDays/Discharges | Moving range |
|---|---|---|
| Jan | 4.93 | |
| Feb | 6.23 | 1.30 |
| Mar | 5.37 | 0.86 |
| Apr | 5.23 | 0.14 |
| May | 5.90 | 0.67 |
| Jun | 5.02 | 0.88 |
| Jul | 5.59 | 0.57 |
| Aug | 4.40 | 1.19 |
| Sep | 3.50 | 0.91 |
| Oct | 4.24 | 0.75 |
- ✗ Enough periods
What if stays were shorter?
Released bed days = discharges × reduction, capped at each unit's patient days.