Likely issueRiskSubject: Rachel Dunmoreroughly £29,700 a year
Rachel Dunmore's patients are coming back every 14.4 days on average over the last four weeks, against their usual 9 to 10.5 days. A stretching cadence usually means fewer visits in each course of care. At your usual visit value that is roughly £29,700 a year in visits that are not happening, as an estimate.
- Own norm, 26 week median9.8 days
- Typical weekly range9 to 10.5 days
- Last 4 weeks average14.4 days
- Gap samples, last 4 weeks52
- Attended appointments, last 4 weeks67
last 4 complete weeks vs their own trailing 26 week weekly norm
Worth a lookOpportunitySubject: Daniel Okafor, Wednesdaysroughly £22,600 a year
Daniel Okafor's Wednesdays have run 17% booked over the last four weeks while other working days run 67%. Filling that day to match the rest of the week is worth roughly £22,600 a year, as an estimate. If Wednesdays are meant to be a lighter day for them, you can ignore this one.
- Wednesday attended hours, weekly average1 hrs
- Other working days, weekly average4 hrs
- Weeks under 50% of other days (of last 4)3
- Day capacity basis6 hrs (rostered hours per working day)
last 4 complete weeks vs their own other working days (working pattern from the last 12 weeks)
Worth a lookRiskSubject: Week starting 6 Julyroughly £11,300 a year
The week starting 6 July currently has 0 booked hours against a usual 78 for a week that far out. If that is holidays, worth lining up cover or a recall push into the gap now. That gap is roughly £11,300 of diary value, as an estimate.
- Booked hours in that week today0 hrs
- Usual booked hours 1 week out78 hrs
- Weeks ahead1
- Typical attended hours a week79.1 hrs
next 4 whole weeks vs how booked the last 12 weeks were at the same weeks-ahead distance
Worth a lookOpportunitySubject: Pricingroughly £28,600 a year
Your average invoiced price per visit has been flat at around £71 for at least 30 months. Costs have not been. If prices moved 5%, that is roughly £28,600 a year, as an estimate.
- Average invoiced price per visit, last 3 months£71
- Months since the last effective price risenone in the last 30 months
- Invoiced attended appointments, last 12 months8096
- Invoiced revenue, last 12 months£572,776
- Average invoiced price per visit at the start of the window£71
monthly average invoiced amount per invoiced attended appointment over the last 30 complete months; a price rise means the 3 month rolling average stepped up by 4% or more and stayed up
Likely issueOpportunitySubject: Forward book
You have 3.1 weeks of diary booked ahead, against your usual 1.6 weeks. Your forward book is unusually strong, which points to a healthy month ahead.
- Booked ahead now3.1 weeks
- Own norm, 26 week median1.6 weeks
- Forward booked hours244.3 hrs
- Median weekly attended hours78.5 hrs
forward book as of now vs the clinic's own trailing 26 week weekly norm