Smart purchasing based on reservation data cuts food waste by 15-30% almost immediately. Too many restaurants still buy ingredients based on yesterday's sales or gut instinct. Connect your expected guest count to actual purchasing needs and watch both waste and shortages disappear.
Why use reservation numbers for purchasing?
Your reservation system holds the key to smarter buying decisions. It shows you exactly how many guests are coming, what time they'll arrive, and patterns in what they typically order. This data transforms into real money saved every single week.
💡 Example:
Restaurant with 60 covers on Tuesday vs. 120 on Friday:
- Tuesday: 60 guests × 30% order fish = 18 fish dishes
- Friday: 120 guests × 30% order fish = 36 fish dishes
- Without planning: buy 40 portions of fish every day
- With planning: Tuesday 20 portions, Friday 40 portions
Savings: 2 portions of fish per Tuesday = €24 per week
The basic calculation: from reservations to purchasing
You need three core numbers: expected guest count, dish popularity percentage, and your safety buffer. The math itself is straightforward - getting accurate percentages takes some detective work.
Basic formula:
Required quantity = (Expected guests × Dish popularity %) + Safety stock %
💡 Example calculation:
Saturday: 100 reservations expected
- Steak: 100 × 25% = 25 portions + 10% buffer = 28 portions
- Salmon: 100 × 20% = 20 portions + 10% buffer = 22 portions
- Pasta: 100 × 35% = 35 portions + 5% buffer = 37 portions
Without planning you might buy 30-30-40 = 5 portions too many
Using historical data for accuracy
Monday diners behave completely differently than Saturday night crowds. Your ordering patterns shift with seasons too - nobody wants heavy stews in July.
- Pull at least 12 weeks of sales data for each weekday
- Calculate dish popularity percentages by day type
- Track seasonal shifts (summer salads vs. winter comfort food)
- Flag special events and holiday patterns
⚠️ Note:
Walk-ins can throw off your calculations. Maintain 10-15% extra buffer for unexpected guests, especially Friday through Sunday.
Calculating the financial impact
Track your waste reduction by comparing old buying habits against your new reservation-driven approach. From tracking this across dozens of restaurants, the biggest savings always come from expensive proteins going bad.
💡 Savings calculation:
Restaurant with €8,000 weekly purchasing:
- Old waste: 12% = €960 per week
- New waste with planning: 7% = €560 per week
- Savings: €400 per week = €20,800 per year
ROI of better planning: €20,800 per year
Practical tools and systems
Excel works fine for basic calculations, but dedicated software saves hours each week. Most modern POS systems export the sales data you need.
- Export weekly sales reports from your POS system
- Use reservation data to predict upcoming guest volumes
- Build a simple spreadsheet linking both data sources
- Food cost calculators like KitchenNmbrs track dish popularity trends
Common mistakes in purchasing planning
The same planning errors show up in restaurant after restaurant. Avoid these traps and you're already ahead of most competitors.
- Yesterday bias: Tuesday was slammed, so Wednesday must be busy too
- Season blindness: Using holiday rush data for regular March planning
- Zero buffer mentality: Running out of bestsellers costs more than small waste
- Storage reality check: Fresh fish doesn't keep just because you bought extra
⚠️ Note:
Test your system on 2-3 signature dishes first before changing your entire purchasing routine. Learn the process without risking major inventory mistakes.
How do you calculate the savings? (step by step)
Gather your current waste data
Measure for 4 weeks how much you throw away per product category. Note this as a percentage of your purchases. On average, restaurants waste 8-15% of their fresh products.
Analyze your sales patterns by weekday
Export 3 months of sales data from your POS system. Calculate per weekday what percentage of your guests order which dish. Monday has different patterns than Saturday.
Create your purchasing formula and test for 2 weeks
Use the formula: (Expected guests × Popularity %) + 10% buffer. Test this on your 3 most popular dishes and measure whether your waste decreases without creating shortages.
✨ Pro tip
Start with your three most expensive proteins when testing reservation-based purchasing. Getting beef, fish, and premium cuts right for just two weeks will show you €200+ in waste reduction and prove the system works.
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
How much buffer should I keep for unexpected guests?
For perishable items, maintain 10-15% extra inventory. Non-perishables need only 5-10% buffer. Weekend nights typically see more walk-ins, so increase your Friday-Saturday buffers accordingly.
What if my POS system doesn't provide detailed sales data?
Start by hand-counting your 5 bestselling dishes for two weeks straight. This captures 70-80% of your ordering patterns and provides enough data to begin reservation-based purchasing.
How do I handle seasonal menu changes in my calculations?
Create separate purchasing formulas for warm and cold seasons. Summer guests gravitate toward lighter fare and cold dishes, while winter brings demand for hearty soups and braised items.
Can I use this system for beverages too?
Yes, but focus on perishables first since beverages have longer shelf life and lower spoilage rates. Your biggest savings come from fresh proteins, produce, and dairy products.
What if I get many last-minute reservations?
Calculate your average same-day booking increase over the past month. If you typically see 20% more reservations added day-of, build that percentage into your base calculations.
How do I adjust for special events or holidays?
Track your sales patterns during past special events and holidays separately. New Year's Eve ordering looks nothing like regular Saturday night, so create event-specific purchasing multipliers.
📚 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.
Save up to 15% on your food cost
Most kitchens save 8-15% on food cost as soon as they start measuring. KitchenNmbrs makes measuring simple. Start your free trial today and see the difference.
Start free trial →