A restaurant owner discovers they've been ordering 40% more chicken than needed every week. Three months of consumption tracking revealed the actual pattern - saving €200 weekly just on poultry. Your historical data holds similar money-saving insights.
Why historical data beats guesswork
Most restaurant owners order based on instinct. Thursday feels busy, so they double the salmon order. But feelings deceive you - data doesn't.
Historical consumption reveals hidden patterns:
- Which days consistently run busier
- Which dishes fluctuate seasonally
- Actual daily and weekly usage amounts
- Ingredients that repeatedly spoil
💡 Example:
A bistro reviews 3 months of salmon usage:
- Monday-Tuesday: average 2 kg daily
- Wednesday-Thursday: average 4 kg daily
- Weekend: average 7 kg daily
Weekly order drops from 35 kg (guesswork) to 25 kg (data-driven). Result: €180 saved weekly.
Essential data points to capture
Don't track everything. Focus on what drives results:
1. Daily ingredient consumption
- Kilograms or liters used
- Day of the week
- Number of covers served
2. End-of-day inventory
- Leftover quantities
- Waste amounts
- Items saved for next service
3. Unusual circumstances
- Holidays, events, weather impacts
- Menu promotions or new additions
- Supply chain disruptions
⚠️ Note:
Data collection requires time investment. Begin with your 5 costliest ingredients - they'll deliver the biggest purchasing improvements.
Spotting patterns that matter
After 6-8 weeks, clear patterns emerge:
Weekly rhythms:
- Mondays typically slower (reduce orders)
- Weekends consistently busier (increase orders)
- Thursdays often prep-heavy days
Seasonal shifts:
- Summer: higher fish, salad, cold beverage demand
- Winter: increased meat, warm dish consumption
- Holiday periods: completely different preferences
Weather correlations:
- Rainy days: fewer customers, more soup sales
- Hot weather: cold dishes surge, warm dishes drop
💡 Pattern example:
Steakhouse tracks 2 months of ribeye sales:
- Friday: average 18 portions
- Saturday: average 22 portions
- Sunday: average 8 portions
- Rainy days: 30% sales drop
Rainy weekend order: 15 + 18 = 33 steaks instead of 40. Less waste, better margins.
Converting data into smart orders
Collecting numbers is step one. Smart ordering is step two:
Calculate baseline consumption
Sum the last 4 weeks' usage and divide by days operated. This becomes your foundation number.
Build in safety margins
Add 10-20% buffer for unexpected rushes. Perishables get 10%, shelf-stable items get 20%.
Adjust for known variables
Big event coming? Increase orders 30-50%. Slow week predicted? Drop by 20%.
💡 Order calculation:
Chicken thigh weekly average: 12 kg
- Base requirement: 12 kg
- Safety buffer (+15%): 12 × 1.15 = 13.8 kg
- Busy week expected (+20%): 13.8 × 1.20 = 16.6 kg
Final order: 17 kg chicken thighs
Systems and technology
Excel works but eats time. Better alternatives exist:
Digital solutions
- Food cost calculators like KitchenNmbrs automatically track usage
- Recipe-to-inventory connections
- Automated order calculations
Manual spreadsheets
- Columns: date, ingredient, consumption, covers
- Weekly average formulas
- Trend visualization charts
From tracking this across dozens of restaurants, the digital approach cuts ordering time by 60% while improving accuracy.
Ordering pitfalls to avoid
Insufficient data collection
Three weeks won't cut it. You need 6-8 weeks minimum for trustworthy patterns.
Overlooking exceptional events
That wedding week with triple sales will skew your averages. Flag and exclude outliers.
Zero-buffer mentality
Some operators order exactly their calculated need. Always maintain small cushions for surprises.
⚠️ Note:
Begin modestly. Target your 3 highest-cost ingredients initially. Success here justifies expanding to additional products.
How do you optimize your ordering pattern? (step by step)
Collect 6-8 weeks of consumption data
Track how much you use daily of your most important ingredients. Also note the number of covers and special circumstances like holidays or bad weather.
Calculate averages per weekday
Add up consumption per weekday and divide by the number of weeks. This shows you that Monday is structurally quieter than Saturday and you can order accordingly.
Add safety margin and order
Take your average consumption and add 10-20% as a buffer. Adjust for expected busy or quiet periods and place your order based on this calculation.
✨ Pro tip
Track your ordering accuracy monthly by calculating what percentage of purchases you actually use. Achieving 85% utilization indicates strong ordering discipline - anything below 70% signals chronic over-ordering.
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 many weeks of data do I need for reliable patterns?
Six to eight weeks minimum for weekly patterns. Seasonal trends require a full year of data. Weekly patterns appear first and provide immediate value.
Should I track all ingredients or focus on specific ones?
Start with your 5 most expensive ingredients - they create the biggest cost impact. Once you've mastered those, gradually expand to other products.
How do I handle exceptional days like holidays?
Flag special events in your records and exclude them from regular averages. Create separate holiday calculations based on that specific historical data.
What if my supplier delivers only twice weekly?
Calculate consumption for your entire delivery cycle period. Two deliveries weekly means planning for 3-4 day consumption periods rather than daily amounts.
📚 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.
Manage inventory without spreadsheets
Always know what you have in stock and what it's worth. KitchenNmbrs connects inventory to recipes and purchasing for complete oversight. Start your free trial.
Start free trial →