Calculating minimum stock: formula, benchmarks and worked examples for bars and hospitality

There are 12 bottles of gin in the storeroom. That looks like a lot. But it’s Thursday evening, the weekend rush starts in 26 hours, and your supplier’s order cut-off is in two hours. Are 12 bottles enough? Or will you be left without a gin and tonic at 10 pm on Saturday? Very few operators know the honest answer. They order by feel – and pay for it twice over: through excessive stock that ties up capital and spoils. Or through empty shelves that cost revenue on Friday night.

Minimum stock is the figure that solves this problem. It is not gut feeling but a mathematically defined limit: the point below which your stock must not fall so that you can keep selling until the next delivery. This article shows you the formula, the concrete figures for beer, spirits and wine, and the mistakes that cost you four-figure sums every month.

What is minimum stock?

Minimum stock – also called iron reserve, safety reserve or, in e-commerce, safety stock – is the quantity of an item that you must keep in stock at all times to absorb supply bottlenecks, demand peaks and delays. It sits below your running stock level but above zero. If stock falls to this limit, you must order. Minimum stock is not the point at which you order – that is the reorder point. And it is not the average stock level either. It is the buffer for the worst case: late delivery, a sudden rush, a supplier dropping out.

In hospitality this is not a theoretical metric. A bar that runs out of prosecco on Saturday night loses double-digit sums in revenue per hour – and some of its regulars. A restaurant that has no rosé on Mother’s Day writes “unfortunately sold out” on the wine list and loses the guest’s trust. Minimum stock prevents exactly that.

The formula for minimum stock

The classic formula comes from business economics and applies across industries:

Minimum stock = daily consumption × minimum stock days

Where:

• Daily consumption = average sales per day (in units)
• Minimum stock days = the period you want to be covered for – typically the replenishment time plus a safety margin

Alternatively, some textbooks use the following extended formula:

Minimum stock = (daily consumption × delivery time in days) + safety margin

Both variants give the same result – the second just makes the safety margin more explicit. For hospitality the extended form is more precise, because you manage replenishment and buffer separately.

The three parameters that decide everything

Many operators underestimate how sensitive the result is to the input values. An error in delivery time of two days instead of one quickly adds an extra crate for a strong-selling product. The following overview shows what lies behind each parameter:

Minimum stock, reorder point, maximum stock – the three limits

In practice, experienced operators don’t work with just one stock limit but with three. Each has its own function:

• Minimum stock (lower limit): The iron reserve. You must not fall below it.
• Reorder point (order trigger): Sits above minimum stock. When stock reaches this point, you order – so that the delivery arrives before you reach minimum stock.
• Maximum stock (upper limit): The maximum sensible stock level. Above it, you tie up capital, risk spoilage or run into space problems.

The formula for the reorder point is: Reorder point = minimum stock + (daily consumption × delivery time). In other words: you order so that by the time the delivery arrives you have used up exactly down to minimum stock. The storeroom is then refilled before the iron reserve is touched.

Why this three-way split is particularly important in hospitality: your suppliers have fixed delivery rounds. You can’t always reorder immediately – you have to catch the next regular delivery day. If you only work with minimum stock, you regularly end up short just before the weekend.

Calculating minimum stock: step by step

The formula is simple – the decisive part is the data basis. Here is the process as it works in a bar or restaurant:

1. Select items: Don’t start with 400 SKUs. Start with your ABC class A products – the top 20 that make up 80% of your revenue.
2. Pull consumption data: Export sales for the last 4–8 weeks from the POS. Adjust accordingly for strong seasonality – don’t use January figures for July stock.
3. Calculate daily consumption: Total sales ÷ number of days in the period under review. For fluctuating products, use the average of the five highest-revenue days.
4. Determine delivery time: Don’t ask, measure. When do you usually place the order? When does the delivery actually arrive? The answer is usually between 1 and 5 days.
5. Set the safety margin: For standard products with reliable suppliers: 30%. For premium products with long delivery times or imported items: 50–100%.
6. Apply the formula: Daily consumption × (delivery time + safety days). The result is your minimum stock in units.
7. Integrate it into your process: Store the minimum stock in your inventory management or stock list. Trigger an order alert when stock falls below it.

