Care Home Operations: Occupancy, Staffing Ratios & Cost per Resident Day
Occupancy and resident days, fee income by funding type, care hours per resident, rota gaps and the agency premium, cost per resident day, break-even occupancy, waiting-list forecasts and falls per 1,000 bed days: run a care home's numbers in a live spreadsheet that checks every cell.
The first lesson is free — no account needed.
About this course
A care home operations course that runs one fictional residential care home's numbers in a spreadsheet, for care home managers, owners, finance staff and health and social care students. You turn resident days into occupancy and average residents per wing, compare fee income and weekly fees of self-funded and publicly funded residents, convert the shift pattern into care hours per resident per day and the extra staff a shortfall needs, fill rota gaps and price the agency premium against bank staff, calculate cost per resident day by category with SUMIFS, find break-even occupancy with a scenario chart, forecast free beds, admissions and the waiting time for a new referral and turn falls and pressure ulcers into rates per 1,000 bed days with review flags. Illustrative figures, funding rules and staffing standards vary by country. The first lab is free.
Lessons
- Occupancy, Resident Days & Average ResidentsFree
- Fee Income by Funding Type: Private vs Public Rates Pro
- Staffing: Care Hours per Resident per Day Pro
- Rota Coverage & the Agency Staff Premium Pro
- Cost per Resident Day: Staff, Food, Utilities & Overhead Pro
- Break-Even Occupancy & Scenario Chart Pro
- Waiting List & Admissions Forecast Pro
- Quality Indicators: Falls per 1,000 Bed Days & Review Flags Pro