Picture this: you're planning next quarter's budget, staring at last month's P&L, hoping those numbers tell the whole story. They don't. Historical data reveal patterns that help you predict costs with real accuracy. You can spot seasonal shifts, cost trends, and growth patterns before they catch you off guard.
Collect at least 12 months of P&L data
Reliable forecasts need a full year of data. Shorter periods give you a skewed view because of seasonal swings.
- Monthly P&L summaries from at least 12 months
- Weekly breakdowns for peak periods (Christmas, summer rush)
- Revenue per month and cost categories
- Cover counts or transaction volumes per period
💡 Example: Bistro with seasonal swings
Annual revenue €480,000, but the distribution varies wildly:
- Summer peak (Jun-Aug): €50,000/month
- Winter lull (Nov-Feb): €35,000/month
- Shoulder seasons: €40,000/month
Without this historical view, you'd budget too optimistically for those lean winter months.
Identify cost patterns and trends
After managing kitchen operations for nearly a decade, I've seen how costs don't always mirror revenue movements. Some stay rock-solid, others fluctuate, and some march to their own beat.
- Fixed costs: Rent, insurance, software subscriptions - remain constant
- Variable costs: Food purchases, delivery fees - track with revenue
- Semi-variable costs: Labor, utilities - scale up but not in perfect sync
⚠️ Watch out:
Energy costs look variable but include fixed connection fees plus seasonal spikes (AC in summer, heating in winter).
Calculate average percentages per cost category
For each expense category, you'll calculate its percentage of revenue across multiple months. This becomes your baseline for future budgets.
💡 Example: Food cost analysis over 12 months
- Average food cost: 31.2%
- Lowest month: 28.5% (February - limited fresh options)
- Highest month: 34.1% (August - premium summer ingredients)
Budget 33-34% for summer months, 29-30% for winter planning.
Spot seasonal patterns and external factors
Historical data reveal which months consistently deviate and the reasons behind those shifts. This knowledge drives realistic planning.
- Tourist seasons: different customer mix, altered menu preferences
- Holiday periods: revenue spikes but labor costs jump too
- Supplier cycles: seasonal produce affects pricing
- Utility patterns: cooling costs vs. heating expenses
Build forecast models per cost category
Armed with historical percentages, you can create accurate budgets for upcoming periods.
💡 Example: Labor cost forecast
Historical staffing patterns:
- Slow periods: 28% of revenue
- Busy months: 32% of revenue (additional shifts)
- Holiday periods: 35% of revenue (overtime premiums)
December projection with €45,000 revenue: €45,000 × 35% = €15,750 in labor costs.
Update your forecasts with new data
Each month brings fresh data to refine your predictions. Market conditions shift, supplier pricing changes, your menu evolves - and your forecasts should too.
- Monthly: actual vs. projected comparisons
- Quarterly: seasonal pattern adjustments
- Annually: comprehensive percentage reviews
⚠️ Watch out:
Forecasts remain educated guesses. Build in a 5-10% buffer for surprise expenses in your budget planning.
How do you build a cost forecast based on P&L data?
Collect 12-24 months of P&L data
Gather all monthly P&L summaries. Note per month the revenue and all cost categories (food, staff, energy, etc.). The more data, the more reliable your forecast.
Calculate percentages per cost category per month
For each month: divide each cost category by revenue and multiply by 100. For example: €12,000 food cost on €40,000 revenue = 30% food cost that month.
Identify patterns and seasonal effects
Look for recurring patterns: are certain months structurally higher/lower? What external factors play a role (vacation, holidays, seasonal ingredients)?
Create forecast percentages per month
Determine for each future month what percentage you expect per cost category, based on historical patterns. Plan a buffer of 5-10% for unexpected costs.
✨ Pro tip
Focus your initial 18-month analysis on food costs, labor, and rent - your three largest expense categories. These typically represent 65-75% of total operating costs, so accurate forecasting here gives you solid budget control.
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 much historical data do I need at minimum?
At least 12 months for reliable seasonal patterns. With 24 months you can also see year-on-year trends. Less than 12 months gives a distorted picture due to seasonal effects.
What if my restaurant hasn't been open for a year yet?
Use industry benchmarks as a starting point and compare with similar businesses. Start building your own database from month 1. After 6 months you'll already see first patterns.
How accurate are P&L forecasts usually?
Good forecasts fall within 5-15% of reality. Fixed costs are most predictable, variable costs have more variation. Always plan a buffer.
Do I need to analyze all cost categories separately?
Focus first on the biggest ones: food, staff, rent, energy. These 4 are often 70-80% of your total costs. You can group smaller items as 'other costs'.
Should I weight recent months more heavily than older data?
Yes, give the most recent 6 months about 60% weight in your calculations. Older data provides context but recent trends matter more for accuracy.
How do I handle one-time expenses in my historical analysis?
Strip out major one-time costs like equipment purchases or renovation expenses before calculating percentages. These skew your baseline and don't repeat in normal operations.
📚 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.
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →