How to Use Your Inventory Data Effectively

How to Use Your Inventory Data – A Guide for Hospitality Businesses

Carrying out an inventory is an obligation, yet the data it yields is a treasure that remains hidden to many hospitality operators. Particularly in restaurants and hospitality businesses, these figures provide valuable insights: calculating cost of goods, uncovering weak points, monitoring key metrics in the restaurant and making informed decisions. In this article, you will learn in practical terms how to analyse and use inventory data to improve processes, reduce costs, optimise your menu and work more profitably overall. We also show how digital solutions – such as inventory software for hospitality like BarBrain – help you evaluate and clearly visualise your inventory data.

Why Inventory Data Is So Important

An inventory records the current stock of your business. Whether you count monthly, quarterly or annually – after each stocktake you hold figures in your hands that are far more than a formality. Among other things, this data shows you:

• Goods consumption and cost of goods: How much stock was consumed in the period and at what value?
• Current stock levels: What supplies are still in the kitchen, cold room and cellar?
• Variances: Are there inventory discrepancies, e.g. shortages or surpluses compared to the target?

Without analysis, this information remains unused. Regular inventory evaluation in hospitality is the key to better cost control. Only those who know their stock levels and consumption can take targeted corrective action and avoid losses. In the next step, we look at how to derive key metrics from your inventory data.

Calculating and Understanding Cost of Goods

Cost of goods refers to the value of goods consumed in a given period (usually per month) – i.e. what the food and beverages you used actually cost you. Cost of goods is one of the most important metrics in restaurants, as it directly affects your profitability. To determine cost of goods, there is a simple formula:

Cost of goods = Opening stock + Purchases – Closing stock

This calculation yields goods consumption in euros. A brief example: if you had €7,000 worth of goods in stock at the start of the month, purchased €28,000 of new stock and had €9,000 remaining at month-end, your cost of goods is €26,000. If you generated €100,000 (net) in the same month, this equates to a cost-of-goods ratio of 26%.

Whether 26% is good or bad depends on the hospitality concept. For cost-of-goods ratios, benchmarks often apply: many businesses aim for under 30% of revenue, although 30–35% can also be typical depending on the concept. The important thing is that you track your own cost-of-goods ratio regularly and compare it against your calculations. If the ratio suddenly rises, that is a warning signal – it could indicate inefficiencies or higher costs.

Tip: Calculate cost of goods monthly. This way you spot trends or outliers quickly and can take action in good time. A monthly inventory provides the foundation for keeping costs in sight and discovering variances early.

Uncovering Shrinkage and Breakage (Recognising Invisible Losses)

Besides normal consumption, inventory data can also point to losses that go beyond cost of goods – namely shrinkage and breakage. These terms describe non-sold consumption:

• Shrinkage: Losses through theft, spoilage or incorrect portioning (i.e. everything that has “disappeared” without generating revenue).
• Breakage: Damaged goods, e.g. broken bottles or damaged containers.

Without inventory, shrinkage and breakage often go unnoticed. Shrinkage becomes visible by comparing the actual consumption according to the inventory with the theoretical consumption according to sales. The formula for this is:

Shrinkage = Actual consumption (per inventory) – Theoretical consumption (per POS)

And the shrinkage rate as a percentage is: (Shrinkage / Cost of goods) × 100. Industry figures show that approximately 3% shrinkage of cost of goods is still considered normal – anything above should be urgently investigated. DEHOGA (German Hotel and Restaurant Association) cites 3% as the industry benchmark. If your shrinkage rate is higher, something is going wrong.

Example: According to the POS, you sold 427 bottles of beer, but according to the inventory, 472 bottles were actually consumed – 45 bottles are unaccounted for. This equates to a shrinkage rate of approximately 9.5%. This figure is well above the benchmark and requires investigation: were bottles damaged? Was beer poured but not rung up? Or was there theft? This shows how inventory data helps uncover problems that would otherwise remain hidden.

Breakage should also be documented. Broken bottles or spoiled goods should be recorded, ideally directly during the inventory. The breakage rate (value of damaged goods relative to cost of goods) indicates how much such incidents cost you. If shrinkage or breakage is high, you can take countermeasures – for example improving warehouse organisation, training staff or introducing stricter controls.

Key Metrics from Inventory Analysis

By evaluating your inventory data, you obtain several key metrics that are critical for your restaurant:

• Cost of goods (€): Absolute goods consumption in euros per period (month, week).
• Cost-of-goods ratio (% of revenue): Ratio of cost of goods to net revenue. This ratio shows how much of your revenue goes on goods – the lower, the better for profit.
• Shrinkage volume and rate: Volume/value of unsold goods (shrinkage) and its share of cost of goods. Indicates how effectively you prevent losses. Shrinkage above ~3% is a warning signal.
• Breakage: Value of broken or disposed goods.
• Stock level: Total value of goods on hand. If your stock level rises or falls sharply, it affects liquidity. Excessive stock ties up capital; too little leads to shortages.
• Stock turnover: How often your stock “turns over”. Calculated from cost of goods and average stock level. Higher stock turnover means goods are sold quickly (which is good for freshness and reducing storage costs).

