Tutorvo

Cost per Resident Day: Staff, Food, Utilities & Overhead

Lesson 5 of 813 minLab

This lesson is part of the course

In this lesson

You turn September's cost lines into cost per resident day, group them by category with SUMIFS and compare the cost with the fee income per resident day.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Occupancy, Resident Days & Average ResidentsLab13 min Locked
  2. Fee Income by Funding Type: Private vs Public RatesLab13 min Locked
  3. Staffing: Care Hours per Resident per DayLab14 min Locked
  4. Rota Coverage & the Agency Staff PremiumLab13 min Locked
  5. Cost per Resident Day: Staff, Food, Utilities & OverheadLab13 min Locked
  6. Break-Even Occupancy & Scenario ChartLab15 min Locked
  7. Waiting List & Admissions ForecastLab15 min Locked
  8. Quality Indicators: Falls per 1,000 Bed Days & Review FlagsLab13 min Locked