Inventory turnover in hospitality: formula, days of inventory and worked examples

The cellar is full, the bank account is empty. Plenty of venues know this combination: at the back there are twelve bottles of a rum hardly anyone has ordered since the summer, three cases of white wine from a promotion and syrups whose best-before dates are getting closer. At the same time, on Friday night you run out of exactly the gin everyone wants. This is where inventory turnover comes in. In a single number it shows you how often your stock is completely renewed over a year, and therefore how much money is sitting idle in your storeroom.

In this article you will learn how to calculate inventory turnover in hospitality, how to work out average stock and days of inventory, and how to analyse the metric by product group, area and outlet. All worked examples come from everyday bar and hotel operations.

1. What is inventory turnover?

Inventory turnover (also called stock turnover or turnover rate) describes how often your average stock is used up and replenished within a period. The usual reference period is one year. A value of 8 means your average stock has passed through the bar eight times in a year.

The metric is particularly meaningful in hospitality because three things come together: many goods are perishable or have a best-before date, the range is often broad (cocktail bars often carry several hundred items), and every euro tied up in stock is missing for staff, rent or investment. A low inventory turnover is therefore almost always a sign of tied-up capital and a higher risk of spoilage and shrinkage.

2. How to calculate inventory turnover: the formula

The basic formula is simple. You divide the cost of goods for a period by the average stock for the same period:

Inventory turnover = cost of goods ÷ average stock

It is important that both values use the same basis. Cost of goods is valued at purchase prices, not at selling prices, as the inventory turnover calculator by WHK Controlling (in German) also points out. If you divided sales by purchase values, the metric would be artificially inflated. In hospitality it also makes sense to work with net values, i.e. excluding VAT.

You calculate cost of goods itself with the familiar stocktake formula: opening stock plus goods received minus closing stock. How this works in detail and which pitfalls to avoid is explained in our article on calculating cost of goods.

3. Working out average stock correctly

The denominator of the formula determines the quality of your metric. There are two common approaches:

• Simple method: (opening stock + closing stock) ÷ 2. This is quick, but it assumes your stock develops evenly over the year.
• More accurate method: opening stock plus the twelve month-end stock values, divided by 13. This is also how the Wikipedia article on inventory turnover (in German) describes it. Seasonal fluctuations even out this way.

For hospitality businesses the second method is almost always the better choice. A beer garden, a ski hut or a hotel bar with a busy Christmas season has strongly fluctuating stock levels. If you only take the figures for 1 January and 31 December, you catch two reference dates that, depending on the season, lie well above or below the annual average, and distort inventory turnover in one direction or the other. The precondition for the more accurate method is a monthly stocktake. If you count every month anyway, you already have the twelve values.

Like cost of goods, stock is valued at net purchase prices. Count opened bottles proportionally, otherwise your stock is too low and inventory turnover looks better than it is.

4. Days of inventory and stock coverage

For many teams, inventory turnover on its own is abstract. It becomes more tangible when you convert it into days:

Average days of inventory = 365 ÷ inventory turnover

Classic business administration often uses 360 days. For a venue that is open seven days a week, 365 is the more honest basis. What matters is that you choose one variant and stick to it.

Days of inventory tell you how long a euro stays in stock on average before it comes back as a drink or dish sold. Closely related is stock coverage: it describes how many days your current stock will last at current consumption. Days of inventory look back, stock coverage looks ahead. Both help you plan realistic order quantities.

5. Worked example: a cocktail bar over one year

Take a cocktail bar with net bar cost of goods of €96,000 a year. The monthly stocktakes give an average stock of €12,000 net.

• Inventory turnover: €96,000 ÷ €12,000 = 8
• Average days of inventory: 365 ÷ 8 = around 46 days

So every euro the bar invests in goods sits on the shelf or in the cellar for about a month and a half. Suppose the team manages to reduce average stock to €8,000 through more disciplined ordering while cost of goods stays the same. Inventory turnover then rises to €96,000 ÷ €8,000 = 12, days of inventory fall to around 30, and €4,000 is freed up. At a cost of capital of 8% a year, that means €320 less in capital costs. On top of that come a lower risk of spoilage and less space needed for stock.

The calculation also works within the year: with €8,000 cost of goods per month and €12,000 average stock, monthly turnover is 0.67. Extrapolated to twelve months, that again gives 8.

6. Look at product groups separately

An overall value of 8 does not yet tell you where to start. Inventory turnover becomes interesting when you break it down by product group. For our example bar it looks like this (cost of goods and average stock per year, net):

