Block Utilisation: Case Minutes plus Turnovers ÷ Block Minutes, by Service
This lesson is part of the course
In this lesson
You measure how well each block of one fictional week was used, pool the minutes per service with SUMIFS, count the blocks below the target and name the service with the lowest utilisation.
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
- Block Templates: Rooms, Days, Services & Block Minutes per Week Locked
- Block Utilisation: Case Minutes plus Turnovers ÷ Block Minutes, by Service Locked
- Case Duration Estimates: Median, 80th Percentile & Booking Minutes by Procedure Type Locked
- Filling a Day: Start Times, Planned Minutes, Overrun Flags & Which Case to Move Locked
- First-Case On-Time Starts & Turnover Times by Room Locked
- Overtime: Minutes past Block End, Fictional Overtime Cost & Overtime by Service Locked
- Release Rules: Check Dates with WORKDAY, Release Decisions & Reallocated Hours Locked
- Next Quarter's Allocation: Utilisation-Based Hours, Half-Day Steps & a Chart Locked