Building a purchasing forecast is like reading your kitchen's diary - every wasted tomato tells a story. Most owners order on instinct, creating cycles of overstock and shortages. Historical waste data transforms these patterns into precise purchasing decisions.
Why use historical food waste data?
Your kitchen operates on hidden rhythms. Fish spoils more on Mondays than Tuesdays. Soup waste spikes during winter months. These patterns emerge only through systematic measurement - and once you spot them, purchasing becomes predictable.
💡 Example:
Restaurant De Keuken orders 20 kg of fish every Friday:
- Saturday sold: 12 kg
- Sunday sold: 6 kg
- Discarded: 2 kg (10%)
After tracking 3 months: winter waste jumps to 15%, summer drops to 5%.
What data do you need?
Reliable forecasting requires at least 3 months of consistent tracking:
- Daily purchase quantities per ingredient
- Actual usage amounts (what entered dishes)
- Waste quantities in grams/kg (what hit the trash)
- Waste causes (spoilage, over-prep, prep errors)
- External variables (weather, local events, seasonality)
⚠️ Note:
Record waste immediately upon disposal. End-of-day logging misses half the data.
Setting up the basic model
Start with the fundamental waste calculation - a simple average with seasonal modifications. Calculate this for each ingredient:
Waste percentage = (Discarded weight / Total purchased) × 100
💡 Example calculation:
Tomatoes across 12 weeks:
- Total purchased: 240 kg
- Total discarded: 18 kg
- Average waste: (18/240) × 100 = 7.5%
Next week's 20 kg order: anticipate 1.5 kg waste
Recognizing seasonal patterns
Break down your data by seasons or months. Most ingredients follow predictable cycles:
- Summer: Higher salad demand, lower soup usage → shifted waste patterns
- Winter: Comfort food focus, extended shelf life from cold storage
- Holiday periods: Menu variations, volume fluctuations
- Tourist seasons: Guest count changes, purchase adjustments needed
Refining the model with daily patterns
Certain weekdays consistently behave differently. Track waste by individual days:
💡 Weekly pattern example:
- Monday: 12% waste (slow service, over-preparation)
- Tuesday-Thursday: 6% waste (consistent flow)
- Friday-Saturday: 4% waste (high volume, rapid turnover)
- Sunday: 15% waste (weather-dependent traffic)
Adjusting purchases based on forecast
Transform waste percentages into purchasing decisions using this calculation:
Adjusted purchase = Projected sales / (1 - Waste percentage)
💡 Practical example:
Weekend fish sales projection: 15 kg. Historical waste: 8%
- Previous order: 18 kg (guesswork)
- Calculated order: 15 / (1 - 0.08) = 16.3 kg
- Reduction: 1.7 kg fewer = €25-30 waste savings
Keeping the model digital
Manual tracking becomes overwhelming quickly. Based on real restaurant P&L data, establishments using digital tracking see 23% better waste reduction than paper-based systems. Tools like KitchenNmbrs automate pattern recognition and flag ingredients with consistently high waste rates.
⚠️ Note:
Models guide decisions but don't replace judgment. Heat waves and special events require manual overrides.
Measuring and adjusting results
Monthly accuracy checks keep your model sharp. Track these metrics:
- Variance between predicted and actual waste
- Financial impact from reduced food disposal
- Stockout frequency (under-purchasing incidents)
Effective models predict within 2-3% of actual waste. This typically delivers 20-40% waste reduction without customer disappointment from shortages.
How do you set up a forecast model? (step by step)
Collect 3 months of basic data
Note daily per ingredient: purchase weight, consumption, and waste weight. Also measure external factors like weather and busyness. Without this foundation, you can't identify reliable patterns.
Calculate waste percentages per ingredient
Divide waste weight by purchased weight, multiply by 100. Do this per weekday and per season. This shows you which ingredients are structurally problematic.
Adjust your purchase with the formula
Use: Purchase = Expected sales / (1 - Waste percentage). Test this for 4 weeks and measure if your forecast is accurate. Adjust the percentage if you consistently over or under-purchase.
✨ Pro tip
Track your 3 highest-cost, highest-waste ingredients for 8 weeks minimum before expanding the model. These items typically represent 70% of your potential savings - perfect accuracy on everything else won't match good forecasting on your biggest waste drivers.
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 data do I need at minimum for a reliable model?
At least 3 months of daily tracking per ingredient creates baseline accuracy. Seasonal patterns require a full year of data. Focus initially on your 5 most expensive ingredients - they deliver the biggest financial impact.
What if my waste percentage fluctuates wildly each week?
Wild fluctuations indicate unmeasured external factors. Weather patterns, local events, or menu changes often cause this volatility. Identify and incorporate these variables into your model for better stability.
Can I also use this model for prepared dishes and mise-en-place?
Absolutely, but shift from ingredient-based to dish-based measurements. Track how much prepared soup gets discarded daily, then apply that percentage to reduce tomorrow's batch size. Same principle, different application.
📚 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.
Make food waste measurable and manageable
Every kilo you throw away is lost margin. KitchenNmbrs connects your inventory to your recipes so you can see exactly where waste occurs — and how much it costs. Try it free.
Start free trial →