Bar Inventory and Beverage Cost: How to Calculate and Control It
How to count a bar in bottle portions, calculate beverage cost against sales, cost each cocktail and set menu prices from a target cost.
Beverage cost is simple arithmetic. What makes it hard is counting the bar the same way every time and knowing what each drink really costs.
Every bar manager is asked the same question at month end: how much did the beverages cost against what was sold? The formula is simple. The difficulty is the data behind it: counts done differently each time, recipes nobody wrote down, transfers between outlets that were never recorded.
Count in portions, not whole bottles
Open bottles are the hardest part of a bar count. Counting them as full or empty hides the real usage, so bars count in tenths of a bottle: 1.1 is one full bottle and a tenth of another, 1.5 is one and a half, 1.9 is almost two. Counting at the start and at the end of the shift, AM and PM, shows what was used during the day and catches differences while people still remember what happened.
The beverage cost formula
Beverage cost for a period is the cost of what was used divided by beverage sales. The cost of what was used is the opening inventory, plus purchases and transfers received, minus transfers sent and the closing inventory. Dividing it by the sales of the same period gives the beverage cost percentage. Doing it first in quantities, product by product, and then in money shows which products explain the difference.
Cost every cocktail
A cocktail's cost is the sum of its ingredients: the measure used multiplied by the cost per unit of that bottle, plus mixers and garnish. Writing recipes down with their measures is what makes the bar consistent and the cost knowable. Once the cost of each drink is known, the menu price follows from the target cost: the price at which the drink's cost is the percentage you decided.
Several outlets and events
Hotels and restaurants with several bars need each outlet to have its own inventory and its own beverage cost, with transfers between them logged. Events add another step: what left the storeroom minus what came back from banquets is what the event really used, and that is what should be compared with its sales.
Barventory
Barventory is the bar and beverage product of Nexora Technologies. It keeps inventory by outlet, AM and PM counts in 0.1 portions, a cost list loaded from Excel, PDF, a photo or a link, cocktail recipe costing, menu pricing from a target cost, Beverage Cost against sales and event control, with reports in PDF or Excel.