Appointment No-Show Risk Estimator
Predict appointment no-show probability based on lead time, reminders, and history. Enter values for instant results with step-by-step formulas.
Formula
No-Show Risk = Base Rate × Lead Time Modifier × (1 - Reminder Reduction) × Historical Modifier × Time Modifier × Day Modifier; Expected Loss = Appointment Value × Risk
The no-show formula starts with industry-specific base rates (medical 20%, dental 15%, etc.) and applies multiplicative modifiers for each risk factor. Lead time modifier increases risk for longer advance bookings (1.3x for 14+ days). Reminder reduction subtracts from 1 (each reminder reduces risk by ~15%). Historical modifier scales by patient/client past behavior (1.5x for chronic no-showers, 0.7x for reliable attendees). Time and day modifiers capture scheduling patterns (evenings and Mondays higher risk). The product gives probability of no-show. Expected loss multiplies by appointment value to quantify financial risk. This formula works because it mirrors how actuarial risk calculation combines independent risk factors multiplicatively.
Worked Examples
Example 1: Medical Practice Assessment
Problem:Primary care practice analyzing appointment risk. New patient booking 10 days out, no prior history. Morning Monday slot. Only 1 reminder planned. Appointment value $200.
Solution:Base Risk Factors: Appointment type: Medical = 20% base rate Lead time: 10 days (>7 days = 1.1x modifier) Reminders: 1 (15% reduction) Prior history: New patient (neutral) Time: Morning (0.9x) Day: Monday (1.1x) Calculation: Base: 0.20 After lead time: 0.20 × 1.1 = 0.22 After reminders: 0.22 × (1 - 0.15) = 0.187 After time: 0.187 × 0.9 = 0.168 After day: 0.168 × 1.1 = 0.185 Final Risk: 18.5% Risk Level: Moderate Expected Loss: $200 × 18.5% = $37 expected value at risk Recommendations: 1. Add second reminder (could reduce to ~12%) 2. Monday morning is a risk factor 3. New patient = no history signal 4. Consider confirmation call for new patients With 2 Reminders: Base after lead: 0.22 After 2 reminders: 0.22 × (1 - 0.30) = 0.154 After time/day: 0.154 × 0.9 × 1.1 = 0.152 Improved Risk:
Result:18.5% risk (Moderate) | $37 expected loss | Add 2nd reminder to reduce to ~15%
Example 2: Dental Practice High-Risk Patient
Problem:Patient has 3 no-shows in 8 previous appointments. Booking 14 days out for Friday afternoon cleaning. $120 appointment. Currently send 2 reminders.
Solution:Historical Analysis: No-shows: 3 Total appointments: 8 Historical rate: 37.5% (HIGH) Risk Calculation: Base (dental): 15% Lead time (14 days): × 1.3 = 19.5% Reminders (2): × 0.70 = 13.7% History (>30%): × 1.5 = 20.5% Time (afternoon): × 1.0 = 20.5% Day (Friday): × 1.15 = 23.6% Final Risk: 23.6% Risk Level: Moderate-High Expected Loss: $120 × 23.6% = $28.32 This Patient's Risk Factors: - Historical 37.5% no-show rate is major red flag - Friday afternoon compounds the risk - Long lead time adds uncertainty Recommendations: 1. Require confirmation 48hrs before (reschedule if no response) 2. Consider deposit requirement ($25-50) 3. Call personally in addition to automated reminders 4. Offer earlier in week slot (lower inherent risk) 5. Add to overbooking eligible list With Confirmation R
Result:23.6% risk (Moderate-High) | History major factor | Require confirmation or deposit
Example 3: Restaurant Reservation Analysis
Problem:Fine dining restaurant. Saturday evening 8-top reservation made 5 days ahead. First-time guest via OpenTable. $150/person expected. No deposits currently.
Solution:Reservation Details: Party size: 8 people Lead time: 5 days Day/Time: Saturday evening Guest type: First-time, online booking Per-person value: $150 Total value: $1,200 Risk Assessment: Base (restaurant): 12% Lead time (5 days): neutral = 12% No reminders assumed: × 1.4 = 16.8% No history: neutral = 16.8% Evening: × 1.15 = 19.3% Saturday: × 1.05 = 20.3% Large Party Adjustment: Larger parties have higher no-show rates (coordination issues) 8-top: × 1.3 additional modifier Final: 20.3% × 1.3 = 26.4% Expected Loss: $1,200 × 26.4% = $317 expected value at risk Financial Impact: - Empty 8-top on Saturday = massive opportunity cost - Could have seated 2-3 smaller parties - Staff scheduled for large party Mitigation Strategies: 1. Credit card hold (industry standard for large parties) 2. Con
Result:26.4% risk | $317 expected loss | 8-top Saturday = require credit card hold
Frequently Asked Questions
What is a typical no-show rate?
No-show rates vary by industry: medical 15-30%, dental 10-20%, restaurants 10-20%, salons 15-25%, professional services 5-15%. These rates have significant financial impact—a 20% no-show rate means 1 in 5 appointments generate no revenue.
What factors most influence no-show risk?
Key factors include: lead time (longer = higher risk), reminder frequency (more reminders = lower risk), patient/client history, appointment time (evenings higher risk), day of week (Mondays and Fridays higher), weather, and whether prepayment is required.
How do reminders reduce no-shows?
Studies show: one reminder reduces no-shows by 20-30%, two reminders by 30-40%, three reminders by up to 50%. Optimal timing: 48-72 hours before, 24 hours before, and day-of (2-4 hours before). Mix channels: SMS, email, phone.
Should I overbook to compensate for no-shows?
Overbooking is common in healthcare and airlines. The strategy: if no-show rate is 20%, book 1.2x capacity. Risks include: all patients showing up (long waits, angry customers), reputation damage, and regulatory issues in some industries.
Do deposits reduce no-shows?
Yes, significantly. Requiring deposits or prepayment can reduce no-shows by 40-60%. Even small deposits (10-20%) have impact. However, deposits may reduce total bookings. Balance conversion rate against no-show reduction.
What's the cost of a no-show?
Direct costs: lost revenue for that slot, staff time waiting. Indirect costs: opportunity cost (someone else could have booked), scheduling inefficiency, potential patient/client dissatisfaction for others if delays result.
How does lead time affect no-show risk?
Longer lead times correlate with higher no-shows: 1-2 days: ~10%, 1 week: ~15%, 2 weeks: ~20%, 1 month+: 25-30%. People forget, circumstances change, urgency fades. Same-day appointments have lowest no-show rates.
Should I charge no-show fees?
No-show fees (typically $25-100) deter some no-shows but have drawbacks: difficult to collect, may alienate customers, require clear policy communication. More effective: easy cancellation (encouraging cancellation over no-show) and confirmation requirements.
How do I identify high-risk patients/clients?
Track history: anyone with 2+ previous no-shows is high risk. Other signals: last-minute bookings, unclear reason for appointment, no confirmation response, distant address (transportation barriers). Flag these for extra reminders or confirmation calls.
What time slots have highest no-show rates?
Patterns vary but common trends: Monday mornings (weekend plans extend), Friday afternoons (early weekend start), first appointments after lunch (people don't return), and evening slots (fatigue, competing priorities). Mid-morning Tuesday-Thursday typically lowest.