How to Calculate Bar Margin in a Gaming Club

How to Calculate Bar Margin in a Gaming Club

The bar is the highest-margin channel in a club: almost no variable costs beyond product cost. Yet most clubs don’t track bar margin systematically — and lose money on mispriced items.

Here’s the calculation methodology using IZI.

Before You Start

• Cost prices filled in for all product cards (Catalog)
• At least 30 days of sales data accumulated

If cost prices aren’t filled in, IZI can’t calculate margin automatically. How to add bar products with correct cost prices.

Step 1 — Open Bar Analytics

Analytics → Bar tab. This shows bar revenue, order count, and average check for the selected period.

Set the period to the last 30 days.

Step 2 — Calculate Gross Bar Margin

Formula:

Bar margin = (Bar revenue — Cost of goods sold) / Bar revenue × 100%

Cost of goods sold = sum of purchase prices of all items sold in the period. IZI calculates this automatically when cost prices are filled in product cards.

Illustrative example:

• Bar revenue for 30 days = 50,000
• Cost of goods = 18,000
• Margin = (50,000 — 18,000) / 50,000 × 100% = 64%

Step 3 — Calculate Margin per Item

Go to Catalog → product list. For each item:

Item margin = (Sale price — Cost price) / Sale price × 100%

Sort by margin — you’ll immediately see what’s generating profit and what’s dragging it down.

Red flags:

• Margin < 40% — price is likely too low or cost too high
• Negative margin — selling at a loss (usually a data entry error or price not updated after cost increase)

Step 4 — Calculate Bar Share in Total Revenue

Bar share = Bar revenue / Total club revenue × 100%

Get total revenue from Analytics → Sessions for the same period.

If bar share is below 10%, there’s growth potential. Tools: loyalty tiers with bar purchase bonuses, combo offers.

Step 5 — Identify Problem Items

In the Catalog or through the sales report, find:

1. High-margin items with low sales — promote these more actively
2. Low-margin items with high sales — reprice or remove
3. Items with zero cost price — data missing, margin calculated incorrectly

Tracking Over Time

Check bar margin monthly. If:

• Margin dropped — check whether purchase prices changed (update cost in product cards)
• Bar share declined — check shift coverage, look for gaps in order logging
• Warehouse discrepancy — more items written off than sold, potential shift discrepancy

Related Guides

• How to Add Bar Products
• How to Reduce Shift Discrepancy
• How to Calculate Bar Share

---

FAQ

Where do I find bar revenue in IZI? Analytics → Bar tab. Revenue, order count, and average check for the selected period.

How do I calculate margin for a specific item? Item margin = (sale price — cost price) / sale price × 100%. Cost price is in the item card in Catalog.

What bar margin should I target? Depends on your cost structure: perishable food — 60%+ minimum, beverages — 70%+. What matters is the trend, not a single number.

Why does bar share in revenue matter? Bar is your highest-margin channel. If share is below 10–15% of total revenue, potential is untapped.

How do I find unprofitable bar items? Sort items in Catalog by margin. Zero or negative margin items need repricing or removal.