Build a system that instantly translates supplier price changes into accurate menu prices, and you'll stop bleeding money on outdated costs. Purchase prices shift constantly, yet most kitchens wait months before adjusting their menu prices. Every day of delay costs you real money.
Why you need this system
Your supplier raises the price of beef by 15%. You don't adjust your menu price. Every steak you sell now costs you an extra €2.40. At 50 steaks per week, you lose €6,240 per year on just one dish.
Most business owners only notice this at the end of the month, and by then the damage is done.
⚠️ Note:
Suppliers often send price lists by email. If you don't process them right away, you'll be working with outdated cost prices for weeks.
The 3 pillars of a working system
An effective system has three components:
- Central ingredient database - All prices in one place
- Automatic calculation - From ingredient to dish to menu price
- Alerts - Warning signals for major price shifts
Step 1: Build your ingredient database
Start with your 20 most expensive ingredients. They determine 80% of your food cost, so focus there first.
💡 Example ingredient database:
Beef (ribeye):
- Supplier: Van der Berg Meat
- Current price: €28.50/kg
- Last update: March 15, 2024
- Used in: Steak, Carpaccio, Beef stew
Record for each ingredient:
- Exact name and specification
- Supplier
- Price per unit (kg, liter, piece)
- Date of last price update
- Which dishes it's used in
Step 2: Link ingredients to recipes
Each recipe needs to know which ingredients it contains and how much. This way, the system can automatically calculate costs without manual work.
💡 Example: Steak recipe
Ingredients per portion:
- Ribeye: 250g × €28.50/kg = €7.13
- Butter: 15g × €8.00/kg = €0.12
- Salt, pepper: €0.05
- Garnish: €1.20
Total cost price: €8.50
Step 3: Automatic calculation to menu price
Here's where the magic happens - a pattern we see repeatedly in restaurant financials is that successful operators react to cost changes within 48 hours, not weeks. Your system should immediately show what ingredient price changes mean for your menu price.
Formula: New minimum menu price = (New cost price / Desired food cost%) × 1.09
💡 Example price change:
Ribeye rises from €28.50 to €32.00/kg (+12%)
- Old steak cost price: €8.50
- New cost price: €9.38
- At 30% food cost: €9.38 / 0.30 = €31.27 excl. VAT
- New menu price: €31.27 × 1.09 = €34.08
You need to raise your steak price by €2.08
Step 4: Alerts and warnings
You don't need to act on every price change. Set clear thresholds:
- Green: Change under 5% - monitor only
- Orange: Change 5-15% - consider adjustment
- Red: Change above 15% - take immediate action
Excel vs. digital system
You can set this up in Excel, but it has serious drawbacks:
- Manual entry (error-prone)
- Not mobile accessible
- No automatic alerts
- Difficult to share with team
A digital system does the calculations automatically and alerts you to major changes.
⚠️ Note:
Update prices immediately after receiving the new supplier list. Every day you wait costs you money.
Weekly check routine
Build these checks into your weekly routine:
- Monday: Check email for new price lists
- Wednesday: Update changed prices in system
- Friday: Review impact on food cost of top 10 dishes
This takes you 30 minutes per week, but saves hundreds of euros per month.
How do you set up this system? (step by step)
Make a list of your 20 most expensive ingredients
Check your latest invoices and note which ingredients cost the most. These are usually meat, fish, and specialty products. Record the current price, supplier, and date for each ingredient.
Link ingredients to your recipes
Go through your recipes and note exactly how much of each ingredient you use per portion. Convert this to grams or milliliters for accuracy. This way you can calculate exactly what a portion costs.
Set alert thresholds
Determine at what price increase you take action. For example: at 5-10% increase you consider adjustment, at more than 15% you adjust immediately. This prevents small changes from overwhelming you.
Build a weekly update routine
Schedule 30 minutes each week to process new price lists and review the impact. Focus especially on your best-selling dishes, as that's where price changes have the most effect.
✨ Pro tip
Set up automated alerts for price changes above 8% on your top 15 ingredients within 24 hours of receiving supplier updates. This catches 90% of profit-killing cost increases before they hit your bottom line.
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 do suppliers change their prices?
On average 1-2 times per month, especially for meat and fish. Vegetables and dairy can change weekly due to seasons and market conditions.
Do I need to pass on every price change to my menu price?
No, small changes (under 5%) you can absorb in your margin. For large changes (above 15%) you do need to adjust to stay profitable.
Can I build this system in Excel?
Yes, but it requires a lot of manual work and is error-prone. A digital system does the calculations automatically and alerts you to major changes.
What if I have multiple suppliers for the same product?
Record the price from each supplier and use the cheapest for your calculation. This way you immediately see if it's worth switching suppliers.
📚 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 →