I'll admit it: I used to guess at price changes and it nearly killed my margins. Too many hospitality entrepreneurs get stuck in Excel sheets or rely on mental math, missing crucial opportunities to optimize their profits. Master these simple methods and you'll run through multiple price scenarios in seconds.
Why quick price calculations are crucial
Your supplier raises prices by 15%. Your competitor lowers their menu. A new trending ingredient becomes popular but expensive. In all these situations, you need to quickly calculate what different prices mean for your profit.
⚠️ Watch out:
Many entrepreneurs estimate price impact. "It won't be that bad" can cost you thousands of euros per year without you realizing it.
The basics: understanding food cost percentage
For every price calculation you need this formula:
Food cost % = (Ingredient costs / Sales price excl. VAT) × 100
And conversely, to calculate a minimum selling price:
Minimum price excl. VAT = Ingredient costs / (Desired food cost % / 100)
💡 Example:
Your pasta costs €6.50 in ingredients. You want 30% food cost:
- Minimum price excl. VAT: €6.50 / 0.30 = €21.67
- Price incl. 9% VAT: €21.67 × 1.09 = €23.62
- Rounded: €23.95 on your menu
Method 1: The quick calculation table
Create a simple table with different food cost percentages. For each dish, note the ingredient costs and calculate what the minimum selling price would be at different margins.
💡 Example calculation table:
Ingredient costs: €8.00
- At 25% food cost: €8.00 / 0.25 = €32.00 excl. VAT (€34.88 incl.)
- At 30% food cost: €8.00 / 0.30 = €26.67 excl. VAT (€29.07 incl.)
- At 35% food cost: €8.00 / 0.35 = €22.86 excl. VAT (€24.92 incl.)
Difference between 25% and 35%: €9.96 per plate!
Method 2: Calculate the impact of price changes
If your supplier raises prices, you can quickly calculate what this means for your selling prices or margins. Use this formula:
New food cost % = (Old ingredient costs × (1 + price increase %)) / Current sales price excl. VAT × 100
💡 Example price increase:
Your steak currently has:
- Ingredient costs: €12.00
- Sales price: €35.00 excl. VAT
- Current food cost: 34.3%
Supplier raises meat price by 20%:
- New ingredient costs: €12.00 × 1.20 = €14.40
- New food cost: €14.40 / €35.00 = 41.1%
- Or raise price to: €14.40 / 0.343 = €42.00 excl. VAT
Method 3: Calculate competitor analysis
If you know what your competitor charges, you can figure out what food cost they're using or what your margin would be at that price.
- Note competitor prices for similar dishes
- Calculate what your food cost would be at that price
- Determine if you can match it without losing money
- Look for alternatives: cheaper ingredients, smaller portions, different garnish
⚠️ Watch out:
Never go below your break-even point. Better a higher price than losing money on every plate you serve.
Method 4: Calculate seasonal and market price fluctuations
Ingredient prices fluctuate. Especially with fresh products, prices can differ 50-100% between seasons. This mistake alone costs the average restaurant EUR 200-400 per month in lost profits. Regularly calculate what these fluctuations mean for your margins.
💡 Example seasonal impact:
Asparagus in your spring dish:
- April (in season): €8.00/kg → food cost 28%
- December (imported): €24.00/kg → food cost 45%
- Option 1: Raise price to €45.00 in winter
- Option 2: Create a seasonal menu
- Option 3: Use alternative ingredient in winter
Digital tools for faster calculations
While you can do a lot with a calculator or Excel, specialized tools make the process much faster. They automatically calculate all variants and immediately show the impact on your profit.
Tools like KitchenNmbrs do these calculations automatically. You enter your ingredient costs and immediately see what your food cost will be at different prices. Handy for quick calculation sessions.
Deciding on price adjustments
Not every cost change requires an immediate price increase. Consider these factors:
- Scale: An increase of more than 2 percentage points in food cost requires action
- Competition: Can your prices go up too or are you alone?
- Dish popularity: Menu favorites can often handle a higher price
- Season: In peak season, guests more readily accept price increases
- Alternative solutions: Can it also work with cheaper ingredients?
How do you quickly calculate different price scenarios?
Gather your current figures
Note for your main dishes: ingredient costs, current selling price, and current food cost percentage. These are your starting points for all calculations.
Create a calculation table
Put your ingredient costs in the first column in Excel or on paper. Create columns for different food cost percentages (25%, 30%, 35%) and calculate the corresponding minimum selling prices.
Test different scenarios
Calculate what happens with supplier price increases (+10%, +20%), lower competitor prices (-€2, -€5), and seasonal fluctuations. Note at which prices you still maintain sufficient margin.
✨ Pro tip
Set up a 90-second price check routine every Tuesday morning: plug your top 3 dishes into a simple calculator with current ingredient costs. If any food cost jumps above 35%, you know exactly which prices need immediate attention.
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 recalculate my prices?
Check your 5 most popular dishes at least monthly. During major supplier price changes, recalculate immediately. Many entrepreneurs do this too infrequently and miss out on income.
What if my competitor is always cheaper?
Never go below your break-even point. Focus on other value: better quality, larger portion, superior service. Or find ways to lower your costs without sacrificing quality.
Can I also calculate using gross margin instead of food cost?
Yes, gross margin is 100% minus food cost percentage. At 30% food cost you have 70% gross margin. Both methods give the same result, choose whichever makes more sense to you.
Should I include VAT in my calculations?
Always calculate food cost excluding VAT. The VAT isn't yours, you pass it on to the tax authority. Your actual selling price is always excluding VAT.
What food cost percentage should I target for different dish types?
Appetizers can handle 25-30% food cost, mains typically 28-35%, desserts 20-25%. High-labor dishes like risotto can justify higher food costs since your time adds value.
How do I handle dishes with wildly fluctuating ingredient costs?
Create price bands based on seasonal costs or switch to market-price menus. Alternatively, build a 15% buffer into your calculations to absorb moderate fluctuations without constant repricing.
📚 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.
Selling food? Then you need KitchenNmbrs
Whether you run a restaurant, food truck, catering company, or meal kit business — you need to know what each dish costs. KitchenNmbrs gives you that insight. Start your free trial.
Start free trial →