Physiotherapy & Therapy Practice Economics: Session Capacity, Therapist Productivity, Package Plans, Cancellations, Room & Equipment Use and Break-Even

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn the contracted hours of four fictional therapists into treatment hours, bookable sessions per week and per year, and measure how much of the paid time goes to admin.
• 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.
• 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.
• Compare a fictional price list of single sessions and packages: list price and discount per session, revenue per session that is actually attended, the pooled unused share and a new package price that meets a target.
• Look at twelve anonymous booking blocks as an administrator: the attendance rate, the share of closed blocks that were dropped and the revenue the practice did not earn on them.
• Measure how full four treatment rooms are hour by hour, find the peak hour and the hours above a threshold, and work out how fast a fictional piece of exercise equipment pays for itself.
• Compare the practice's monthly revenue, cost and margin for one therapist under three fictional contract models, work out the margin per session and the volume at which revenue share beats room rent.
• Add up the fictional practice's fixed costs, work out the contribution per session and the break-even sessions per month, build a six-month P&L and chart the monthly profit.