Most restaurant owners track their total food costs religiously, yet miss the subtle price creep happening within ingredient categories. While you're focused on weekly sales, beef quietly jumps 15% and dairy climbs 12% over three months. Calculating average purchase prices per category reveals these hidden profit killers before they devastate your margins.
Why track average purchase prices?
Your suppliers raise prices constantly. Sometimes 5%, other times 20%. Without tracking this, inflation silently destroys your profit margins.
💡 Example:
Beef Q1 2024:
- January: €24.50/kg
- February: €26.20/kg
- March: €27.10/kg
Average Q1: €25.93/kg (+6% vs. January)
Quarterly averages reveal trends so you can adjust menu prices before it's too late.
Which categories should you track separately?
Focus on your biggest cost drivers. For most restaurants, these categories matter most:
- Meat and fish (typically 40-50% of food cost)
- Dairy (butter, cream, cheese)
- Vegetables (fresh produce)
- Dry goods (flour, rice, pasta)
- Oils and fats
⚠️ Watch out:
Don't make categories too broad. "Meat" tells you nothing if beef jumps 20% while chicken drops 5%. Split into beef, poultry, fish for accurate tracking.
The calculation step by step
For each category, collect all purchase invoices from the quarter. Then calculate your average cost per kilo.
💡 Example beef Q1:
All beef purchases January-March:
- Total purchased: 180 kg
- Total paid: €4,668
- Average price: €4,668 ÷ 180 kg = €25.93/kg
Note: calculate with actual weight received, not what you ordered.
Recognizing trends and taking action
Compare each quarter with the previous one. After managing kitchen operations for nearly a decade, I've learned that increases over 10% demand immediate action:
- 0-5% increase: Monitor closely, no immediate action needed
- 5-10% increase: Consider menu price adjustment
- 10%+ increase: Adjust menu price or source alternative product
💡 Practical example:
Salmon jumped from €18/kg to €23/kg (+28%). Your options:
- Increase menu price from €28 to €32
- Switch to different fish (dorado, sea bass)
- Reduce portion from 180g to 160g
Digital vs. manual tracking
Excel works but consumes massive amounts of time. You'll manually enter and categorize every single invoice. Many operators use apps to track this automatically per ingredient and category.
Digital tracking shows you immediately which products increased most and how that impacts your food cost per dish.
How do you calculate average purchase prices per category?
Collect all purchase invoices from the quarter
Gather all invoices from suppliers. Note per product: date, quantity (kg/liter), total price. Sort by product category (meat, fish, dairy, etc.).
Add up totals per category
For each category: add up all quantities (total kg purchased) and all amounts (total paid). Check that you haven't missed any invoices by comparing with your bank statements.
Calculate the average price per kilo
Divide the total amount by the total quantity: average price = total paid ÷ total kg. Compare with the previous quarter to see the trend.
✨ Pro tip
Track your 3 most expensive protein categories monthly during Q1 specifically. These typically represent 65% of your food cost, so monitoring just these three figures gives you control over most of your cost fluctuations.
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
Should I include VAT in the average purchase price?
No, always calculate excluding VAT. You get VAT back through your return, so only net purchase price affects your actual costs.
What if I purchase different qualities of the same product?
Keep different qualities separate. Premium beef and standard beef are different categories because their price movements can vary dramatically.
How often should I make this calculation?
Quarterly minimum for reliable trends. For volatile products like fish or seasonal vegetables, check monthly to catch rapid changes.
How do I handle products I don't purchase every month?
Calculate only for months with actual purchases. An average over zero kilograms provides no useful information for decision-making.
📚 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.
Automate your daily kitchen controls
Manual controls take time and miss errors. KitchenNmbrs automates temperature logging, inventory management, and HACCP checks. Try it free for 14 days.
Start free trial →