Managing ingredient costs with fluctuating prices is like trying to hit a moving target blindfolded. Fish, meat, and vegetables shift in price daily, making accurate cost calculations nearly impossible. An average purchase price becomes your steady aim, giving you realistic cost projections instead of wild swings.
Why calculate an average price?
Say you buy salmon. Monday €18/kg, Wednesday €22/kg, Friday €19/kg. If you only calculate with today's price, your food cost sometimes looks low (18% on Monday) and sometimes high (24% on Friday). But your actual costs fall somewhere in between.
⚠️ Watch out:
Never calculate with the lowest price of the month. You'll underestimate costs and lose money on every dish.
Method 1: Weighted average (most accurate)
A weighted average doesn't just add up prices—it factors in how much you bought at each price point. This gives you a realistic picture of actual spending patterns.
💡 Example weighted average:
Salmon purchases last month:
- Week 1: 15 kg at €18/kg = €270
- Week 2: 20 kg at €22/kg = €440
- Week 3: 10 kg at €19/kg = €190
- Week 4: 25 kg at €20/kg = €500
Total: 70 kg for €1,400
Average: €1,400 / 70 kg = €20/kg
Weighted average formula:
(Total amount all purchases) / (Total number of kg) = Average price per kg
Method 2: Moving average
Update your average price with each new purchase. This keeps cost calculations current without extreme swings that'll throw off your margins.
💡 Example moving average:
Current stock: 20 kg at €19/kg = €380
New purchase: 15 kg at €23/kg = €345
New stock: 35 kg for €725
New average price: €725 / 35 kg = €20.71/kg
Method 3: Seasonal average
For products with strong seasonal swings, calculate averages over entire seasons or years. This prevents losses during expensive periods—something most kitchen managers discover too late after a brutal winter vegetable season.
- Collect prices from at least 3 months
- Calculate weighted average over this period
- Update every 3 months or per season
- Account for holidays (price spikes)
Practical tips for daily purchasing
Keep a purchase log with date, supplier, quantity and price. Update your average price weekly at minimum. With large price swings (more than 20%) adjust immediately—don't wait.
⚠️ Watch out:
Check your average price against actual spending. If you consistently spend more than your average, there's an error in your calculation.
Digital tracking saves time
Manually tracking fluctuating prices eats up valuable time. A system automatically calculates weighted averages and adjusts cost prices. You'll have current figures without manual number-crunching.
How do you calculate an average purchase price? (step by step)
Collect your purchase data
Note for each purchase: date, supplier, quantity (kg) and price per kg. Do this for at least 4 weeks to get a reliable average.
Calculate the weighted average
Add up all amounts and divide by the total number of kg. Formula: (Total amount) / (Total kg) = Average price per kg.
Update your cost prices
Adjust all recipes with the new average purchase price. Recalculate your food cost and check if your menu price still works.
Repeat weekly
Update your average every week with new purchases. With large price fluctuations (>20%) adjust immediately to avoid surprises.
✨ Pro tip
Track your 8 highest-cost ingredients over a 30-day period first. Once those have stable average prices, you've solved roughly 75% of your cost calculation headaches.
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 average price?
At least weekly, or immediately with large price fluctuations over 20%. This keeps you close to actual costs without constant adjustments.
What if I buy from multiple suppliers?
Include all suppliers in one weighted average. Individual supplier prices don't matter—only your total costs count for accurate food cost calculations.
Should I include waste in my average purchase price?
No, calculate your average purchase price first. Add waste later as a percentage of your total food cost during recipe costing.
What if a product becomes temporarily unavailable?
Use your last calculated average price for recipe costing. Once you can purchase again, update the average with new prices and quantities.
Can I use different averages per season?
Yes, that's even more accurate for seasonal products. Calculate separate summer and winter averages for ingredients with large seasonal price variations.
How do I handle one-time price spikes from supply shortages?
Don't let single extreme prices skew your average. Cap unusual spikes at 30% above normal range, or exclude them if they represent less than 5% of total volume.
📚 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 →