How many menu decisions do you make based on gut feeling versus hard data? Every recipe in your kitchen holds financial clues about what stays, what goes, and what needs tweaking. Transform those recipes into business cases that guide smart menu choices.
From recipe to business case
Each recipe tells a financial story beyond ingredient costs. It reveals performance patterns against other dishes, showing which ones drive profit and which drain resources. Smart recipe analysis separates menu winners from losers.
💡 Example:
You have 3 pastas on your menu. By comparing recipe data:
- Carbonara: 28% food cost, sells 45x per week
- Pesto: 35% food cost, sells 12x per week
- Bolognese: 31% food cost, sells 38x per week
Conclusion: Pesto costs too much and sells poorly - adjust or replace it.
The 4 quadrants of menu analysis
Every dish lands in one category based on popularity and profitability:
- Stars: Popular + profitable (keep and promote)
- Plowhorses: Popular + not profitable (reduce costs or increase price)
- Puzzles: Not popular + profitable (boost marketing or repurpose ingredients)
- Dogs: Not popular + not profitable (eliminate)
Gathering concrete numbers
Each menu decision requires specific recipe metrics:
- Food cost percentage: Ingredient costs / selling price excl. VAT × 100
- Sales frequency: Weekly or monthly portion counts
- Gross profit per portion: Selling price excl. VAT - ingredient costs
- Total monthly revenue per dish: Portions sold × selling price
💡 Calculation example:
Steak priced at €32.00 (incl. 9% VAT):
- Selling price excl. VAT: €29.36
- Ingredient costs: €11.20
- Food cost: 38.1% (too high!)
- Sells 25x per week
Action: Lower cost price to €9.00 or raise price to €35.00
Calculate impact of changes
Before adjusting or removing dishes, measure financial consequences. A pattern we see repeatedly in restaurant financials shows that removing popular items often destroys more revenue than it saves in food costs.
⚠️ Watch out:
Eliminating popular dishes can cost more revenue than you'll save on ingredients. Calculate total impact, not just ingredient expenses.
Digital vs. Excel recipe management
Excel-based recipe tracking creates slow, error-prone business cases. Manual cross-referencing and calculations delay decisions. Digital systems display food costs, popularity metrics, and profitability instantly.
- Automatic calculations: Food costs update instantly with price changes
- Comparison overviews: Spot top and bottom performers quickly
- Scenario planning: Test pricing changes before implementation
💡 Real-world example:
Restaurant with 25 dishes on the menu:
- Excel analysis: 3 hours per month
- Digital system: 15 minutes per month
- Result: 12x faster + fewer errors
Time saved = more focus on kitchen and guests.
How do you create a menu business case? (step by step)
Gather recipe data from all dishes
Note for each dish: exact ingredient costs, selling price excl. VAT, and number of sales per week. These numbers are the foundation for every menu change.
Calculate food cost and gross profit per dish
Use the formula: food cost % = (ingredient costs / selling price excl. VAT) × 100. Also calculate gross profit per portion by subtracting ingredient costs from selling price.
Place each dish in the 4 quadrants
Cross popularity (number of sales) with profitability (food cost %). Dishes with high sales + low food cost are your stars. Low sales + high food cost are candidates to remove.
Calculate the total impact of changes
For each dish you want to adjust: calculate how much revenue and profit you lose or gain. Multiply the difference per portion by the number of sales per year.
✨ Pro tip
Track ingredient crossover rates across your top 8 dishes every 6 weeks. An expensive ingredient becomes profitable when it appears in 3+ recipes, reducing waste and boosting margins.
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 often should I analyze my recipe data for menu changes?
Review menu performance quarterly at minimum, using sales data and cost fluctuations as triggers. Seasonal restaurants or those facing frequent supplier price changes benefit from monthly analysis.
What if a dish is popular but not profitable?
First attempt cost reduction through cheaper ingredients or smaller portions. If unsuccessful, raise prices carefully or position it as a 'loss leader' that drives sales of profitable sides and beverages.
Should I always remove the least profitable dish?
Not necessarily. Evaluate other benefits first: does it attract new customers, require minimal prep time, or boost beverage sales? Sometimes minor adjustments work better than elimination.
How do I prevent spending too much time on recipe analysis?
Focus on your 10 highest-volume dishes - they drive 80% of your financial results. Digital systems automate calculations, freeing up time for actual cooking and customer service.
What food cost percentage triggers menu change decisions?
Target 28-35% for most restaurants. Dishes exceeding 35% food cost need adjustment unless they serve strategic purposes like signature status or high drink attachment rates.
How do I calculate the true profit impact when removing a dish?
Multiply weekly sales volume by gross profit per portion, then factor in any lost beverage or side dish sales. Don't just look at ingredient savings - measure total revenue loss.
Should I test menu changes on specific days before full implementation?
Yes, run 2-3 week tests on slower weekdays first. Track customer reactions, kitchen efficiency, and financial performance before rolling changes to busy weekend service.
📚 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 recipes in one place, forever
Recipes in heads, on notes, in folders — that doesn't work. KitchenNmbrs centralizes all your recipes with costs, allergens, and portions. Try it free for 14 days.
Start free trial →