Most restaurants discover their bestselling dishes aren't their most profitable ones. Real-time POS analysis reveals exactly which menu items drain your margins and which ones boost them. You can calculate precise profit impact before making any changes.
What is margin impact of menu analysis?
Margin impact reveals how much additional profit you'll generate through strategic menu adjustments. You merge two critical metrics: sales frequency (volume) and profitability (food cost ratio). High-volume dishes with poor margins actively hurt your bottom line.
? Example:
Restaurant with 1000 covers per month:
- Pasta carbonara: 200x sold, food cost 38% (too high)
- Steak: 50x sold, food cost 28% (good)
- Risotto: 30x sold, food cost 25% (very good)
By replacing carbonara with more risotto: €2,400 extra margin per year
The 4 quadrants of menu engineering
Every dish lands in one of four performance categories:
- Stars: High volume + high profit (promote aggressively)
- Plowhorses: High volume + low profit (increase prices or reduce costs)
- Puzzles: Low volume + high profit (boost marketing)
- Dogs: Low volume + low profit (eliminate immediately)
Calculating margin impact per dish
Each menu item's financial impact gets calculated using this approach:
Formula:
Margin impact = (Units sold × Net selling price × Food cost variance) × 12 months
? Example calculation:
Pasta carbonara (poor performer):
- 50x sold per month
- Selling price: €18.50 incl. VAT = €16.97 excl. VAT
- Food cost: 38% (too high, aim for 30%)
Loss per month: 50 × €16.97 × 0.08 = €67.88
Loss per year: €814.56
Using real-time POS data
Your point-of-sale system provides three essential data points:
- Unit sales: Exact quantities sold per time period
- Item revenue: Total income generated per dish
- Check averages: How each item affects overall spending
⚠️ Note:
POS revenue includes VAT, but food cost calculations require net amounts. Divide by 1.09 for accurate figures.
Scenario analysis for menu changes
Model different improvement strategies and their financial outcomes:
- Price optimization: Increase prices on underperforming items
- Recipe modification: Reduce ingredient costs while maintaining quality
- Menu restructuring: Replace poor performers with profitable alternatives
? Scenario example:
You replace a 'Dog' (10x sold, 40% food cost) by promoting a 'Puzzle':
- Old situation: 10 × €16.97 × 0.40 = €67.88 loss/month
- New situation: 20 × €16.97 × 0.25 = €84.85 profit/month
Difference: €152.73 per month = €1,832.76 per year
Implementation of menu changes
After managing kitchen operations for nearly a decade, I've learned to prioritize the highest-impact opportunities first:
- Analyze your top 8 revenue-generating dishes
- Calculate precise food costs for each item
- Target 'Plowhorses' first (high sales, poor margins)
- Monitor results over 6-8 week periods
Tools like KitchenNmbrs automatically calculate per-dish food costs and integrate with sales data, so you can immediately identify your most profitable menu items.
Related articles
How do you calculate margin impact of menu analysis? (step by step)
Collect POS data from the past 3 months
Export from your POS system: number sold per dish, revenue per dish, and period totals. Check that the data is complete without missing days.
Calculate food cost percentage per dish
Add up all ingredient costs per portion and divide by selling price excluding VAT. Use current purchase prices, not old estimates.
Place dishes in the 4 quadrants
Divide based on popularity (above/below average sold) and profitability (food cost below/above 32%). This gives you Stars, Plowhorses, Puzzles and Dogs.
Calculate annual margin impact per change
For each proposed change: calculate the difference in monthly margin and multiply by 12. Focus on the biggest impact opportunities first.
✨ Pro tip
Pull your top 12 revenue dishes from the last 90 days and cross-reference their food cost percentages. Items above 35% food cost that appear in your top sellers are costing you thousands annually.
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 update my menu analysis?
What if my POS system doesn't have detailed reporting?
Do I need to account for seasons in my analysis?
What is a realistic margin improvement through menu optimization?
Can I always charge more for dishes with low food cost?
How do I handle dishes that are customer favorites but unprofitable?
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
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.
kennisbank.more_in_category
Related questions
Explore more topics
Engineer your menu for maximum margin
Menu engineering combines popularity with profitability. KitchenNmbrs gives you the data to strategically design your menu. Test it free for 14 days.
Start free trial →