These key metrics for the restaurant help you steer your business. You can compare them month on month and also carry out benchmarking: how does your cost of goods compare with similar businesses? If your cost-of-goods ratio is significantly above the industry average (e.g. 35% vs. a typical 25%), you should look for optimisation potential. Such comparisons uncover weak points and show where action is needed.

Improving Processes with Inventory Data

Analysing inventory data means deriving specific measures to optimise processes. The figures show you where workflows are faltering or can be improved:

• Optimise purchasing: Are your order quantities right? If food is regularly thrown away, you are ordering too much. Adjust order rhythms and quantities to actual consumption. Conversely, you avoid shortages when inventory data shows that certain ingredients run out faster than expected.
• Improve warehousing: High losses from spoilage point to storage problems. Improve the warehouse structure – e.g. clear labelling, the FIFO principle (First In – First Out) and correct storage conditions so goods last longer. A tidy warehouse organisation reduces errors, shrinkage and breakage.
• Standardise portion sizes: If your cost of goods is unusually high, overly large portions could be the cause. Consistent recipes and portion control ensure that consumption does not exceed the calculation. This reduces consumption without sacrificing quality.
• Train staff: Ensure your team understands how important accurate stocktaking and careful use of resources are. Staff should report shrinkage (e.g. spilt drinks) and breakage immediately. A culture of transparency helps reduce hidden losses.
• Review sales processes: Comparing inventory and POS data shows whether everything consumed was also sold/recorded. If not, there may be a problem with the POS system or the service process (e.g. certain items being forgotten at the till). Training or system adjustments may be needed.

Through such improvements in warehouse, kitchen and service, your business runs more efficiently. Every process optimisation also pays off financially – less chaos and losses, more oversight and control.

Reducing Costs Through Inventory Analysis

One of the greatest benefits of consistent inventory analysis is saving costs. The key metrics make inefficiencies visible that burden your budget. Typical cost traps that you can expose through inventory data include:

• Overstocking and spoilage: Excessive stock levels often lead to goods spoiling and having to be written off – pure lost money. Inventory data helps you identify and reduce overstocking. This means more targeted purchasing in future and avoiding losses from spoiled food.
• Theft and undetected shrinkage: When inventory and sales do not match, you are losing goods often worth hundreds of euros. By knowing this gap (e.g. a 5% shrinkage rate), you can introduce measures against theft and shrinkage – such as restricted access to the warehouse, cameras or more precise dispensing controls. This pushes the shrinkage rate back towards the normal level (~3%) and saves real money.
• Unfavourable purchasing conditions: Perhaps your cost of goods shows that certain products are being purchased at excessively high prices. With the data in hand, you can specifically seek out more cost-effective suppliers or negotiate better terms. Volume discounts can also be used optimally when you know your exact requirements.
• Incorrectly costed dishes: If individual dishes cause an unusually high cost of goods, check the costing. You may need to adjust the selling price or change the recipe to achieve a reasonable margin again. Precise recipe data is needed for this, but the inventory provides the initial indication that something is wrong (e.g. when overall cost of goods rises without revenue keeping pace).
• Capital tied up in stock: A full warehouse ties up capital that you need for other expenditure. Through regular inventories, you know how much money is sitting in stock. The aim is a lean stock level that covers demand but does not block excessive capital.

Each of these points shows: inventory data directly helps reduce costs. By uncovering and systematically eliminating waste, your profit automatically increases. Many measures are simple: even reducing portion sizes or creatively using surpluses (e.g. developing daily specials from leftovers) can contribute significantly to lowering cost of goods.

Optimising Your Menu with Inventory Data

Your restaurant’s menu also benefits from inventory analysis. How? Inventory data reveals which ingredients were consumed in what quantities and at what cost proportion. Combined with sales figures for individual dishes, you can carry out menu engineering:

• Identify stars and dogs: Find out which dishes sell well (stars) and which are poor performers (dogs). If a dish is rarely ordered but requires expensive or highly perishable ingredients, it is a candidate for removal – it generates costs but barely any revenue.
• Check cost of goods per dish: Look at which dishes have a particularly high cost of goods (in € or %). Is this covered by a correspondingly higher price? If not, the costing is off. You may need to increase the price or use cheaper ingredients. Example: if a schnitzel costs €5 to produce and you want a 70% gross margin, you would need to sell it for ~€16.70. If your current price is below that, something is wrong.
• Ingredient and supplier selection: Inventory data shows which ingredients contribute most to cost of goods. Perhaps there are cheaper alternatives or seasonal products that are less expensive. Seasonal dishes can reduce cost of goods without compromising quality – though this requires periodically updating the menu.
• Shelf-stable vs. fresh goods: Analyse whether you frequently have to discard fresh ingredients because demand is unpredictable. It may be worthwhile designing the menu to use more longer-lasting ingredients and reserving perishable items only for dishes that are genuinely ordered often.

Through these optimisations, your menu becomes not only more profitable but also more consistent in quality. Ultimately, you carry only dishes that are worthwhile and popular, with less spoilage. Inventory data provides the factual basis for making such decisions objectively rather than relying on gut feeling.

