A cocktail bar quickly ends up with several hundred items: spirits, wines, beers, soft drinks, syrups, fruit, coffee, snacks and consumables. Nobody manages to count, renegotiate and monitor all of them with the same care in day-to-day operations. The ABC analysis helps you set priorities: it shows which few items account for most of your cost of goods and where control therefore pays off most.
In this guide you will learn how the ABC analysis works, which figure to use as its basis in hospitality and how to calculate it step by step. A worked example with 20 items from a bar shows what the result looks like and what it means for stocktaking, purchasing and storage.
1. What is the ABC analysis?
The ABC analysis is a method for sorting items into three classes according to their economic importance. A items have a high share of the total value, B items a medium share and C items a low share. According to Wikipedia, the method was described for inventory management in 1951 by H. Ford Dickie, a manager at General Electric. It builds on the work of Vilfredo Pareto, known as the 80/20 rule.
The idea behind it: a small share of the items makes up a large share of the value. A common split is 80%, 15% and 5% of the cumulative value, as the Lexware business glossary describes. The thresholds are not prescribed, though. You set them for your business and then stick to them so that the results stay comparable. According to Wikipedia (German), the ideal 80/20 distribution is rarely reached exactly in practice, as our example below also shows.
2. Why the ABC analysis pays off in hospitality
In bars, restaurants and hotels, there is little time for control. The stocktake often happens after closing or early in the morning, purchasing runs alongside everything else, and expensive spirits sit next to straws in the storeroom. The ABC analysis makes sure you focus your attention where it pays off in euros:
- Stocktaking: you count A items more often and more carefully; for C items the regular monthly stocktake is enough.
- Purchasing: for A items it is worth checking every price change and negotiating terms.
- Storage: you store A items securely with fixed minimum stock levels, while C items are ordered in larger quantities with simple rules.
- Shrinkage: a discrepancy of a few bottles of an A item often costs more than a C item that has disappeared completely.
Especially in businesses with many items, that is the difference between “a bit of everything” and “the important things done properly”. How the stocktake itself works is described in our hospitality stocktaking guide.
3. Which figure is the right basis?
Before you calculate, decide what you sort by. For hospitality businesses, three figures are the main options:
- Usage value: quantity used times net purchase price over a period. It shows where your money is tied up in stock and is the best basis for stocktaking, purchasing and storage.
- Stock value: counted quantity times net purchase price on the reporting date. It shows where capital is tied up in storage but says nothing about how quickly an item turns over.
- Revenue or contribution margin: these figures suit the analysis of your menu, i.e. which drinks and dishes are worthwhile. That is the domain of menu engineering.
In this article we work with the usage value. You calculate the usage per item from the stocktake and goods receipt:
Actual usage = opening stock + goods receipt − closing stock
An example: at the start of the month there are 10 bottles of gin in storage, 36 bottles arrive during the month, and at the end of the month you count 8 bottles. Actual usage is 38 bottles. At a net purchase price of 18.00 € per bottle, that gives a usage value of 684.00 €. It is important to use net purchase prices throughout. Gross prices or outdated price lists distort the result.
4. Calculating the ABC analysis step by step
A simple spreadsheet is all you need once the stocktake and goods receipt data are available. Here is how to proceed:
- Set the period: take at least one full month, ideally the month between two stocktakes. A single weekend with an event distorts the picture.
- Determine usage: calculate the actual usage for each item from opening stock, goods receipt and closing stock.
- Value it: multiply usage by the current net purchase price. This gives you the usage value per item.
- Sort and accumulate: sort all items in descending order of usage value. Calculate each item's share of the total value and add up the shares from top to bottom.
- Assign classes: all items up to a cumulative share of 80% are A items, up to 95% B items, and the rest C items.
An item's share is calculated as follows: the item's usage value divided by the total usage value, times 100. The cumulative share is the sum of the shares of all items above it in the sorted list, plus its own share. To start with, a simple spreadsheet with the columns item, usage, price, usage value, share and cumulative share is all you need.
5. Worked example: ABC analysis for a bar
A bar analyses one month with 20 items. The total usage value at net purchase prices is 4,464.90 €. Sorted by usage value, the six most valuable items look like this:
- Draught lager 50 l: 9 kegs × 95.00 € = 855.00 € (19.1%, cumulative 19.1%)
- London Dry Gin 0.7 l: 38 bottles × 18.00 € = 684.00 € (15.3%, cumulative 34.5%)
- Prosecco 0.75 l: 120 bottles × 5.20 € = 624.00 € (14.0%, cumulative 48.4%)
- Aperitif liqueur 1.0 l: 30 bottles × 15.00 € = 450.00 € (10.1%, cumulative 58.5%)
- Tonic water 0.2 l: 480 bottles × 0.80 € = 384.00 € (8.6%, cumulative 67.1%)
- House white wine 0.75 l: 60 bottles × 4.90 € = 294.00 € (6.6%, cumulative 73.7%)
With the seventh item, vodka 0.7 l (20 bottles × 14.50 € = 290.00 €), the cumulative share rises to 80.2% and thus exceeds the 80% threshold. Vodka is therefore the first B item. It is followed by coffee beans (216.00 €), mineral water (165.00 €), limes (95.00 €), bitter liqueur (88.00 €) and white rum (78.00 €), bringing the cumulative share to 94.6%. The remaining eight items, from orange juice (76.00 €) through sugar syrup, cream, peanuts, cocktail cherries, mint and paper straws to chilli sauce (6.80 €), form the C class.
The result at a glance:
- A items: 6 of 20 items (30%) with 3,291.00 €, which is 73.7% of the usage value.
- B items: 6 items (30%) with 932.00 €, which is 20.9%.
- C items: 8 items (40%) with 241.90 €, which is 5.4%.
Two things stand out. First, the bar does not reach the ideal 80/20 distribution: 30% of the items account for just under three quarters of the value. That is typical; the Pareto rule is a guideline, not a law of nature. Second, it is not the bottle price that decides the class but price times quantity. Tonic water costs only 0.80 € per bottle but ends up in the A class because of the high volume. At 22.00 €, the bitter liqueur is the most expensive bottle on the list, but it is hardly used and is only a B item.
6. How to use the results for stocktaking, purchasing and storage
The classes are not an end in themselves. Their value only comes when you set different rules for each class. A proven basic pattern:
A items get the most attention. In addition to the monthly stocktake, recount them at short intervals, for example weekly. Check on every delivery whether quantity and price are correct, and negotiate terms with your suppliers. Set a minimum stock level for them that is close to actual usage, so that neither capital is tied up nor the gin runs out on a Saturday night. Our guide to calculating minimum stock shows how. Expensive A items such as spirits also belong in a lockable area with controlled issuing.
B items run through the standard process: counted in the monthly stocktake, regular price checks, normal order cycles. Here it is worth checking occasionally whether an item is moving up into the A class, for example because a new signature drink suddenly drives demand.
C items are managed with little effort. Count them in the monthly stocktake, order in larger quantities and work with a simple rule such as “reorder when the last pack is opened”. Every minute you save here can go into the A items.
The same logic applies to shrinkage. Check discrepancies between target and actual usage for the A items first. In the example, a difference of two bottles of gin costs 36.00 €, while the entire monthly usage of paper straws comes to just 13.00 €.
7. ABC-XYZ analysis: factoring in fluctuations in usage
The ABC analysis tells you how important an item is, but not how well you can plan its demand. That is what the XYZ analysis is for. It classifies items by their usage pattern: X items have constant usage, Y items are subject to seasonal fluctuations, and Z items show irregular usage patterns that are hard to predict. This is how the Lexware business glossary describes it, and it also recommends combining it with the ABC analysis.
Applied to the bar in the example, it could look like this:
- AX: tonic water with steady sales throughout the year, because it goes into many long drinks. You can plan it tightly and work with fixed order cycles.
- AY: Prosecco, which sells much more strongly in summer and around New Year's Eve. Here you adjust minimum stock and order quantities to the season.
- AZ: an A item that is needed mainly for individual events. You order such items as close to demand as possible instead of keeping them in stock permanently.
- CX: paper straws with steady usage. Ideal for large order quantities and simple rules.
How to derive the right order quantity for your A items from usage, ordering costs and storage costs is explained in our article on the optimal order quantity.
8. Common mistakes in the ABC analysis
- Gross instead of net prices: calculating with prices including VAT inflates the values. Always use net purchase prices.
- Outdated purchase prices: if a supplier has raised the price, the usage value changes. Without current prices, an item may end up in the wrong class.
- Too short a period: one week with a wedding party briefly turns sparkling wine into an A item. Analyse at least one month.
- Calculate once and forget: menus, seasons and prices change. Repeat the analysis regularly, at least once per season.
- Lumping everything together: in hotels with a hotel bar, restaurant and banqueting, or in groups with several outlets, the ranges differ greatly. Run the analysis per area or per outlet, otherwise the large areas hide the specifics of the small ones.
- Overlooking qualitative factors: the ABC analysis only looks at values, which Wikipedia also names as a weakness. In the example, limes are only a B item, but without them there is no gin and tonic. Items that key drinks cannot do without still need a safe minimum stock.
9. ABC analysis with BarBrain
An ABC analysis is only as good as the data behind it: reliable stock levels, complete goods receipts and current purchase prices. This is exactly where BarBrain comes in.
With digital stocktaking, your team counts in the app, even in parallel in several areas such as the bar, cellar or cold store. Opened bottles are recorded with a slider. After closing, BarBrain automatically creates a stock list with quantities and stock values, grouped by area, which you can export and process further in your spreadsheet. The product catalogue with more than 30,000 items already includes pack sizes.
The AI delivery note and invoice scanner recognises items, quantities, pack sizes and purchase prices from a photo or upload. You see changed purchase prices directly during the scan; after checking, you book the goods receipt with one click and the stock is up to date immediately. In the example above, the scanner recognises 12 bottles of gin, 36 bottles of Prosecco and 96 bottles of tonic water on one delivery note, three A items from the calculation. That gives you all the building blocks for actual usage: opening stock, goods receipt and closing stock, valued at current prices.
For hotels and groups: every outlet is a separate account with its own areas, and stocktakes run separately. In the admin overview you see the stocktake results and the stock value per outlet as soon as they are completed. This lets you run the ABC analysis per outlet based on its own stock list and see which items tie up the most value there.
Want to see how your stocktake becomes a reliable basis for the ABC analysis? Book a demo


.jpeg)