3 worked examples

Example 1: draught lager (city pub)

A pub sells an average of 80 glasses of lager per day (0.3 l). That corresponds to 24 litres of daily consumption, or about 0.48 kegs of 50 l. The brewery delivers on Monday and Thursday. The order must go out 24 hours in advance each time. In worst-case scenarios, the actual replenishment time is therefore up to 4 days (order on Sunday evening, delivery early Thursday).

Interpretation: If stock falls to 3 kegs, the order is already overdue. The reorder point would be: 3 + (0.48 × 4) ≈ 5 kegs. With 5 kegs remaining, you order.

Example 2: premium gin (cocktail bar)

A cocktail bar pours a particular premium gin in 8 cocktails per day at 5 cl each – so 40 cl or 0.4 l daily. That is 0.4 bottles per day (with 1-litre bottles). The wholesaler delivers twice a week with a replenishment time of 2 days. For premium spirits the bar calculates generously, because supply bottlenecks for individual brands occur regularly.

Interpretation: A minimum stock of 2 bottles looks small. But with 15 premium spirits in the range, these seemingly small stocks quickly add up to 30+ bottles of tied-up capital. That is exactly why it pays to calculate item by item.

Example 3: limes (cocktail bar) – the freshness problem

A cocktail bar uses 60 limes per evening at weekends and 25 during the week. Weighted daily average: approx. 35 limes. The supplier comes three times a week (Mon, Wed, Fri). Worst-case delivery time: 3 days (order on Saturday, delivery on Tuesday – because Monday is not a delivery day after the weekend). In addition: limes stay fresh for 7–10 days at most. The safety margin must therefore NOT be more than 2 days, otherwise the produce becomes unusable.

Result: Minimum stock = 35 × (3 + 2) = 175 limes. That corresponds to about 4 crates of 45 each. With 175 limes in stock you must order – and at the same time stock should never rise significantly above 250 limes, otherwise spoilage and shrinkage loom. More on this in the guide to shrinkage and breakage.

The lesson from this example: for perishable goods, minimum stock is not just a lower limit but must always be considered in the context of maximum stock. For fresh produce, tight corridor management with more frequent, smaller deliveries is almost always more profitable than large buffer stocks.

Benchmarks: safety margins by product group

The safety margin is the parameter with the greatest leverage – and the greatest uncertainty. The following benchmarks come from hospitality practice and serve as a guide. They need to be adapted to your venue:

*For fresh produce, the safety margin must not exceed the shelf life (best-before range).

The pragmatic principle: the more critical the product group is for your revenue, the higher the safety margin. Your signature whisky accounting for 20% of your spirits revenue justifies a 100% margin. The third-ranked syrup in a rarely ordered cocktail needs more like 30%.

5 costly mistakes when calculating minimum stock

1. Estimating daily consumption by feel: “We sell about 40 drinks a day” is not a figure. It’s 38 or 52 – and the difference decides whether you sell out at the weekend or not. The basis is always real POS data.
2. Ignoring seasonality: If you use the annual average, you calculate with winter figures in summer and vice versa. Recommendation: adjust minimum stock seasonally, or at least use rolling 4-week averages.
3. Underestimating delivery time: The supplier’s 24-hour delivery promise often means 2–3 days in reality when a public holiday, a sickness-related absence or the weekend gets in the way. Calculate with worst-case values, not marketing promises.
4. No distinction between A, B and C items: If you treat all 400 items the same, you lose focus. A items (top 20% by revenue) need precise minimum stock levels. For C items, a blanket rule is enough.
5. Calculated once – never updated: The biggest mistake. Consumption, suppliers and prices change. A minimum stock level from 2023 is often too high in 2026 (product declining) or too low (product on the rise). Recommendation: review quarterly.

What minimum stock has to do with cost of goods and liquidity

Minimum stock is not just a service question but a financial one. Every bottle, every keg, every pallet of goods in the storeroom ties up capital. In hospitality, with its thin margins, tied-up capital is expensive.

Do the maths: a venue with 200 different items and an average minimum stock of €150 per item permanently holds €30,000 as an iron reserve. At a financing rate of 8%, that corresponds to €2,400 in capital costs per year – just for the minimum stock. If you optimise these stocks by 20%, you directly save €480 in interest costs and also reduce the risk of spoilage and shrinkage.

