A bottle shop's beer keeps a thin margin: a local IPA 4-pack costs $11.60 from the distributor with the card fee and sells for $15.99, a 27.5% margin. Wine keeps more, 37.5%; cider sits between; cheese keeps more still; and tastings, a few pours and crackers for a fee, keep the most. Distributors set most prices, so the shop's margin comes from its mix: what it chooses to carry and what it adds beside the beer. Margin = (price − cost) ÷ price. In the example below, a month of five lines brings $37,778 of sales and about $13,010 of gross profit, before rent, wages and the coolers' power.
The short version
- Margin = (price − cost) ÷ price; markup = (price − cost) ÷ cost.
- A craft beer 4-pack: $11.60, sold for $15.99, 27.5%.
- Wine keeps more than beer.
- Cheese and tastings keep the most.
- The shop's margin comes from its mix.
- TaroStack keeps every bottle counted, with dates on fresh beer. More below.
A 4-pack, costed
Two Ravens Bottle Shop, the made-up bottle shop in Asheville, North Carolina, I use in these examples, counts wages as a fixed cost in its plan, so the costs below are what each item uses:
| A local IPA 4-pack | Cost |
|---|---|
| From the distributor | $11.20 |
| Card fees, 2% of $15.99 | $0.40 |
| Cost | $11.60 |
The shop's year is in bottle shop business plan, and a wine-only shop in wine shop business plan.
Margins by channel
| Product | Sold where | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Local IPA 4-pack | Shelf | $15.99 | $11.60 | $4.39 | 27.5% |
| Wine, a $20 bottle | Shelf | $19.99 | $12.50 | $7.49 | 37.5% |
| Hard cider 6-pack | Shelf | $13.99 | $9.75 | $4.24 | 30.3% |
| Cheese wedge | Case | $8.99 | $4.82 | $4.17 | 46.3% |
| Thursday tasting, per person | Tastings | $15.00 | $4.38 | $10.63 | 70.8% |
The cheese keeps 46.3%; the tasting keeps 70.8%.
A month's numbers
A month for Two Ravens Bottle Shop:
| Product | Units | Sales | Gross profit |
|---|---|---|---|
| Local IPA 4-pack, shelf | 1,000 | $15,990 | $4,390 |
| Wine, a $20 bottle, shelf | 700 | $13,993 | $5,243 |
| Hard cider 6-pack, shelf | 300 | $4,197 | $1,272 |
| Cheese wedge, case | 200 | $1,798 | $833 |
| Thursday tasting, per person, tastings | 120 | $1,800 | $1,275 |
| Month | $37,778 | $13,014 |
Wine brings the most gross profit on fewer sales than beer. The tastings sell 120 seats a month and keep the most of anything, and bring people who buy a 4-pack on the way out. Rent, wages and the coolers come out of the gross profit; a liquor store's numbers are in liquor store business plan.
Get the calculator
Download the bottle shop margin calculator. One sheet: one line for each product and channel, with its price, materials, packaging, labor and fee rate; the cost, gross profit, margin, markup and the price your target margin needs fill in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator holds one cost per item. Distributor prices change by the quarter, IPAs pass their best and go to a discount shelf, and the mix shifts with the season.
How TaroStack does it
TaroStack costs each 4-pack from what each batch used, so margins sit on real cost.
True cost from the batch. Each batch takes beer and wine from distributors at the price of the deliveries they came from, so a price rise shows in the next batch's cost.
Labor on the batch. The minutes a batch took are recorded on it, so the hours behind each product are on record.
Margins by product. Margins are reported per product on that actual cost, and a price-creep report per supplier shows whose prices moved.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What a 4-pack cost | One price from last season | Cost from the batch's deliveries |
| The hours behind a batch | Remembered | Labor minutes on the batch |
| An ingredient creeping up | Noticed late | A price-creep report |
| Margins by product | Re-worked by hand | Margins on real cost |
Recipes, batches, costing and margin reports are on every plan, from $49 a month. The first 30 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
