Ever wondered why your restaurant feels busy but profits remain disappointing? The culprit might be hiding in plain sight - a popular dish with terrible margins dragging down your entire menu's profitability. Here's how to calculate your true weighted average margin and stop money from walking out your kitchen door.
Why weighted average matters
A simple average of your margins is essentially useless. That dish you're selling 100 times monthly carries far more weight than something that moves just 5 times.
💡 Example:
You have 3 dishes:
- Steak: 40% margin, 20 sales per month
- Pasta: 60% margin, 5 sales per month
- Fish: 35% margin, 75 sales per month
Simple average: (40% + 60% + 35%) / 3 = 45%
But this is completely misleading! Fish dominates your actual sales.
The formula for weighted average
With weighted average, you don't just add margins together. You weight them by their actual sales volume:
Weighted average margin = (Margin1 × Sales1 + Margin2 × Sales2 + etc.) / Total sales
💡 Example calculation:
Using the same figures as above:
- Steak: 40% × 20 = 800 points
- Pasta: 60% × 5 = 300 points
- Fish: 35% × 75 = 2,625 points
Total: 800 + 300 + 2,625 = 3,725 points
Total sales: 20 + 5 + 75 = 100
Weighted average: 3,725 / 100 = 37.25%
See the massive difference? Instead of 45%, your real average margin is 37.25%. I've seen this mistake cost restaurants EUR 200-400 monthly because they're unaware their bestseller is bleeding money.
What time period should you use?
Pull at least 1 month of data, but 3 months gives you a much cleaner picture. Shorter periods get skewed by daily specials or weird weather patterns.
⚠️ Note:
Always calculate with margins excluding VAT. If your menu price is €32.00 including VAT, calculate with €29.36 excluding VAT (at 9% VAT).
What to do with your result
A healthy weighted average margin for restaurants sits between 65-72% (meaning 28-35% food cost). If you're below this range, examine:
- Your bestselling dishes with terrible margins
- Price adjustments for high-volume items
- Promoting higher-margin dishes more aggressively
- Identifying and fixing loss-leaders
Calculate automatically
Doing this calculation manually every month is tedious and error-prone. Food cost management tools can show your weighted average margin automatically, pulling from your recipes and POS sales data.
How do you calculate weighted average margin? (step by step)
Collect sales numbers per dish
Pull from your POS system how many of each dish you've sold in the past month. Note this per dish in a list.
Calculate the margin per dish
For each dish: (Selling price excl. VAT - Ingredient costs) / Selling price excl. VAT × 100. This gives you the margin as a percentage.
Multiply margin by sales numbers
For each dish: margin × number of sales. Add all results together and divide by the total number of sales of all dishes combined.
✨ Pro tip
Calculate your weighted average for just your top 8 dishes sold over the past 6 weeks. These likely represent 75% of your total volume and will reveal if your money-makers are actually making money.
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
Do I need to include all dishes in the calculation?
Include at least your top 10 bestsellers. These typically represent 80% of your revenue and give you an accurate picture of your true average margin.
What if I have seasonal dishes that aren't being sold right now?
Skip seasonal dishes during their off-periods. Calculate separate weighted averages for summer and winter menus if you have major seasonal variations. This gives you more actionable data.
How often should I recalculate this?
Monthly recalculation is ideal. Price changes, recipe modifications, or supplier cost increases can shift your weighted average significantly within just a few weeks.
What is a good weighted average margin?
For restaurants, 65-72% margin (28-35% food cost) is healthy. Below 65% usually means your popular dishes aren't profitable enough to sustain the business long-term.
⚠️ 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.
Set selling prices based on facts
Guessing at prices? KitchenNmbrs calculates the ideal selling price based on your actual food cost and desired margin. Test it free for 14 days.
Start free trial →