Restaurant cancellations cost the industry $240 billion annually, with last-minute changes being the biggest culprit. A last-minute cancellation of 8 people means not only less revenue, but also wasted purchases and missed opportunities. You need to know exactly how much each change costs you to make smarter decisions about your reservation policy.
Why reservation changes have financial impact
Every reservation triggers preparation. You buy ingredients, schedule staff, and block tables. But when guests change plans last-minute, you're stuck covering the costs while the revenue vanishes.
⚠️ Watch out:
Many restaurants focus only on lost revenue, but forget the fixed costs that have already been incurred. Those costs keep running, even with cancellations.
The different types of costs in changes
Multiple cost items hit you with every reservation change:
- Lost revenue: The income you don't receive
- Wasted purchases: Ingredients you've already ordered
- Staff: Employees you've scheduled
- Opportunity cost: Other guests you've turned away
Calculate the direct costs
Start with the most visible impact: what do you lose directly?
💡 Example:
Reservation for 6 people, cancelled 2 hours in advance:
- Average bill: €45 per person
- Total lost revenue: 6 × €45 = €270
- Excluding VAT: €270 / 1.09 = €247.70
Direct revenue loss: €247.70
Calculate the hidden costs
The real damage often lies in costs that keep running:
Wasted ingredients: If you've already purchased for specific dishes, you often can't sell them anymore. Calculate using your average food cost percentage.
💡 Example:
Same reservation, food cost 30%:
- Revenue excl. VAT: €247.70
- Ingredient costs: €247.70 × 0.30 = €74.31
- These costs have already been incurred and are lost
Wasted ingredients: €74.31
Staff costs: You've scheduled extra staff for the rush. You'll pay those costs anyway. And this is the kind of thing you only learn after closing your first month at a loss—those labor hours add up fast, even when tables sit empty.
Measure the opportunity cost
This is the trickiest, but often the largest cost item. How many other guests did you turn away because this table was occupied?
Look at your reservation data from the past month:
- How many requests did you decline per evening?
- Which time slots get the most requests?
- What's your average wait time for new reservations?
💡 Example:
On Saturday evening you average turning away 3 groups:
- Average group size: 4 people
- Average bill: €45 per person
- Opportunity cost: 4 × €45 = €180 per missed group
If you could refill that table: €180 extra revenue
Platform-specific costs
Some reservation platforms charge fees for changes:
- OpenTable: Possibly covers you've already 'paid' through their system
- Resy: Depends on your subscription
- Own system: Usually no extra costs
Check your platform costs and factor these into your total impact.
Create a reservation policy based on real costs
Now that you know what changes cost, you can create a fair policy:
💡 Example total cost calculation:
Cancellation of 6 people, 2 hours in advance:
- Lost revenue: €247.70
- Wasted ingredients: €74.31
- Missed opportunity: €180
- Total damage: €502.01
Actual cost per person: €83.67
With these figures you can determine:
- Cancellation fees that are fair
- From what point in time you charge costs
- What flexibility you can offer
Track and learn
Track every month:
- Number of cancellations per time slot
- Average group size of cancellations
- How much you could refill (opportunity recovery)
- Total financial impact
This data helps you spot patterns and refine your policy.
How do you calculate the financial impact? (step by step)
Calculate the direct revenue damage
Multiply number of people × average bill per person. Convert to excl. VAT (divide by 1.09 for food). This is your direct revenue loss.
Calculate wasted ingredient costs
Multiply your revenue excl. VAT × your average food cost percentage. You've already purchased these ingredients and often can't sell them to other guests.
Estimate the opportunity cost
Look at how many requests you average declining per evening. Multiply average group size × average bill. This is what you could have earned if you could refill that table.
✨ Pro tip
Track your actual cancellation-to-refill ratio for 30 days during peak season. Most restaurants can only refill 15% of last-minute cancellations, making your true cost much higher than the menu price.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
Should I always charge cancellation fees?
It depends on timing and your occupancy rate. If you can refill the table, your costs are lower. Last-minute cancellations on busy evenings cost the most.
How do I prevent guests from cancelling en masse?
Ask for prepayment or deposit for larger groups. Send reminders 24 hours in advance. Make your cancellation policy clear when booking.
What if guests arrive late instead of cancelling?
Late arrivals also cost you money: other guests wait, tables turn slower, staff works overtime. Calculate how much a delayed table turn costs you per quarter hour.
How do I calculate opportunity cost if I don't know how many I turn away?
Start tracking: how many people do you turn away per week? How many requests come in via phone/email that you can't fulfill? After a month you'll have a good picture.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
All your financial KPIs in one dashboard
Food cost percentage, gross margin, revenue per cover — KitchenNmbrs calculates it all automatically based on your recipes and purchases. Start your free trial.
Start free trial →