73% of restaurants fail within their first three years, and uncontrolled food costs play a major role. Your ingredient expenses shift monthly due to supplier hikes, seasonal changes, and menu additions. A basic tracking chart reveals these trends before they damage your bottom line.
Why your food cost shifts monthly
Food costs aren't static numbers. They fluctuate constantly because of several factors:
- Suppliers increase prices - sometimes without clear notification
- Seasonal variations - winter vegetables cost significantly more than summer produce
- Untested new dishes - recipes you haven't properly costed yet
- Portion creep - kitchen staff gradually serving bigger servings
⚠️ Watch out:
Most owners discover food cost problems during annual reviews. By then, damage is already done.
Start with a basic line chart
You don't need advanced spreadsheet skills. A straightforward line graph shows if costs are climbing, dropping, or holding steady.
💡 Example:
Café Milano monitors food costs monthly:
- January: 28.5%
- February: 29.3%
- March: 30.8%
- April: 32.1%
Clear pattern: costs climbing each month. Action needed now.
Essential data points
Collect these numbers monthly for accurate tracking:
- Raw ingredient spending - total paid for all food products
- Food-only sales - exclude drinks and alcohol (before VAT)
- Cost percentage - spending divided by sales × 100
💡 Calculation:
April 2024:
- Ingredient spending: €7,890
- Food sales excl. VAT: €24,200
- Food cost: (€7,890 / €24,200) × 100 = 32.6%
Reading your chart patterns
Your food cost chart reveals important trends instantly:
Upward trend: Expenses outpacing menu prices. Supplier costs increased or portions got bigger.
Downward slope: You're managing well. Either prices went up or you found better suppliers.
Zigzag pattern: Seasonal fluctuations. Produce costs more in winter, less during harvest season.
💡 Real case:
Trattoria Bella noticed costs jump from 27% to 33% over four months - a mistake that costs the average restaurant EUR 200-400 per month:
- Problem: fish supplier raised prices 25%
- Fix: increased seafood pasta from €24 to €28
- Outcome: food cost dropped to 28%
Monthly tracking works perfectly
Don't obsess over weekly numbers. They create confusion. Monthly reviews provide clear insights:
- First week monthly: Total previous month's ingredient purchases
- Calculate percentage - divide purchases by food revenue
- Add to chart - Excel, apps, or paper tracking
- Spot trends - compare against previous months
Tools that simplify tracking
Manual tracking works, but technology makes it smoother:
- Excel or Google Sheets: No cost, but requires manual data entry
- Restaurant management apps: Calculate food costs automatically each month
- Specialized tools like KitchenNmbrs: Display cost trends in visual charts without manual calculations
⚠️ Watch out:
No software automatically captures your purchases. You must input or connect invoices manually.
How do you create a food cost chart? (step by step)
Gather monthly figures
Add up all ingredient invoices from last month. Get your food revenue (excl. VAT) from your POS system. Calculate: (purchases / revenue) × 100 = food cost %.
Create a simple chart
Put months on the horizontal axis, food cost % on the vertical axis. Start at 20% and end at 40% for a good overview. Plot your first point.
Add a point each month
Calculate your new food cost % each month and add the point to your chart. Connect the points with a line. After 3-4 months you'll see the trend.
✨ Pro tip
Create separate trend lines for your top 3 revenue-generating dishes alongside your overall food cost chart. Monitor them for 6 months to catch profit-killing patterns before they spread across your entire menu.
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 beverages in my food cost chart?
No, track only food ingredients. Beverages have different profit margins and will distort your food cost picture. Calculate drink costs separately for accuracy.
What if my food cost fluctuates a lot every month?
Seasonal ingredients cause natural fluctuations. Look at three-month averages instead of individual months to spot real trends.
What food cost percentage is normal for restaurants?
Most restaurants operate between 28% and 35%. Above 35% makes profitability challenging, while below 25% might indicate pricing opportunities.
How often should I update my chart?
Monthly updates provide the right balance. Weekly creates too much noise, while quarterly misses important trends.
Can I track individual dishes instead of total costs?
Yes, but start with your five top-selling items. Tracking every dish creates overwhelming complexity without much additional insight.
What should I do when my chart shows costs rising for three straight months?
This signals a clear trend requiring immediate action. Check supplier invoices for price increases, measure portion sizes, and consider menu price adjustments.
📚 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 →