Location:
My Dashboards
Revenue Opportunity Dashboard
This report estimates the potential revenue opportunity based on:
Unbooked appointment diary hours
Fail to Attend (FTA) hours
Cancelled appointment hours
These are calculated using the Average Revenue per Hour Worked for each respective month.
Revenue per Hour Calculation
The Average Revenue per Hour Worked is calculated monthly as:
(Private Revenue + Public Health Revenue, e.g., NHS — using actual UDA rate if available, otherwise £25 per UDA — + Private Capitation + Public Health Capitation, if applicable) ÷ Total Hours Worked
Additional Insight: Practice Hours Lost Revenue
By enabling the blue ‘Practice Hours Lost Revenue’ toggle, the graph displays additional opportunity that could be realised if:
The appointment diary fully aligns with the practice’s opening hours
All chairs are utilised
Data Sources & Assumptions
Opening hours and chair count are sourced from the Practice Potential Configuration in the MPC Practice Setup
Appointment diary hours and actual hours worked are taken from the Patient Management Software (PMS) and assumed accurate
Tile Features
Enlarge: Toggle this button to expand the graph to near full-screen view
Data: Toggle to display the data points in a table. The table also adds context by showing the percentage opportunity associated with each value
Legend: Click legend boxes to show or hide corresponding data lines on the graph
Definitions
Full Appointment Book Lost Revenue
Total revenue opportunity lost over the trailing 12 months from:
Failed to Attend (FTA) hours
Cancelled appointment hours
Unbooked potential (whitespace)
Practice Hours Lost Revenue
Represents the lost revenue assuming the practice operated at full capacity, calculated as:
(Opening Hours × Number of Chairs × Average Earnings per Hour Worked)
Failed to Attend (FTA) Hours
Revenue lost from appointments where patients did not attend and the time could not be reallocated.
Cancelled Appointment Hours
Revenue lost from cancelled appointments that could not be rebooked—typically due to short notice. These are appointment slots that remained unused after cancellation.
Unbooked Potential (Whitespace Excluding Cancelled Hours)
Represents available appointment time that was never booked, excluding any time attributed to cancellations.
Calculated as:
(Whitespace − Cancelled Appointment Hours) × Average Earnings per Hour Worked
📝 Please note: Inactive Provider data is used in these calculations. Please make sure Appointment Calendars are blocked appropriately