• Draught beer: €18,000 ÷ €600 = 30 turns, around 12 days of inventory
• Spirits: €36,000 ÷ €6,200 = around 5.8 turns, around 63 days
• Wine and sparkling wine: €22,000 ÷ €4,400 = 5 turns, 73 days
• Soft drinks and mixers: €12,000 ÷ €600 = 20 turns, around 18 days
• Fruit and garnish: €8,000 ÷ €200 = 40 turns, around 9 days

The picture is clear: draught beer, mixers and fruit turn over quickly. Spirits together with wine and sparkling wine tie up €10,600 of the €12,000 average stock. That is where the levers are. If the bar reduced average spirits stock to €3,600 and wine stock to €3,000, that would be exactly the €4,000 from the example above. Spirits would then reach 10 turns and wine around 7.3.

There is no universal target value. General controlling guides such as the one linked above tend to view values below about 4 to 5 a year critically, while stressing that the assessment depends heavily on the industry and business model. A bar with a large whisky selection will always turn over more slowly than a pub serving draught beer. What matters is the comparison with yourself: month by month, product group by product group.

7. How to increase inventory turnover: six practical levers

Inventory turnover rises when you hold less stock for the same cost of goods. These levers have proven themselves in practice:

• Set minimum and reorder levels: instead of ordering by gut feeling, you define for each item when to reorder. How to derive the values properly is explained in our article on calculating minimum stock.
• Adjust your ordering rhythm: ordering smaller quantities more often lowers average stock. This pays off especially for product groups with a high stock value, as long as the delivery terms allow it.
• Weed out slow movers: items that are hardly used over several months should be reviewed. A smaller selection of premium spirits is often enough without guests missing anything.
• Check promotional stock critically: volume discounts only pay off if the goods sell quickly enough. Three cases of wine sitting in the cellar for six months eat up the discount through tied-up capital.
• First in, first out: older goods to the front, new deliveries to the back. This prevents stock from ageing unnoticed and ending up written off as spoilage.
• Record every goods receipt: every delivery has to reach the system. If a delivery note is missing, cost of goods is wrong, and so is inventory turnover.

The last point in particular is often underestimated. Delivery notes that are recorded days later or not at all distort every stock metric. Our article on goods receipt inspection describes how to check incoming goods in a structured way. To make sure booking does not fail because of manual typing, digital capture helps.

With the BarBrain AI delivery note scanner you take a photo of the delivery note or invoice. The AI reads items, quantities, pack sizes and purchase prices, you check the line items and book the goods receipt with one click. Your stock is then up to date immediately, and the next stocktake starts with correct figures.

8. Compare areas and outlets

In larger businesses, stock is spread across several storage locations: main bar, cellar, cold room, and in hotels also restaurant, banqueting, breakfast buffet or minibar. Here it is worth looking first at the stock value per area. It shows you where your capital physically sits. A cellar that permanently holds more than half of the stock value is a strong signal that slow movers are stored there.

If you run several outlets, such as a hotel bar and a banqueting operation, you calculate inventory turnover separately for each outlet. An example:

• Hotel bar: €80,000 cost of goods ÷ €8,000 average stock = 10 turns, around 37 days of inventory
• Banqueting: €27,000 cost of goods ÷ €9,000 average stock = 3 turns, around 122 days of inventory

Banqueting holds more stock than the hotel bar, even though it has only a third of the cost of goods. Typical causes are safety stock for large events that is never used, or leftover quantities after events that are not passed on to other outlets. You can only spot such differences if every outlet has its own clean figures and you put them side by side instead of lumping everything into one total.

9. Capture the figures for inventory turnover with BarBrain

For inventory turnover you need two things in good quality: regular stock values and complete cost of goods. In BarBrain both are created as part of your normal workflow.

With digital stocktaking your team counts area by area via the app, on a smartphone, tablet or in the browser, including opened bottles with a slider. Several team members count in parallel in their areas. Once you close the stocktake, you get a stock list with the stock value per area and can export it as an Excel file with one click. The product catalogue with more than 30,000 items speeds up setting up your range. Together with the booked goods receipts, actual consumption is opening stock plus goods received minus closing stock. This gives you both building blocks for your metric every month.

For groups and hotels: every outlet works as its own account with its own areas. The admin overview lets you keep several accounts in view and compare your outlets side by side. Each outlet keeps its own reliable data basis.

Want to see what this looks like in your venue? Book a demo and walk through with our team how to bring stock, goods receipts and metrics together in one place.

10. Frequently asked questions