Practitioner Utilisation Model
This use case explains how to model practitioner utilisation for healthcare, clinics and allied health practices in Model Reef.
You will:
Represent clinicians and teams in the branch structure or driver layer.
Define capacity in hours, sessions or appointments per practitioner.
Model booked time, no shows and billable utilisation.
Connect utilisation to revenue, staffing cost and clinic profitability.
Model Reef is not a practice management or booking system. It operates above those tools as a planning and financial modelling engine.
When to use this pattern
Use this pattern when:
Revenue is driven primarily by clinician time.
You want to understand capacity, utilisation and throughput per practitioner or per clinic.
You need to test scenarios such as adding or removing clinicians, changing hours or shifting case mix.
You want clinical activity wired cleanly into P&L, cashflow and valuation.
It is often combined with:
Clinic Level Profitability
Medicare or Private Billing Forecast
Multi Clinic Consolidation
Architecture overview
The practitioner utilisation model has four layers:
Structure
Branches per clinic, service line or team.
Practitioner counts and mix as drivers.
Capacity drivers
Available hours or sessions per practitioner.
Working days, weeks and holidays.
Non clinical time assumptions.
Utilisation and booking drivers
Booked time percentage.
No show and cancellation rates.
Paid time, bulk billed time and gap time.
Financial outputs
Billable hours and sessions.
Revenue per practitioner and per clinic.
Staff and overhead cost per practitioner.
Margin per clinic and for the group.
Decide how to represent practitioners
Choose a level of detail that is easy to maintain:
Individual practitioners for small clinics or key personnel.
Practitioner types (GP, physio, psychologist, specialist) for larger organisations.
FTE groups by clinic and discipline.
In the Data Library, create drivers such as:
FTE Practitioners - GP - Clinic A.FTE Practitioners - Physio - Clinic B.FTE Practitioners - Psychologist - Group.
These will be used to drive capacity and cost.
Define capacity drivers
For each practitioner type and clinic, define capacity assumptions, for example:
Clinical Hours per FTE per Week.Weeks Worked per Year.Sessions per Hour(for example short consults versus long consults).Non Clinical Time Percentage(admin, meetings, training).
Calculate:
Gross Available Hours = FTE × Hours per Week × Weeks per Year ÷ Number of Periods.Clinical Hours = Gross Available Hours × (1 minus Non Clinical Time Percentage).
Store these as drivers or variables at clinic or practitioner type level, depending on how you want to report.
Model bookings, no shows and utilisation
Define utilisation drivers for each practitioner type and clinic, for example:
Booking Rate Percentage(share of clinical hours that are booked).No Show Percentage.Cancellation Fill Rate(how much of cancelled time is refilled).
Approximate billable hours as:
Booked Hours = Clinical Hours × Booking Rate.Lost Hours to No Shows = Booked Hours × No Show Percentage × (1 minus Cancellation Fill Rate).Billable Hours = Booked Hours minus Lost Hours to No Shows.
If you prefer sessions rather than hours, use:
Sessions = Billable Hours × Sessions per Hour.
These utilisation outputs will drive revenue.
Connect utilisation to revenue
For each practitioner type and billing stream, define revenue drivers such as:
Average Fee per Session - Private.Average Rebate per Session - Medicare or Insurer.Average Gap Payment per Session.
Create Revenue type variables per clinic and practitioner group, for example:
Revenue - GP - Clinic A.Revenue - Physio - Clinic B.
Formulas might look like:
Revenue - GP - Clinic A = Billable Sessions - GP - Clinic A × Average Fee per Session - GP - Clinic A.
If you split bulk billed, private and gap payments, create separate revenue variables per stream and sum them for total revenue.
Because these variables are typed as Revenue, they will flow into P&L, Balance Sheet timing and Cashflow automatically when you set payment delays.
Link practitioner utilisation to staffing cost
Create Staff type variables for practitioners, for example:
Staff - GP Salaries - Clinic A.Staff - Physio Salaries - Clinic B.Staff Oncosts - Super, Pension and Payroll Tax.Locum or Contractor Costsif you use external clinicians.
Use FTE and salary drivers, for example:
Average Salary per FTE - GP.Average Contract Rate per Hour - Locum.Oncost Percentage.
Formulas might look like:
Staff Cost - GP - Clinic A = FTE GPs × Salary per FTE × (1 plus Oncost Percentage).
This creates a clear view of practitioner revenue and cost that can be used for margin per FTE or per hour analysis.
Build utilisation and margin dashboards
Create dashboards that show:
Clinical hours versus booked and billable hours per clinic and practitioner type.
Utilisation percentages and no show rates.
Revenue and margin per FTE or per billable hour.
Comparison of performance across clinics or practitioner types.
These dashboards help identify:
Under utilised practitioners or clinics.
High performing teams.
Opportunities to improve booking practices, case mix or scheduling.
Use scenarios for staffing and demand changes
Clone the base model into scenario models to test different utilisation strategies, for example:
Adding new practitioners or FTE to a clinic.
Changing hours of operation or session lengths.
Improving booking and no show rates with reminders or process changes.
Shifting case mix between low and high fee services.
In each scenario, adjust:
FTE and capacity drivers.
Booking, no show and fill rate assumptions.
Fee schedules and payer mix if relevant.
Compare scenarios using:
Revenue and margin per practitioner and per clinic.
Cash requirements and funding needs.
Valuation changes, especially for multi clinic groups.
Check your work
FTE counts and capacity assumptions align with real rosters and working patterns.
Utilisation and no show rates look plausible against historical data.
Revenue per practitioner and per clinic matches recent experience when calibrated.
The level of detail is sustainable for your team to maintain over time.
Troubleshooting
Related guides
Last updated