Likely issueOpportunitySubject: Eleanor Brooks, Wednesdaysroughly £25,800 a year
Eleanor Brooks's Wednesdays have run 14% booked over the last four weeks while other working days run 51%. Filling that day to match the rest of the week is worth roughly £25,800 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 average0.8 hrs
- Other working days, weekly average2.8 hrs
- Weeks under 50% of other days (of last 4)4
- Day capacity basis5.5 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 lookOpportunitySubject: Tom Askew, Tuesdaysroughly £23,300 a year
Tom Askew's Tuesdays have run 10% booked over the last four weeks while other working days run 40%. Filling that day to match the rest of the week is worth roughly £23,300 a year, as an estimate. If Tuesdays are meant to be a lighter day for them, you can ignore this one.
- Tuesday attended hours, weekly average0.6 hrs
- Other working days, weekly average2.5 hrs
- Weeks under 50% of other days (of last 4)3
- Day capacity basis6.3 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 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 months8070
- Invoiced revenue, last 12 months£571,473
- 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 2.9 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 now2.9 weeks
- Own norm, 26 week median1.6 weeks
- Forward booked hours233.8 hrs
- Median weekly attended hours79.7 hrs
forward book as of now vs the clinic's own trailing 26 week weekly norm
Worth a lookRiskSubject: Net patient flow
You need roughly 96 new patients a month to stand still; you are averaging 80. More patients have been quietly lapsing than arriving, which shrinks your active base even when the diary feels busy.
- New patients a month, average over the last 6 complete months80.3
- Patients lapsing a month, average over months 4 to 9 back95.5
- Net change a month-15.2
- Patients evaluated946
new patients over the last 6 complete months vs patients lapsing per month over months 4 to 9 back; a lapse needs 90 days with no attended visit to be provable