Think of inventory data as your restaurant's GPS. Without it, you're driving blind through purchasing decisions, often ending up with too much food spoiling or empty shelves during busy nights. Smart inventory analysis transforms guesswork into precise purchasing that cuts waste and boosts profits.
Gather your basic data for purchase planning
Smart purchase planning needs three data types: current stock levels, sales patterns, and minimum thresholds. Start by getting a clear picture of what's sitting in your kitchen right now.
- Count your physical inventory: refrigerator, freezer, dry storage
- Note the expiration date per product
- Check which products are running low (below your minimum)
- Review your sales data from the past 2-3 weeks
💡 Example:
Bistro De Smaak counts inventory on Monday:
- Beef tenderloin: 2.5 kg (lasts 3 days)
- Salmon: 1.2 kg (lasts 2 days)
- Mushrooms: 0.8 kg (lasts 1 day)
- Last week: sold 45 beef tenderloin, 38 salmon, 62 mushroom dishes
Calculate your average daily consumption
Your daily consumption rate is the foundation of accurate ordering. Pull sales data from the last 2-3 weeks and divide by operating days. But don't just crunch numbers - factor in seasonal shifts and upcoming events.
💡 Consumption calculation:
Beef tenderloin last 3 weeks:
- Week 1: 52 portions
- Week 2: 45 portions
- Week 3: 48 portions
- Total: 145 portions in 18 days (6 days per week)
Average: 145 ÷ 18 = 8.1 portions per day
Don't forget portion weight in your calculations. With 200 grams of beef tenderloin per portion, you'll need 8.1 × 200g = 1.62 kg daily.
Set your minimum inventory and ordering frequency
Your safety stock protects against surprise rushes and delivery hiccups. Fresh items need tighter control than shelf-stable products, and from tracking this across dozens of restaurants, the sweet spot varies by category.
- Fresh fish/meat: 1-2 days buffer
- Vegetables: 2-3 days buffer
- Dry products: 5-7 days buffer
- Account for delivery frequency (daily, 2× per week, etc.)
⚠️ Note:
Never order less than your minimum inventory, even if you expect a slow week. An unexpected group of guests could leave you scrambling.
Plan your order for next week
Here's where the math pays off. Formula: (Expected consumption × number of days) + minimum inventory - current inventory = quantity to order
💡 Example calculation:
Beef tenderloin for the coming week (6 days):
- Expected consumption: 8.1 kg/day × 6 days = 48.6 kg
- Minimum inventory: 2 days = 16.2 kg
- Current inventory: 2.5 kg
- To order: 48.6 + 16.2 - 2.5 = 62.3 kg
Order: 62.3 kg beef tenderloin (rounded 63 kg)
Always check expiration dates on current stock. If products expire within 1-2 days, plan to use them first or create specials to move them before new inventory arrives.
Account for special circumstances
Standard averages don't account for the curveballs that restaurant life throws. Holidays, weather, local events, and menu changes can dramatically shift your usual patterns.
- Holidays: often 20-50% more guests
- Bad weather: fewer guests, especially lunch
- Local events: can double traffic
- New dishes: hard to estimate, order conservatively
⚠️ Note:
When in doubt: order slightly less rather than more. You can usually reorder quickly, but wasted food always hits your bottom line.
How do you plan purchases with inventory data? (step by step)
Count your current inventory and check sales figures
Make an overview of what you have per ingredient and review how much you sold over the past 2-3 weeks. Also pay attention to expiration dates of your current inventory.
Calculate your average daily consumption per product
Divide your total sales by the number of days to get your average daily consumption. Multiply by your portion weight to calculate the weight per day.
Determine your minimum inventory per product
Set a buffer of 1-2 days for fresh products and 3-7 days for shelf-stable products. This prevents you from running out during unexpected busy periods.
Calculate your order quantity
Use the formula: (expected consumption × number of days) + minimum inventory - current inventory = quantity to order. Round to practical packaging units.
✨ Pro tip
Review your par levels every 6 weeks and adjust based on actual consumption patterns. Seasonal menu changes can shift your baseline needs by 15-25%, so don't set it and forget it.
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 often should I count my inventory for good purchase planning?
Count your inventory at least once weekly, preferably on the same day each week. For highly perishable items like fish and meat, twice-weekly counts give you much more accurate planning data.
What if my sales vary greatly from day to day?
Use at least 3 weeks of data and look for patterns instead of just averages. Friday and Saturday typically see higher volume, Monday tends to be slower. Plan by individual days rather than weekly totals for better accuracy.
How much buffer should I maintain for unexpected busy periods?
Fresh products need 1-2 days buffer, shelf-stable items need 3-7 days. During peak seasons like holidays or summer, temporarily boost your buffer by 20-30% extra to handle the increased unpredictability.
What if I make wrong purchase forecasts?
Start conservative and adjust gradually based on real results. Better to reorder once weekly than toss expired products daily. Track where your forecasts miss the mark and refine your calculations over time.
📚 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 →