Profession Calculators
Hospitality & Food IndustryPopular

Bar Inventory and Pour Cost Calculator

Calculate liquor cost percentage, variance from target, and category-level pour cost analysis for spirits, beer, and wine using 2026 industry benchmarks of 18% to 24%.

Share:
Bar Inventory by Category

2026 industry benchmark: 18% to 24% for total beverage programs

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

What This Calculator Does

This bar inventory and pour cost calculator computes your liquor cost percentage (pour cost) by tracking opening inventory, purchases, closing inventory, and sales revenue across multiple beverage categories. It calculates cost of goods sold (COGS) for each category, measures variance from your target pour cost, and estimates potential savings from tighter inventory control. The calculator supports separate tracking for spirits, beer, wine, and custom categories, making it suitable for bars, restaurants, nightclubs, and hotel beverage programs.

The Formula

COGS = Opening Inventory + Purchases - Closing Inventory | Pour Cost % = (COGS / Sales Revenue) x 100 | Variance = Actual Pour Cost - Target Pour Cost

Pour cost measures the percentage of beverage revenue spent on the product itself. Opening inventory plus purchases represents all product available for sale during the period. Subtracting closing inventory gives the actual cost of goods consumed (sold, wasted, comped, or stolen). Dividing COGS by revenue and multiplying by 100 gives the pour cost percentage. The variance from target shows how far actual performance deviates from your goal.

Step-by-Step Example

1

Count opening inventory

Beginning of week spirits inventory valued at $5,000. Beer: $2,000. Wine: $3,000. Total: $10,000.

2

Record purchases

Weekly deliveries: spirits $2,500, beer $1,200, wine $800. Total purchases: $4,500.

3

Count closing inventory

End of week: spirits $4,800, beer $1,800, wine $2,900. Total: $9,500.

4

Calculate pour cost

COGS = $10,000 + $4,500 - $9,500 = $5,000. Revenue: $25,000. Pour cost = $5,000 / $25,000 = 20.0%. At a 20% target, variance is 0%.

Real-World Use Cases

Weekly Inventory Audits

Bar managers calculate pour cost weekly to detect overpouring, theft, waste, or pricing problems before they compound over months. A 1% pour cost increase on $25,000 weekly revenue is $250 per week or $13,000 per year.

Category Performance Tracking

Comparing pour cost across spirits, beer, and wine reveals which categories need attention. Spirits typically run 15% to 20%, while wine by the glass may run 25% to 35%.

Variance Investigation

When actual pour cost exceeds the theoretical cost (calculated from POS recipe data), the difference indicates losses from overpouring, spillage, comps not tracked, or theft.

Common Mistakes to Avoid

  • Not counting inventory at the same time each period. Inconsistent count timing creates false variances that mask real problems.

  • Forgetting to include all purchases including mid-week emergency orders, transfers from other locations, and direct-ship deliveries.

  • Mixing up cost and retail values. Inventory should be counted at cost (what you paid the distributor), not menu price.

  • Ignoring comps, spills, and staff drinks. These are legitimate costs that affect pour cost and should be tracked separately to distinguish them from theft or overpouring.

Frequently Asked Questions

Accuracy and Disclaimer

Pour cost benchmarks are industry averages based on 2026 data from hospitality industry sources. Actual targets vary by concept, location, and product mix. This calculator is for operational planning purposes. Consult a hospitality accountant for targets specific to your operation.