Evaluating Digital Inventory Data – Efficient Rather Than Manual

Evaluating all these metrics and insights sounds laborious – and it is if you only work with pen, paper and spreadsheets. This is where evaluating digital inventory data comes in. Modern hospitality businesses rely on digital tools for inventory to minimise errors and automate evaluations.

Digital tools such as POS systems or inventory apps enormously simplify data capture. Through the integration of sales and stock, you receive real-time evaluations of cost of goods and stock metrics, enabling rapid response.

Benefits of digital inventory and inventory evaluation:

• Time savings during stocktaking: Apps like BarBrain allow all items to be entered directly via smartphone or tablet, often even by barcode scanning or automatic quantity capture. This is considerably faster than manual counting followed by Excel entry.
• Fewer errors, more reliable data: Digital systems calculate automatically and avoid transposed numbers or estimation errors. Reliable inventory results without manual input errors are the basis for correct evaluation. When, for example, opened bottles are precisely captured by weighing, the inventory value is accurate and you can rely on the key figures.
• Automatic calculation of key metrics: Good inventory software for hospitality takes the calculation off your hands. Cost of goods, cost-of-goods ratio, shrinkage or contribution margins can be available at the press of a button immediately after the inventory. You see instantly where you stand, without spending hours building reports.
• Clear visualisation: Digital solutions often present your inventory data in dashboard form – with charts, trend graphs and traffic-light indicators for key metrics. You recognise trends at a glance, e.g. if cost of goods has been steadily rising over the past three months or if stock value is unusually high. This visualisation makes the complex number crunching easily understandable for you and your team.
• Data available anytime, anywhere: Cloud-based tools allow evaluations to be accessed at any time – whether in the office or on the go. Particularly for owners of multiple branches, it is helpful to have all locations centrally in view.

In short: digital inventory solutions save time and deliver better data. This lays the groundwork for effortlessly carrying out the analyses and optimisations described in this article. An outstanding example is BarBrain, which we now present in more detail.

Inventory Software for Hospitality: BarBrain as a Solution

Among the many digital tools, we would like to highlight BarBrain.com as a specialised solution for hospitality inventories. BarBrain is inventory software for food & beverage that significantly simplifies the entire inventory process and data evaluation. What exactly does BarBrain offer?

• Fast, simple inventory: BarBrain is available as an app and allows multiple devices to count simultaneously – ideal when your team inventories different storage areas in parallel. This drastically shortens inventory duration. Every entry is made by tap or scan; even opened units are captured precisely.
• Comprehensive product catalogue: The system includes over 20,000 items from hospitality and hotels – from spirits and soft drinks to food and non-food consumables. You can count everything found in your operation without laboriously creating product data.
• Automatic inventory report: As soon as counting is complete, BarBrain generates an automatic, finished inventory report. All relevant figures are summarised – cost of goods, variances, stock levels, etc. Post-processing is eliminated; you have actionable results in hand immediately.
• Centralised evaluation and visualisation: BarBrain provides a comprehensive overview of your cost of goods and other key metrics, even across multiple locations. This means if you run two restaurants, for example, you can see the combined cost of goods at a glance and draw comparisons. Data is presented clearly in a dashboard (e.g. by product group, branch, time period).
• Real-time cost control: Thanks to precise, up-to-date figures, BarBrain lets you see immediately where you stand. High shrinkage rates or spiralling cost-of-goods ratios catch the eye, so you can react early.
• Time and cost savings: According to the provider, businesses using BarBrain save on average around 10 hours of inventory time per month and avoid errors, which can translate into savings of several thousand euros per year. This time gained can be invested in your core business – better guest satisfaction, marketing or new offerings.

Overall, BarBrain is a practical tool for evaluating digital inventory data and putting it into action. It is aimed precisely at industry professionals like you who want transparency over their figures without getting lost in complicated Excel evaluations.

Conclusion: From Inventory Data to Hospitality Success (Recommendation)

Inventory data is more than columns of numbers – it is the compass for your business success. When you know what your cost of goods is, where losses occur and which dishes are profitable, you can make informed decisions. Our practical overview showed how inventory evaluation optimises processes, reduces costs, improves your menu and thus helps you work more profitably.

The most important recommendation is: use your inventory data regularly and consistently. Ideally carry out monthly inventories and evaluate the results promptly. Set target values (e.g. cost-of-goods ratio below X%, shrinkage below Y%) and track progress. Even simple measures – from better order quantities to reformulating an expensive dish – can have a major impact when based on data.

To make your work easier, it is worth using digital inventory software. With tools like BarBrain, you can put your inventory data evaluation virtually on autopilot. The system delivers all the inventory evaluations for hospitality you need in a clear format, giving you the foundation to take the right steps. In the end: trust the numbers – they objectively show where your business stands and where you can make an impact. With this knowledge and the right tools like BarBrain at hand, you are well equipped to defuse cost traps, streamline processes and continue to offer your guests outstanding experiences – with solid profit for your business.