How much produce should you actually buy for tomorrow's market? Most vendors rely on guesswork, but your daily sales data holds the answer. Smart tracking turns those numbers into precise purchasing decisions.
Collect your daily sales data
Track what you sell each day, but go beyond just revenue. Record quantities per product - many market vendors only count euros, which won't help you buy smarter.
- Number of kilos sold per product
- Which day of the week it was
- Weather conditions
- Special events (market, festival)
💡 Example:
Vegetable stand on Thursday:
- Tomatoes: 15 kg sold out of 20 kg purchased
- Cucumbers: 8 kg sold out of 10 kg purchased
- Bell peppers: 12 kg sold out of 15 kg purchased
Total waste: 10 kg = €25 loss
Analyze patterns by day and season
After 4-6 weeks, you'll spot clear trends. Maybe Thursdays are always slower than Saturdays. Summer brings salad lovers, winter demands hearty vegetables.
- Average sales per day of the week
- Seasonal patterns per product
- Impact of weather on sales
- Peak days and quiet days
⚠️ Note:
Analyze at least 4 weeks of data before making changes. One rough week can throw off your entire strategy.
Calculate your optimal purchase quantity
From years of working in professional kitchens, I've learned this formula works across all food operations. Use your average sales as your foundation, then adjust for known variables:
Optimal purchase = Average sales × Correction factor + Safety margin
💡 Example calculation:
Tomatoes on Saturday (sunny weather expected):
- Average Saturday sales: 25 kg
- Adjustment for sunny weather: +20% = 30 kg
- Safety margin: +2 kg = 32 kg
Purchase: 32 kg instead of 40 kg based on gut feeling
Account for shelf life
Short-lived products demand precision. Berries and lettuce can't wait around - you need tight estimates. But potatoes and onions? They give you wiggle room.
- Short shelf life (1-2 days): purchase more conservatively
- Medium shelf life (3-5 days): more flexibility
- Long shelf life (1+ week): building inventory is possible
Adjust prices when you have surplus
Your data shows consistent overbuying on certain products? You've got two moves: buy less or drop prices to move more inventory.
💡 Example price adjustment:
You consistently have 5 kg of cucumbers left over:
- Regular price: €2.50/kg
- Promotional price from 3 PM: €2.00/kg
- Result: 3 kg extra sold, 2 kg less waste
Less waste = more profit
Digital tracking saves time
Excel gets the job done, but tools like KitchenNmbrs streamline everything. Quick smartphone entries, automatic calculations, pattern recognition - less time crunching numbers, more time selling.
- Quick entry via smartphone
- Automatic calculations
- Overview of patterns
- Less time at the computer
How do you optimize purchasing with sales data? (step by step)
Record daily sales and purchases
Note each day how much you've purchased and how much you've sold per product. Use a simple notebook or smartphone app. Don't forget to note the weather and special events.
Analyze patterns after 4 weeks
Calculate your average sales per day of the week and per product. Look for patterns: which days are busy, which products sell well in which weather. Distinguish between seasonal products and standard assortment.
Calculate optimal purchase quantity
Use the formula: Average sales × Correction factor + Safety margin. Correction factor is for example +20% for sunny weather with vegetables, or -10% for rainy days. Safety margin depends on the shelf life of the product.
✨ Pro tip
Focus on your top 3 products for the first 6 weeks of data tracking. Nail the purchasing for these money-makers and you'll eliminate 70% of your waste immediately.
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 long should I collect data before I can draw conclusions?
At least 4 weeks, but 8-12 weeks gives you reliable patterns. You'll capture different weather conditions and seasonal shifts. Don't rush the process - good data takes time.
What if I consistently buy too much of certain products?
You have three options: buy less, lower prices to move inventory faster, or drop the product entirely. Check your profit margins first - sometimes it's better to sell at a discount than waste completely.
Should I use different correction factors per season?
Absolutely. Salads fly off the table in summer heat, while root vegetables dominate winter sales. Build seasonal adjustments after collecting a full year of data.
How do I handle products with very short shelf life?
Be conservative with 1-2 day items like berries and leafy greens. Better to sell out early than throw away spoiled inventory. Track your sellout times to fine-tune quantities.
📚 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 →