Hospital Operations Analytics: Beds, Flow & Staffing
Occupancy and ALOS, bed-need forecasts, ED door-to-doctor and 4-hour performance, weekday flow, nurse staffing and HPPD, OR utilisation, 30-day readmissions and case mix, cost per case: analyse a hospital's operations in a live spreadsheet that checks every cell.
The first lesson is free — no account needed.
About this course
A hospital operations analytics course that analyses one fictional hospital's beds, patient flow and staffing in a spreadsheet, for healthcare analysts, managers and students. You turn patient days into average daily census, occupancy and ALOS per unit and measure how long a bed stays empty, forecast the beds needed at a target occupancy, measure door-to-doctor times, the left-without-being-seen rate and 4-hour performance in the emergency department, follow admissions, discharges and the census through a typical week, turn nurse ratios into RNs per shift and hours per patient day, measure OR utilisation and turnover times, flag 30-day readmissions and adjust length of stay for the case mix index, and allocate overhead into cost per case and per patient day. Operations analysis only, not clinical guidance. The first lab is free.
Lessons
- Bed Occupancy, Patient Days & ALOSFree
- Bed Need Forecast: Demand × ALOS ÷ Target Occupancy Pro
- Emergency Department: Door-to-Doctor, LWBS & the 4-Hour Target Pro
- Admissions & Discharges by Weekday: Flow Imbalance Pro
- Nurse Staffing Ratios & Hours per Patient Day Pro
- Operating Room Utilisation & Turnover Time Pro
- 30-Day Readmission Rate & Case Mix Index Pro
- Cost per Case & Cost per Patient Day Pro