Allow for preparation, missed appointments and gaps between bookings. Start with attendance records, teaching schedules and room costs. Each example below uses hypothetical values you can replace.
Appointment Slots with Turnaround
Include cleaning and preparation between bookings.
Slots = floor(staffed minutes / (service minutes + turnaround))
Show example inputs and result
| Available staffed minutes | 480 |
|---|---|
| Service duration | 45 minutes |
| Turnaround per appointment | 15 minutes |
Result: 8 appointments.
Subtract breaks before entering available minutes. This model uses one identical service duration.
Open appointment slots with turnaroundAttendance-Adjusted Booking Revenue
Forecast service revenue from actual attendance assumptions.
Expected revenue = bookings × attendance rate × average collected price
Show example inputs and result
| Booked appointments | 100 |
|---|---|
| Attendance rate | 90 % |
| Average collected service price | 80 |
Result: 7,200 .
Excludes cancellation fees and variable costs. Attendance is an entered scenario, not a promise.
Open attendance-adjusted booking revenueUnused Booking Capacity
Estimate contribution associated with unfilled booking capacity.
Unused contribution capacity = slots × unfilled share × contribution
Show example inputs and result
| Bookable monthly slots | 200 |
|---|---|
| Unfilled share | 15 % |
| Contribution per filled slot | 60 |
Result: 1,800 per month.
Only if demand, staffing, and timing align. Separate avoidable booking gaps from genuine lack of demand.
Open unused booking capacityNo-Show Contribution Loss
Model missed contribution from unfilled no-show appointments.
Loss = bookings × no-show rate × (1 − refill share) × contribution
Show example inputs and result
| Monthly bookings | 150 |
|---|---|
| No-show rate | 8 % |
| Contribution per attended booking | 80 |
| Share of missed slots refilled | 20 % |
Result: 768 per month.
Use contribution after costs that are avoided when the booking is missed, and account for successful slot refilling.
Open no-show contribution lossService Recovery Budget
Budget known refunds and rework effort together.
Recovery budget = cases × (refund + rework hours × hourly cost)
Show example inputs and result
| Refund or credit per case | 80 |
|---|---|
| Rework hours per case | 2 |
| Loaded hourly cost | 35 |
| Cases in period | 10 |
Result: 1,500 .
Include only entered recovery costs; any effect on future retention is uncertain.
Open service recovery budgetUse the results in your plan
For a driving school business, review instructor hours, fuel, and vehicle wear across the complete workflow. Use one consistent period and delivery unit: a lesson. Compare the assumptions with recorded outcomes after delivery, then update the estimate.
Explore all relevant driving school calculators