how to calculate liquor cost percentage

Mastering Alcohol Cost Calculation: A Comprehensive Guide

By Laura Lee
AD

Accurately calculating your liquor cost percentage is a critical step in ensuring the financial health of your bar or restaurant. It helps monitor profitability, set prices, and maintain sustainable operations. Let's delve into the process of calculating liquor cost percentage, exploring key factors and providing practical examples.

The liquor cost percentage is a key performance indicator in the hospitality industry, representing the cost of alcoholic beverages as a percentage of sales. It's calculated as (Cost of Goods Sold / Sales) x 100, and typically ranges between 18%-25% in bars and 20%-28% in restaurants. Now, let's break down the calculation into detailed steps.

Determine Your Cost of Goods Sold (COGS)

The first step in calculating liquor cost percentage is to determine your Cost of Goods Sold (COGS). This includes the initial cost of alcoholic beverages plus any applicable taxes, corkage fees, and bottling costs. It excludes depreciation, distribution costs, and other non-variable expenses.

AD
How to Take Inventory and Calculate Pour Cost - Jeffrey Morgenthaler
How to Take Inventory and Calculate Pour Cost - Jeffrey Morgenthaler
Bar Pour Cost Calculator & Drink Pricing Spreadsheet | Cocktail Cost for Excel + Google Sheets | Bar Menu Pricing and Profit Template
Bar Pour Cost Calculator & Drink Pricing Spreadsheet | Cocktail Cost for Excel + Google Sheets | Bar Menu Pricing and Profit Template
the drink calculator form is shown
the drink calculator form is shown

Let's assume you've purchased 10 cases of wine at $100 per case, with a total tax and corkage fee of $50. Your COGS for wine would be:

(10 cases x $100) + $50 = $1,500

How Much Alcohol Do You Need for your Party? | Free Calculator
How Much Alcohol Do You Need for your Party? | Free Calculator
the alcohol inventory chart for various types of bottles and cans, including $ 1 00 per gallon
the alcohol inventory chart for various types of bottles and cans, including $ 1 00 per gallon
the printable liquor inventory sheet
the printable liquor inventory sheet

Calculate Average COGS

To calculate your average COGS, divide your total COGS by the number of liquor sales. For example, if your total COGS is $30,000 and you've made 5,000 liquor sales, your average COGS would be:

$30,000 / 5,000 sales = $6 per sale

AD

Calculate Sales-Based COGS

Alternatively, you can calculate your COGS based on the sales price of your liquor. If you price your liquor based on a 30% markup, your sales price would be $10 for each $6 COGS. If you make 5,000 liquor sales, your total sales would be:

Cocktail Cost Calculator
Cocktail Cost Calculator
Cocktail Costing Calculator: Recipe Costs, Menu Pricing, Pour Cost and Profit Tracker
Cocktail Costing Calculator: Recipe Costs, Menu Pricing, Pour Cost and Profit Tracker
Wedding: alcohol calculator
Wedding: alcohol calculator
an info poster showing different types of bottles and glasses
an info poster showing different types of bottles and glasses
an iphone screen showing the pricing for different drinks and beverages on it's menu
an iphone screen showing the pricing for different drinks and beverages on it's menu
an info sheet showing the different types of food and drink options for each type of meal
an info sheet showing the different types of food and drink options for each type of meal

$10 x 5,000 sales = $50,000

Calculate Your Total Liquor Sales

Your total liquor sales include revenue from all alcoholic beverages, on-premises consumption, and takeouts. To calculate your liquor cost percentage, you'll need to find out the total liquor sales revenue over a specific period.

AD

Let's assume your total liquor sales revenue over a month is $50,000. Now, we can calculate your liquor cost percentage.

Calculate Liquor Cost Percentage

With your total COGS ($30,000, from our previous example) and total liquor sales ($50,000), you can calculate your liquor cost percentage as follows:

($30,000 / $50,000) x 100 = 60%

AD

In this example, your liquor cost percentage would be 60%. However, aiming for a lower liquor cost percentage is generally more profitable, with industry averages ranging from 18% to 28%.

Regularly recalculate your liquor cost percentage to ensure optimal profitability and sustainable operations. Aside from monitoring price changes and sales trends, consider negotiating better prices with suppliers, reducing waste, and optimizing your menu to improve your liquor cost percentage.

AD