Cancellations & No-Shows: Missed Rates by Weekday, Late Notice, Fees & Refilled Slots
This lesson is part of the course
In this lesson
You count missed appointments by weekday with COUNTIFS, find the late cancellations from the notice hours, price a fictional cancellation policy and work out what the empty slots really cost.
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