Most restaurants either fly blind with gut-feeling purchases or rely solely on yesterday's sales numbers. But your reservation book holds tomorrow's answers, while your POS system reveals yesterday's patterns. Merge these data streams and you'll transform wild guessing into precise purchasing.
Why merge reservations with sales history?
Your POS shows what moved last Tuesday. Your reservation system shows next Tuesday's headcount. Separately, they're just numbers. Together? They become your purchasing crystal ball.
💡 Example:
Last Saturday: 80 guests, 35 steaks sold
This Saturday: 95 reservations
Steak estimate: (35 / 80) × 95 = 42 portions
Purchase: 45 steaks (with 7% buffer)
Collect your essential data streams
You'll need three core data sources working in harmony:
- POS transaction data: Dish quantities sold daily
- Reservation counts: Confirmed covers by service
- Seasonal dish performance: Monthly popularity shifts
Miss any of these three and your purchasing predictions crumble. But here's one of the most common blind spots in kitchen management: restaurants track these separately instead of connecting the dots.
Build dish penetration rates
Here's where the math gets interesting. Calculate what percentage of diners choose each dish.
💡 Example calculation:
Last month November:
- Total guests: 1,200
- Salmon sold: 180 portions
- Steak sold: 240 portions
- Risotto sold: 150 portions
Penetration rates: Salmon 15%, Steak 20%, Risotto 12.5%
These percentages become your purchasing foundation. But don't treat them as gospel year-round.
Factor in seasonal dish swings
Butternut squash soup crushes in October, bombs in July. Your penetration rates need seasonal adjustments.
⚠️ Watch out:
Always compare with the same month last year. November 2023 vs November 2024, not November vs October.
Track how dish popularity shifts by season:
- Winter months: Braised dishes +30%, cold salads -40%
- Summer service: Seafood +20%, heavy proteins -60%
- Holiday periods: Premium items +50%
Apply reservation data to projections
Now you can forecast with actual numbers instead of hunches.
💡 Example for coming week:
Reservations: 320 guests
Salmon last year December: 18% (instead of 15% in November)
Expected salmon: 320 × 0.18 = 58 portions
Purchase: 65 salmon fillets (with 12% buffer)
Account for the unpredictable
Perfect data still can't predict everything. Smart buffers protect your service:
- Walk-in traffic: 10-15% extra covers beyond reservations
- No-show rate: 5-10% of booked guests won't appear
- Trending dishes: 15-20% extra for social media favorites
Running out loses revenue. Over-ordering burns cash through spoilage.
Streamline with integrated systems
Spreadsheets work initially, but managing multiple dishes across seasons gets chaotic fast. Tools like KitchenNmbrs can merge your sales history with recipe requirements to automatically calculate ingredient needs.
The bonus: you'll instantly see how ingredient price fluctuations impact your food costs.
How do you combine reservations and data? (step by step)
Gather sales data from last month
Pull from your cash register how much of each dish you sold and how many guests you had. Calculate the percentage per dish: (sold portions / total guests) × 100.
Adjust for seasonal patterns
Compare with the same period last year. Are certain dishes more or less popular now? Adjust your percentages for the current season.
Calculate what you need
Multiply your number of reservations by the adjusted percentages per dish. Add 10-15% buffer for walk-ins and unexpected busy periods.
✨ Pro tip
Compare your projected vs actual sales every Tuesday morning for the previous week's top 8 dishes. Track your accuracy percentage - aim for 85% precision within 6 weeks of implementing this system.
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
What if I don't have a reservation system?
Use your average covers per day from POS data. Identify patterns: Mondays slow, Fridays slammed. Even basic traffic patterns beat purchasing on impulse.
How far ahead can I plan with this method?
Fresh proteins maximum 3-4 days. Pantry staples up to one week ahead. Beyond that, dish popularity shifts make forecasting unreliable.
What if a dish suddenly becomes popular?
Monitor sales weekly and update penetration rates. A viral dish can jump from 10% to 25% of orders within two weeks.
Should I account for the weather?
Absolutely, especially for seasonal items. Hot soup flops on 80-degree days, even in October. Check forecasts before finalizing orders.
How do I prevent over-purchasing?
Start with conservative 10% buffers instead of 20%. Better to sell out occasionally than waste weekly. Increase buffers as you refine your accuracy.
What's the minimum sales history I need?
At least 8 weeks of comparable period data. Less than that and you're still guessing. Seasonal dishes need a full year of history for reliable patterns.
How do I handle special events or holidays?
Create separate penetration rates for holidays based on previous years. New Year's Eve dining patterns differ drastically from regular Saturday service.
⚠️ EU Regulation 1169/2011 — Allergen Information — https://eur-lex.europa.eu/eli/reg/2011/1169/oj
The allergen information on this page is based on EU Regulation 1169/2011. Recipes and ingredients may vary by supplier. Always verify current allergen information with your supplier and communicate this correctly to your guests. KitchenNmbrs is not liable for allergic reactions.
In the UK, the FSA enforces allergen regulations under the Food Information Regulations 2014.
📚 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.
Purchase smarter with real-time insights
Seasonal prices fluctuate — so do your recipe costs. KitchenNmbrs automatically recalculates your margins when purchase prices change. Never get surprised again. Start free.
Start free trial →