The link to cost of goods is direct: excessive minimum stock leads to more spoilage and thus a higher cost-of-goods percentage. Too little minimum stock leads to ordering stress, express deliveries at premium prices and lost revenue – which also drive cost of goods up. The optimal minimum stock is the sweet spot between ability to supply and capital efficiency.

Automating minimum stock with software

Calculating the formula manually for 200 items every month is impractical. That is why minimum stock management in hospitality without software is inaccurate at best and a waste of time at worst. Three features make the difference:

1. Automatic consumption calculation: The software pulls the POS data, calculates rolling daily consumption and updates minimum stock levels when behaviour shifts. Without manual input.
2. Real-time order alerts: If stock falls below the reorder point, the team gets a notification – with a suggested order quantity up to maximum stock. The decision is reduced to “order yes/no”.
3. Integration with stocktaking: A monthly stocktake corrects actual stock against target stock. The software learns from variances and readjusts safety margins itself.

The result: minimum stock changes from a static value to a living parameter that adapts to the venue. The basis for this is reliable actual stock: with stocktaking software such as BarBrain, you count regularly and quickly and check your minimum stock levels against current figures.

Frequently asked questions about minimum stock

What is the formula for minimum stock?

Minimum stock = daily consumption × (delivery time in days + safety days). Alternatively: daily consumption × minimum stock days. Both variants give the same result – the first separates replenishment and buffer, which is more practical in hospitality.

What is the difference between minimum stock and the reorder point?

Minimum stock is the lower limit that must not be undercut (iron reserve). The reorder point is the point at which you must order – it is higher, so that the delivery arrives before minimum stock is reached. Formula: reorder point = minimum stock + (daily consumption × delivery time).

How high should minimum stock be in hospitality?

That depends on daily consumption, delivery time and safety margin. Rule of thumb: with reliable suppliers, a 30% safety margin is enough. For premium or imported goods, 50–100%. You’ll find concrete worked examples for beer, gin and limes further up in this article.

What is the iron reserve?

Iron reserve is a synonym for minimum stock. It refers to the quantity that must always be in the storeroom to cushion delivery delays and demand peaks. In business economics, the term safety stock is also used.

How do I calculate minimum stock for perishable goods?

For fresh produce (limes, herbs, meat): the safety margin must never exceed the shelf life. A 20–40% margin is usually enough. Instead, you should order more often (daily delivery or 3× a week) rather than holding large buffers. This reduces spoilage and tied-up capital at the same time.

Can I calculate minimum stock in Excel?

Yes, easily for individual items. Columns: item, daily consumption, delivery time, safety margin, minimum stock (=Column2*(Column3+Column4)). That works for 10 items. From 50 items with changing consumption it becomes confusing – then stocktaking and inventory management software is worthwhile.

How often do I need to update minimum stock?

At least quarterly. For seasonal venues (beer garden, ski hut, beach bar) before every season. Software solutions update continuously based on rolling consumption data – that is the gold standard.

What happens if minimum stock is too high?

Tied-up capital, higher risk of spoilage, more storage space needed, older goods in the range. For a range of 200 items, 20% overcapacity in minimum stock quickly means several thousand euros a year of unnecessarily tied-up capital.

What happens if minimum stock is too low?

Risk of selling out, lost revenue, express orders at premium prices, frustrated customers. A single sold-out evening for a top seller usually costs more than a year’s worth of additional stockholding.

Conclusion: from gut feeling to metric

Minimum stock is the bridge between service promise and profitability. If you know it and maintain it, you avoid selling out without tying up capital unnecessarily. The formula is simple. The real effort lies in data quality: honest POS figures, realistic delivery times and a safety margin that suits the product group.

Once you run the calculation for your top 20 items, you’ll find that current stock is too high for part of the range and too low for other items. The optimisation alone pays for itself within months. And once the system is running – with clean stock figures from regular stocktakes, whether in Excel or with stocktaking software such as BarBrain – ordering goes from a source of stress to routine. Minimum stock turns a gut decision into a metric. That is exactly what it is for.