Access the Revenue Opportunity dashboard by navigating to My Dashboards on the toolbar and selecting Revenue Opportunity from the dropdown.
This dashboard illustrates the potential revenue based on your Appointment Diary, taking into account the number of clinical hours your practice is open and the number of dental chairs available.
For group views, click 'Show data for all practices' to drill down into individual practice dashboards. Each tile includes a local Help guide explaining the relevance and interpretation of the data.
Setting Practice Opening Hours & Dental Chair Availability
To unlock the full value of this page, make sure your opening hours and number of dental chairs are accurately entered in the MPC Practice Setup area.
Click the Settings cog (top right) and select Practice Setup
Select Practice Potential Configuration
For each practice, click Create and enter the usual opening times for each day and the number of dental chairs available per day
Practice Selection
This feature is available to users with access to two or more practices. By default, the dashboard displays a summary view of all practices. To view data for specific practices:
Click 'Show data for all practices'
Select the individual practice(s) you want to view
Click the 'Refresh' button on the right-hand side of the Practice Selection tile
Overview of each dashboard tile
Practice Hours Utilisation Analysis
Understanding the Hours Alignment Tile
This tile compares three key sets of hours to help you identify gaps in utilisation and maximise revenue opportunity:
Practice Opening Hours — from the Practice Potential Configuration in the MPC Practice Setup.
Appointment Diary Hours — from the Patient Management Software (PMS).
Actual Hours Worked — based on booked appointment activity in the PMS.
📝 Please note: If the appointment diary is incorrectly blocked or underused in the PMS, this may result in a misleading revenue opportunity analysis.
How to Read the Graph
The graph shows trailing 12 months of data.
Hover over the dots to see detailed hour values.
Use the legend at the bottom to toggle individual data lines on or off.
Tile Controls
Enlarge: Expand the graph to near full-screen.
Data: View the data behind the chart in table format.
Legend: Use checkboxes to show/hide specific data lines on the graph.
Potential Revenue Opportunity Analysis
This tile builds on the data from the Practice Hours Utilisation Analysis, translating underused time into a revenue opportunity estimate. It does this by:
Taking the difference between available hours and actual hours worked
Multiplying those hours by the monthly average revenue per hour, specific to your practice
The average revenue per hour is sourced from the Revenue Tracker dashboard. This helps you clearly see the financial impact of unused capacity, supporting data-driven decisions to improve efficiency and income.
Lost Revenue Analysis
This tile provides a detailed breakdown of appointment diary inefficiencies over the trailing 12 months, highlighting the financial impact of:
Fail to Attend (FTA) appointments
Cancelled hours
Whitespace (unused available appointment time)
The red graph—titled 'Full Appointment Book Lost Revenue'—summarises these lost revenue sources. Superimposed over this is the blue graph, representing the total revenue opportunity if all opening hours per dental chair were fully utilised. Together, these visuals help pinpoint where revenue is being lost and where capacity can be optimised.
Open COTs With/Without Appointment
This tile displays the number of open Courses of Treatment (COTs) that have a scheduled next appointment and those without a next appointment. For UK NHS practices, it also distinguishes between NHS COTs with and without a next appointment, helping identify cases that may require follow-up to ensure continuity of care.
Recall Lag Analysis
Recall Lag measures how much later completed appointments occur compared to the patient's original recall due date. This delay can lead to lost revenue, estimated here as the opportunity cost of those postponed appointments.
This tile presents each practice's calculated recall lag and shows the potential revenue increase if the practice:
Achieved the general practice average recall lag rate
Reached the top 5% of practices' recall lag performance
