Your food cost data is like a crystal ball for your restaurant's future. Most owners draft yearly plans based on hunches and wishful thinking. But your own numbers tell a far more accurate story about what's actually possible.
Why food cost data is crucial for your business plan
Your food cost system doesn't just track dish expenses. It uncovers trends, seasonal shifts, and identifies which menu items drive profits versus those that drain them. This information becomes the backbone of realistic revenue projections and profit forecasts.
⚠️ Heads up:
Most owners plan with a blanket 30% food cost, but ignore that bestsellers often carry different margins. Analyze your top performers individually.
What data you pull from your system
Extract these essential metrics from your food cost records:
- Individual dish costs - skip averages, get specific numbers per item
- Volume per menu item - which dishes move the most?
- Seasonal price swings - how do ingredient costs shift month to month?
- Supplier price patterns - which products consistently climb in price?
💡 Example:
Bistro reviews 12 months of their top 5 dishes:
- Ribeye: 35% food cost, 180 orders/month
- Halibut: 28% food cost, 140 orders/month
- Carbonara: 22% food cost, 320 orders/month
Reality check: The pasta generates the most profit despite lower prices
From data to realistic revenue forecast
Transform your sales history into next year's revenue predictions. Don't just examine total dollars - break down covers by individual dishes.
- Tally covers from the previous 12 months
- Split by season (winter typically runs 20% below summer)
- Identify growth patterns: expanding 5% annually? Contracting?
- Err on the conservative side: better to exceed expectations than fall short
Forecasting cost increases
Your historical data reveals which ingredients spiked the most. Apply these patterns to estimate future cost jumps - one of the most common blind spots in kitchen management.
💡 Example calculation:
Beef jumped 12% in 2024, annual spend €45,000:
- Additional 2025 costs: €45,000 × 0.12 = €5,400
- Monthly impact: €450 extra on beef
- At 900 covers/month: €0.50 increase per guest
Decision: adjust menu prices or switch proteins
Planning profit margin realistically
Many owners default to "30% food cost across the board," but that's rarely accurate. Calculate your true weighted average food cost instead.
Weighted average formula:
(Food cost dish A × Units sold A + Food cost dish B × Units sold B) / Total units sold
💡 Practical example:
Three entrees, 900 covers monthly:
- Filet (35% food cost): 180× sold
- Salmon (28% food cost): 270× sold
- Risotto (22% food cost): 450× sold
Weighted average: (35×180 + 28×270 + 22×450) / 900 = 26.2%
Not 28.3% (simple average)!
Running through scenarios
Use your data to model different outcomes for your business plan:
- Base scenario: Same menu mix, 5% cover increase
- Optimistic: 15% growth plus shift toward high-margin dishes
- Pessimistic: 10% fewer covers plus 8% ingredient inflation
Digital tools for data analysis
Manual food cost analysis consumes hours. Many operators rely on tools like KitchenNmbrs that automatically generate reports showing cost trends, top-selling items, and per-dish profitability.
⚠️ Heads up:
Don't base plans solely on peak months. Review your weakest month - can you cover fixed costs during that period?
How do you create a data-driven business plan? (step by step)
Gather 12 months of food cost data
Export all dishes with food cost, sales volumes, and purchase prices from the past year. Sort by popularity and profitability. Distinguish between seasons.
Calculate weighted average food cost
Multiply the food cost of each dish by the number of times sold. Add everything up and divide by total number of covers. This is your actual food cost, not the arithmetic average.
Analyze cost increases per ingredient
Check which ingredients increased most in price last year. Calculate the impact on your total purchases and plan price adjustments or recipe changes for next year.
Create three scenarios
Calculate a base, optimistic, and pessimistic scenario. Use your actual data as a starting point and vary with growth percentages and cost increases that are realistic for your situation.
✨ Pro tip
Pull your top 3 bestsellers from the last 6 months and calculate their exact food costs. If any exceed 32%, your most popular items are quietly eating your profits.
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 historical data do I need for a reliable business plan?
At least 12 months to capture seasonal patterns. If you've had major changes like menu overhauls or renovations, 6 months can work, but plan more conservatively. The key is having enough data to spot trends rather than random fluctuations.
How do I forecast cost increases if suppliers won't give price quotes?
Analyze your past 2 years of ingredient trends per category. Plan for 5-8% increases on average, sometimes 10-15% for proteins and seafood. It's better to overestimate and have extra margin than get blindsided by price jumps.
What if my data is incomplete because I just started tracking food costs?
Work with what you have and fill gaps with estimates based on current purchase prices. Document your assumptions clearly so you can refine them as you gather more data. Even partial tracking beats planning in the dark.
📚 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.
Automate your daily kitchen controls
Manual controls take time and miss errors. KitchenNmbrs automates temperature logging, inventory management, and HACCP checks. Try it free for 14 days.
Start free trial →