Aesthetic · From Chapters 3, 7 and 10 of The Med Spa No-Show Book
Empty-slot calculator
An empty slot is a no-show or a late cancel that nobody refilled. Count them, put a collected value on them, and see what a confirmation routine and a waitlist would win back in the first year, each only in the months it runs: the floor, not a forecast. Every line of the arithmetic is printed so you can check it against Appendix C.
- Totals only. Type monthly counts, rates and what each service line collects. Never enter a client's name, phone number or anything else that identifies her.
- Stays in your browser. Nothing you type is sent, saved or tracked. Close the tab and it's gone.
- Your rates are yours. No published study gives a no-show, late-cancel or refill rate for aesthetic practices. Every rate below marked assumption is your own count or an assumption you choose, and four weeks of your own count should replace it (Chapter 1). The published rates from other settings show a range, not your rate.
- Arithmetic, not advice. Deposits, cancellation and no-show fees are left out on purpose: they never count toward the floor, and their rules belong to your advisers and the dated rules page, which is in review.
Larkspur Aesthetics is a composite practice from the book. Its example loads first and reproduces Appendix B. Its bookings and collections are invented, and its rates are the book's labelled assumptions; none of it is a benchmark or a recommendation.
1. Bookings
Treatment visits booked in an ordinary month, from your booking report (Chapter 3). Count consults apart.
2. What a booked visit collects
Each service line's share of bookings and what one visit collects: collections ÷ visits delivered, not list prices. The shares must add up to 100%. Leave a line blank if you don't offer it.
Injectables
Collections ÷ visits delivered
Laser and skin
Collections ÷ visits delivered
Facials and peels
Collections ÷ visits delivered
3. Your rates today
Shares of bookings (Chapter 1's definitions). A late cancel is one inside your notice window; an early cancel isn't counted, because the slot went back on the book in time. Each rate is your own count, or your assumption until you have one.
Blank counts as none
4. The confirmation routine (Chapter 4)
How much a confirmation that asks for an answer cuts your no-shows, relative to today, and the month of the year it starts working. The book's example sits just under one health-system trial's relative change; that trial was not in an aesthetic practice.
1 to 12; it counts from this month on
5. The waitlist (Chapter 7)
The share of late-cancel slots you'd refill once the waitlist runs, and the month it starts.
1 to 12; it counts from this month on
A month today · synthetic · from your inputs
What the empty slots cost
Empty slots times what a booked visit collects, at today's rates (Chapter 3). The gross slot value is shown only to set aside: it counts slots that were refilled, which weren't lost.
The two routines and the floor
Each routine counts collected value from the visits it keeps, only in the months it runs (Chapter 10). Nothing else goes into the floor: no fees, no forfeited deposits, no wording or lead-time effect, no later year.
The weekly line
The empty-slot count a week the floor implies once both routines run. Read each week's count against it, judged on a four-week average, not a single week (Chapter 10).
Step by step
Every line, in the order Appendix C prints it, with your numbers in place. Lines show two decimal places; the calculator carries every digit and rounds only what it shows.
The formula
- Collected per booked visit
- Σ (line's share of bookings × collected per visit on that line); the shares add up to 1
- One month
- no-shows = booked × no-show rate; late cancels = booked × late-cancel rate; refilled = no-shows × no-show refill share + late cancels × late-cancel refill share; empty slots = no-shows × (1 − no-show refill share) + late cancels × (1 − late-cancel refill share); kept visits = booked − no-shows − late cancels + refilled
- What the empty slots cost
- lost a month = empty slots × collected per booked visit; a year = × 12; a week = a year's ÷ 52; empty slots a week = empty slots a month × 12 ÷ 52
- The confirmation routine
- no-show rate after = no-show rate × (1 − relative drop); visits kept a month = kept visits after − kept visits today
- The waitlist
- visits kept a month = kept visits with the higher late-cancel refill share − kept visits today
- First-year value
- value a month = visits kept a month × collected per booked visit; months it acts = 12 − start month + 1; first-year value = value a month × months it acts
- First-year floor
- confirmation's first-year value + waitlist's first-year value
- The weekly line
- (empty slots a month − visits kept a month by each routine) × 12 ÷ 52
What this leaves out
Everything left out would make the real figure larger, not smaller: the second year, when both routines run all twelve months; late cancels that become early cancels once clients are asked; the client who stays because someone called her; better wording (Chapter 5) and booking closer in (Chapter 6), both named in the book and left out of the floor. Fees and forfeited deposits are never in it, and idle provider time isn't counted.
It's one steady-state month, a year at a time. The split by service line assumes clients miss at the same rate whatever they booked, until your count by line says otherwise.
The calculation is the book's reference code, ported line for line and checked against its hand-worked cases and every Larkspur figure in Appendix B before each release. See the editorial policy for how numbers are labelled.