A liquor store keeps about 27 cents of each dollar it sells, before rent and wages. Spirits, the biggest category, keep 24.0%. Wine keeps 32.0%, beer and seltzer 22.0%, and the small shelf of mixers, snacks and ice keeps 45.0%. In the made-up store below, a full-speed month sells $70,000, keeps $18,780, and after $15,950 of rent, wages and coolers has $2,830 left, before the owner's pay. That's 4 cents on the dollar. Customers know what a bottle of a national brand costs down the road, so the margin on each sale can't move much. What can move is how much cash sits on the shelves and how fast it turns. Below are the categories, the month, the break-even, and a calculator.
The short version
- Spirits keep 24.0% of each dollar, wine 32.0%, beer 22.0%.
- Mixers, snacks and ice keep 45.0%, on the smallest shelf in the store.
- A $70,000 month leaves $2,830 before the owner's pay.
- Fixed costs are $15,950 a month. Break-even is about $59,452 of sales.
- $140,000 sits on the shelves at cost. Beer turns eight times a year, spirits under four.
- TaroStack keeps the shelves counted and shows what they're worth. More below.
Where $100 goes
Each category's variable cost for $100 of sales: the bottles, card fees, and what breaks or goes missing.
| Of $100 sold | Goods, fees and shrink | Kept |
|---|---|---|
| Spirits | $76 | $24 |
| Wine | $68 | $32 |
| Beer and seltzer | $78 | $22 |
| Mixers, snacks and ice | $55 | $45 |
| Special orders and delivery | $72 | $28 |
A store can't set its own price on a bottle everyone recognizes. So the margin comes from the mix: the wine the owner chose, the tonic and limes beside the gin, the bag of ice. None of those is a reason to come in. All of them keep more than the bottle that was.
Margins by product
| Product | Sold | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Spirits | Shelves | $100.00 | $76.00 | $24.00 | 24.0% |
| Wine | Shelves | $100.00 | $68.00 | $32.00 | 32.0% |
| Beer and seltzer | Coolers | $100.00 | $78.00 | $22.00 | 22.0% |
| Mixers, snacks and ice | By the register | $100.00 | $55.00 | $45.00 | 45.0% |
| Special orders and delivery | By request | $100.00 | $72.00 | $28.00 | 28.0% |
The table is by $100 of sales, because a store carries thousands of bottles. Margin is half the picture. The other half is the cash each category ties up.
| Category | On the shelf, at cost | Turns a year | Earned a year on each $1 of stock |
|---|---|---|---|
| Spirits | $70,000 | 3.9 | $1.23 |
| Wine | $45,000 | 3.3 | $1.54 |
| Beer and seltzer | $20,000 | 8.0 | $2.24 |
| Mixers, snacks and ice | $5,000 | 5.3 | $4.32 |
Beer keeps the least on a sale and earns nearly twice what spirits earn on the money tied up in it, because it's gone in six weeks. Spirits hold half the store's cash. A bottle that sells once a year is a dollar earning 32 cents.
A month at full speed
| Product | Hundreds of dollars sold | Sales | Gross profit |
|---|---|---|---|
| Spirits, shelves | 300 | $30,000 | $7,200 |
| Wine, shelves | 180 | $18,000 | $5,760 |
| Beer and seltzer, coolers | 170 | $17,000 | $3,740 |
| Mixers, snacks and ice, by the register | 40 | $4,000 | $1,800 |
| Special orders and delivery, by request | 10 | $1,000 | $280 |
| Month | $70,000 | $18,780 | |
| Fixed costs | −$15,950 | ||
| Left | $2,830 |
Fixed costs are $15,950 every month: wages ($7,500), rent ($5,000), utilities and the coolers ($1,400), insurance with liquor liability ($800), the register and software ($300), security ($250), license renewals ($200), and other costs ($500).
Break-even
| Fixed costs a month | $15,950 |
| Gross profit on each dollar of sales | 27 cents |
| Sales needed to cover fixed costs | $59,452 |
| As a share of a full-speed month | 85% |
Below about $59,452 of sales a month the store loses money. In the plan this example comes from, that's reached in the seventh month, and the first year ends $2,772 behind before the owner's pay, on $288,000 put in to open.
What moves it
| Change | Effect on a month |
|---|---|
| Mixers, snacks and ice double | +$1,800 |
| Spirits prices cut 2 points to match a competitor | −$600 |
| Breakage and theft take another 1% of sales | −$700 |
| Wine sales up a fifth | +$1,152 |
The register shelf. Doubling mixers and ice adds +$1,800 a month and needs about $5,000 more stock. Nothing else in the store pays like that.
Shrink. One percent of sales is $700, a quarter of what the month leaves. A stolen bottle costs the profit on three more.
The first year, month by month, with what each category earns on its stock, is in liquor store business plan. A shop that sells only wine is in wine shop profit margin, and smaller stores in convenience store profit margin and general store profit margin.
Get the calculator
Download the liquor store profit margin calculator. One line for each product and where it sells: price, materials, packaging, labor and fees. It works out the cost, the gross profit, the margin and markup, and the price a target margin would need. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The table says spirits keep 24%. It doesn't say which $9,000 of that shelf hasn't sold a bottle since spring, or that the count is 30 bottles short of what the register thinks. The register knows what sold. It doesn't know what's sitting, and it doesn't know what left without being rung up.
How TaroStack does it
TaroStack keeps the shelves counted and shows what they're worth.
Counting on a phone, with no signal. A count shows what a variance is worth.
Stock value at cost, by site and by month, so the $140,000 is a number you can watch.
A reorder list in days of cover, with each distributor's lead time and minimum.
Every adjustment carries a reason: broken, missing, sampled. Shrink is a number.
A price-creep report by supplier shows a distributor's prices moving before the shelf tags are wrong.
| The job | Calculator | In TaroStack |
|---|---|---|
| What the shelves are worth | A count and a lookup | Stock value at cost |
| What to reorder | Walking the aisles | The reorder list |
| What broke or walked out | Unknown | Adjustments by reason |
| A distributor's prices creeping | Noticed at year end | The price-creep report |
TaroStack doesn't run the register or check IDs. It connects to Square. Stock, counts and reordering are on every plan. A store with a few thousand items fits Growth at $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
