Therapist Productivity: Booked, Attended & Utilisation with SUMIFS
This lesson is part of the course
In this lesson
You summarise a three-week sessions log per therapist with SUMIFS, compute utilisation on attended sessions, pool it for the practice and name the therapist with the most free capacity.
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
- Session Capacity: Treatment Hours, Admin Time & Bookable Sessions Locked
- Therapist Productivity: Booked, Attended & Utilisation with SUMIFS Locked
- Cancellations & No-Shows: Missed Rates by Weekday, Late Notice, Fees & Refilled Slots Locked
- Pricing: Single Sessions vs Packages, Effective Price & Unused Sessions Locked
- Plan Completion (Administrative): Booked vs Attended Sessions & the Revenue Effect of Drop-Off Locked
- Rooms & Equipment: Room Utilisation by Hour, Peak Hours and an Equipment Payback Locked
- Therapist Models: Employed vs Room Rent vs Revenue Share and the Margin per Session Locked
- Break-Even & Dashboard: Fixed Costs, Contribution per Session, Break-Even Sessions & a Profit Chart Locked