In our last few posts we have discussed the importance of understanding the impact that dental anxiety has both on patients oral health but also on practice productivity. But with out models demonstrating this impact, it is easy to ignore. This ultimately means that there will be less motivation in a practice the effectively manage patient anxiety.
The calculator we have created below, follows on from our ast post, and allows you to start to model the impact of dental anxiety on YOUR practice's productivity. Have a play and let us know what you think.
The calculator below allows you to enter some basic features of your own practice (the purple boxes) and the dental anxiety mix of your patient population (we have pre-populated the yellow boxes with an estimate of the UK average dental anxiety mix if you don't know yours). The calculator calculates the units of dental activity (UDAs) of a practice with no dentally anxious patients and compares it to the UDAs delivered with a patient population of the specified anxiety mix (the yellow boxes). The results show the loss in activity and income due to dental anxiety.
The web based calculator below is a simplified model of a more sophisticated excel based model that we have developed. The excel model allows you to compare three different scenarios: the no anxiety scenario, a poorly managed scenario and a well managed scenario. With this you can model the improvement in productivity of managing your patients dental anxiety better. It also allows you to change the variables associated with the patients behaviour.
Let us know what you think? Email firstname.lastname@example.org with your comments or feedback or to request a free copy of the spreadsheet model.
How the Model Works - Inputs and Outputs
Purple inputs (change the numbers to match your practice data as closely as possible):
No. of patients - the number of patients in your practice
No. of dentists- the number of dentists or other practitioners that see patients
No. of working days - no. of days a practitioner works including leave.
Av. UDAs per app't - an estimate of the the average number of UDAs delivered per appointment
UDA tariff - the agreed income per UDA or estimate income for private work
Yellow inputs (change the numbers to reflect the level of patients anxiety in your practice):
No anxiety patients - the % of patients with no dental anxiety
Low anxiety patients - the % of patients with low dental anxiety
Medium anxiety patients - the % of patients with medium dental anxiety
High anxiety patients - the % of patients with high dental anxiety
Number of booked appts - calculated for each anxiety group using the annual booking frequency and added together.
Appts per dentist per day - the average number of booked appointments a practitioner has every working day.
No. of appts not booked due to anxiety- the difference between the number of appointments booked by a patient population without any anxiety and your specified patient anxiety.
Appts lost due to FTAs - the number of booked appointments where a patient failed to attend using the probability of failing to attend for each anxiety group.
Overall FTA rate - the average probability that patients fail to attend an appointment across the whole patient population.
UDAs delivered - the total number of UDAs delivered in a year by all practitioners calculated using the actual number of appointments (booked appts less FTAs) for each anxiety group and the treatment efficiency for each anxiety group. For example, if average UDAs per appt are 2.5, for the high anxiety patient group with a treatment efficiency of 50%, the average UDAs per appt become 1.25.
Revenues generated - the number of UDAs delivered multiplied by the tariff payable for each UDA.
Comparison values (looking at the difference between a practice with no dental anxiety and the user entered practice anxiety mix i.e. the productivity cost of dental anxiety):
Lost UDAs - the number of UDAs delivered by practice with no dental anxiety less the number of UDAs delivered by practice with user entered anxiety mix.
Lost revenues due to dental anxiety - the lost UDAs multiplied by the average tariff for each UDA.
Productivity Loss due to dental anxiety - the loss in UDAs through dental anxiety as a proportion of total UDAs delivered with no dental anxiety.
Listed below are the assumptions that are used in the calculator above. You can change these in the excel based model. Email me at email@example.com to request a copy.