Most restaurant owners check their bank account and panic – they see thousands going out but can't pinpoint where the money's bleeding. The reality? Your ingredient families tell the real story behind those scary purchase totals.
Why track purchases by ingredient family?
Looking at total purchase amounts is like driving blindfolded. You might spend €5,200 this month versus €5,000 last month and think it's normal inflation. But what if meat jumped 25% while vegetables dropped 15%? You'd never know without breaking it down.
💡 Example:
Restaurant De Smaak, March vs February:
- Meat: €2,800 → €3,360 (+20%)
- Fish: €1,200 → €1,320 (+10%)
- Vegetables: €800 → €720 (-10%)
- Dairy: €400 → €420 (+5%)
Total: €5,200 → €5,820 (+12%)
Without analysis you'd think: "12% increase, must be inflation." With analysis you see: meat is the problem.
The 8 core ingredient families
Most kitchens work with these categories:
- Meat (beef, pork, chicken, lamb)
- Fish and seafood
- Vegetables and fruit
- Dairy (cheese, butter, cream, milk)
- Grains and pasta (rice, pasta, bread, flour)
- Herbs and spices
- Oils and fats
- Non-alcoholic beverages (soft drinks, coffee, tea)
Customize for your concept. A pizzeria might separate "Pizza dough ingredients" while a sushi bar needs "Sushi-specific items."
Calculate cost per ingredient family
For each family, you need three key numbers:
💡 Example calculation meat:
March 2024:
- Total meat purchases: €3,360
- Number of covers: 1,200
- Revenue March: €28,000
Cost per cover: €3,360 ÷ 1,200 = €2.80 per guest
Percentage of revenue: (€3,360 ÷ €28,000) × 100 = 12%
Trend vs previous month: €2.80 vs €2.33 = +20%
Build your monthly tracking system
Set up a table with these columns:
- Ingredient family
- Total purchases this month (€)
- Cost per cover (€)
- % of total revenue
- Trend vs previous month (%)
- Average price per kg/liter
⚠️ Note:
Always calculate with your revenue EXCLUDING VAT. Otherwise your percentages will look lower than they are. At €28,000 incl. 9% VAT that's €25,688 excl. VAT.
I've seen restaurants lose €200-400 monthly because they don't catch ingredient price spikes early. One client didn't notice their fish supplier raised prices by 30% until three months later – that delay cost them €1,200 in unexpected expenses.
Red flags that demand action
Watch for these warning signals:
- Increase >15% in one month without seasonal reasons
- Cost per cover rises while guest count stays stable
- One family >40% of total purchases (dangerous dependency)
- Average price per kilo jumps without menu price adjustments
💡 Example action:
You see fish got 25% more expensive in March:
- Check: was this at all suppliers?
- Consider: temporarily use a different fish on the menu
- Calculate: how much do you need to raise menu prices?
- Decide: accept lower margin or adjust prices
Manual tracking vs digital solutions
Excel works but eats time and breeds errors. Food cost calculators can automatically group ingredients by family and spot trends instantly.
Digital systems offer:
- Automatic cost-per-cover calculations
- Visual charts showing trends at a glance
- Recipe integration for direct food cost impact
- One-click month-to-month comparisons
Turn analysis into action
Data without decisions is worthless. Block 30 minutes monthly to review your overview and answer:
- Which family increased the most?
- Can I negotiate better prices elsewhere?
- Do menu prices need adjusting?
- Are there substitute ingredients available?
How do you set up a monthly purchase overview? (step by step)
Collect all invoices from the month
Get all supplier invoices from the past month. Sort them by supplier and add up the total amount. Make sure you also include small purchases (supermarket, cash & carry).
Distribute purchases across ingredient families
Go through each invoice and note which family each ingredient belongs to. Add up the total amount per family. Start with the 8 main families: meat, fish, vegetables, dairy, grains, herbs, oils, beverages.
Calculate cost per cover and percentage of revenue
Divide the costs per family by your number of covers this month. Also calculate the percentage of your total revenue (excluding VAT). Compare with the previous month to spot trends.
Analyze deviations and create action points
Look at increases above 15% or families that make up more than 40% of your purchases. Create concrete action points: check other suppliers, adjust menu price or replace ingredient.
✨ Pro tip
Focus your monthly analysis on the top 2 most expensive ingredient families first – they typically represent 60-70% of your total purchases. Master those two categories and you'll control the majority of your food costs within 15 minutes.
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 purchase overview?
Monthly works for most restaurants. If you're dealing with volatile prices or heavy seasonal ingredients, every two weeks makes sense. Weekly updates are usually overkill unless you're in a very high-volume operation.
What if one ingredient family makes up more than 50% of my purchases?
You're dangerously dependent on that category. Diversify your menu or find cheaper alternatives within that family. A steakhouse hitting 50% meat is normal – a bistro isn't.
Should I include VAT in my purchase analysis?
Never include VAT in your calculations. Supplier invoices are typically VAT-excluded anyway, but double-check yours. For revenue comparisons, use your VAT-excluded revenue too.
How do I handle seasonal products in my analysis?
Add a seasonal effects column to your tracking. Compare this May to last May, not to April. Asparagus costs spike in May but drop in June – that's normal seasonality, not a pricing problem.
📚 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.
Optimize your purchasing with data
Know exactly which supplier is most cost-effective and how price changes affect your margins. KitchenNmbrs links purchasing directly to recipe costs. Try it free for 14 days.
Start free trial →