Menu analysis based on POS data shows you which dishes actually make money. Many restaurant owners think their most popular dish is also the most profitable, but that's often not the case. With real-time POS data you can exactly calculate which menu adjustments increase your margin.
What is margin impact of menu analysis?
Margin impact shows how much extra profit you make by smartly adjusting your menu. You combine two figures: popularity (how often sold) and profitability (food cost percentage). Dishes that are popular but not profitable are costing you money.
💡 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
Each dish falls into one of four categories:
- Stars: Popular + profitable (keep and promote)
- Plowhorses: Popular + not profitable (raise price or adjust recipe)
- Puzzles: Not popular + profitable (promote more)
- Dogs: Not popular + not profitable (remove from menu)
Calculating margin impact per dish
For each dish you calculate the impact on your total margin:
Formula:
Margin impact = (Number sold × Selling price excl. VAT × Food cost%) × 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 POS system gives you three crucial figures:
- Sales quantities: How many of each dish per week/month
- Revenue per dish: Total revenue per item
- Average ticket value: Impact on total spending
⚠️ Note:
POS revenue is including VAT, but for food cost you always calculate excluding VAT. Divide by 1.09 for the correct calculation.
Scenario analysis for menu changes
Calculate the impact of different scenarios:
- Scenario 1: Raise price of poor performers
- Scenario 2: Adjust recipe for better food cost
- Scenario 3: Replace poor dishes by promoting good ones
💡 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
Start with your biggest impact opportunities:
- Identify your top 5 best-selling dishes
- Check the food cost of each dish
- Focus first on 'Plowhorses' (popular but not profitable)
- Test changes for 4-6 weeks
A system like KitchenNmbrs helps you automatically calculate food cost per dish and link it to your sales data, so you immediately see which dishes generate the most profit.
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
Focus first on your 5 best-selling dishes. If those have good food cost, you've solved 80% of your margin problems.
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?
Check your sales figures and food cost monthly. Make major menu changes a maximum of 2-3 times per year, but you can make small adjustments (prices, portions) more frequently.
What if my POS system doesn't have detailed reporting?
Manually note for 2 weeks how many of each dish you sell. That already gives you a good picture of your most popular items to start with.
Do I need to account for seasons in my analysis?
Yes, analyze at least a full season (3 months of data). Summer dishes sell differently than winter dishes, so compare apples with apples.
What is a realistic margin improvement through menu optimization?
Restaurants see an average 3-8% improvement in total margin through smart menu adjustments. That can be €15,000-40,000 per year at €500,000 revenue.
Can I always charge more for dishes with low food cost?
Not automatically. First check if the price is still market-appropriate and whether customers are willing to pay more. Test price increases carefully in steps of €1-2.
📚 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.
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 →