A wine shop keeps about 34 cents of each dollar it sells, before rent and wages. A bottle off the shelf keeps 34.0%. A mixed case at 10% off keeps 27.0%. The wine club keeps 38.0%, and tastings and classes keep 65.0%. In the made-up shop below, a full-speed month sells $50,000, keeps $17,240, and after $14,350 of rent, wages and the rest has $2,890 left, before the owner's pay. The margin is about the same on a $13 bottle and an $85 one. What differs is how long each sits. Below are the six lines, the price tiers, the month, the break-even, and a calculator.
The short version
- A bottle keeps 34.0% of its price. A mixed case at 10% off keeps 27.0%.
- The wine club keeps 38.0%, and it's sold before it's bought.
- Tastings keep 65.0%, and bring people in on slow nights.
- Under-$15 wine earns $3.01 a year on each $1 of shelf. Over-$60 earns $0.34.
- Fixed costs are $14,350 a month. Break-even is about $41,618 of sales.
- TaroStack shows what the shelf is worth and what to reorder. More below.
Where $100 goes
Each line's variable cost for $100 of sales: the wine, card fees, and bottles that are corked, broken or poured.
| Of $100 sold | Goods, fees and losses | Kept |
|---|---|---|
| Wine by the bottle | $66 | $34 |
| Mixed cases at 10% off | $73 | $27 |
| Wine club | $62 | $38 |
| Beer and cider | $72 | $28 |
| Cheese, snacks and gifts | $60 | $40 |
| Tastings and classes | $35 | $65 |
The case discount costs 7 points of margin and sells twelve bottles at once. The club keeps more than a shelf bottle because the owner picks the wines and buys them knowing how many will go. Tastings keep the most because what's sold is the evening.
Margins by product
| Product | Sold | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Wine by the bottle | Shelves | $100.00 | $66.00 | $34.00 | 34.0% |
| Mixed cases at 10% off | Shelves | $100.00 | $73.00 | $27.00 | 27.0% |
| Wine club | Monthly | $100.00 | $62.00 | $38.00 | 38.0% |
| Beer and cider | Cooler | $100.00 | $72.00 | $28.00 | 28.0% |
| Cheese, snacks and gifts | Front table | $100.00 | $60.00 | $40.00 | 40.0% |
| Tastings and classes | Evenings | $100.00 | $35.00 | $65.00 | 65.0% |
The table is by $100 of sales, because a shop carries about 600 wines. By price, the margin hardly changes. The speed does.
| Tier | Average price | Margin | Bottles a month | Shelf at cost | Turns a year | Earned a year on each $1 of shelf |
|---|---|---|---|---|---|---|
| Under $15 | $12.99 | 35.3% | 1,100 | $20,160 | 5.5 | $3.01 |
| $15 to $30 | $21.99 | 34.1% | 600 | $30,450 | 3.4 | $1.77 |
| $30 to $60 | $42.00 | 33.3% | 120 | $22,400 | 1.8 | $0.90 |
| Over $60 | $85.00 | 31.8% | 15 | $14,500 | 0.7 | $0.34 |
The top shelf holds $14,500 of wine and sells fifteen bottles a month. It's there so the shop looks like a wine shop, and it earns a ninth of what the bottom shelf earns on the same money.
A month at full speed
| Product | Hundreds of dollars sold | Sales | Gross profit |
|---|---|---|---|
| Wine by the bottle, shelves | 300 | $30,000 | $10,200 |
| Mixed cases at 10% off, shelves | 60 | $6,000 | $1,620 |
| Wine club, monthly | 40 | $4,000 | $1,520 |
| Beer and cider, cooler | 50 | $5,000 | $1,400 |
| Cheese, snacks and gifts, front table | 30 | $3,000 | $1,200 |
| Tastings and classes, evenings | 20 | $2,000 | $1,300 |
| Month | $50,000 | $17,240 | |
| Fixed costs | −$14,350 | ||
| Left | $2,890 |
Fixed costs are $14,350 every month: wages for part-time help ($7,500), rent ($4,500), utilities ($700), ads ($500), insurance ($400), the register and software ($200), license renewals ($150), and other costs ($400).
Break-even
| Fixed costs a month | $14,350 |
| Gross profit on each dollar of sales | 34 cents |
| Sales needed to cover fixed costs | $41,618 |
| As a share of a full-speed month | 83% |
Below about $41,618 of sales a month the shop loses money. In the plan this example comes from, that's reached in the seventh month, and the first year ends $4,668 behind before the owner's pay, on $182,000 put in to open.
What moves it
| Change | Effect on a month |
|---|---|
| The wine club doubles | +$1,520 |
| Tastings and classes double | +$1,300 |
| A fifth of bottle sales become mixed cases at 10% off | −$582 |
| Corked, broken and poured bottles take another 1% of sales | −$500 |
The club. Doubling it is +$1,520 a month, and every bottle is ordered after it's sold.
Cases. The discount only pays if the customer buys more wine than they would have. If they'd have bought the same twelve bottles over a month, the shop gave away $582.
The first year, month by month, with the tiers and the club, is in wine shop business plan. A store with spirits and beer is in liquor store profit margin, making wine in winery profit margin, and a restaurant's list in how to price a wine list.
Get the calculator
Download the wine shop 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 tier table is the most useful thing here, and it needs two numbers for every wine: what's on the shelf at cost, and how many sold. The register has the second. The first is a count of 600 wines, done once a year for the accountant.
How TaroStack does it
TaroStack keeps the shelf counted, at cost.
Counting on a phone, with no signal. A count shows what a variance is worth.
Stock value at cost, by month, so the top shelf's $14,500 is in front of you.
A reorder list in days of cover, with each distributor's lead time and minimum. A wine with 300 days of cover is easy to spot.
Every adjustment carries a reason: corked, broken, poured at a tasting.
A price-creep report by supplier shows a distributor's prices moving.
| The job | Calculator | In TaroStack |
|---|---|---|
| What the shelf is worth | A count and a lookup | Stock value at cost |
| Wines that aren't moving | A feeling | Days of cover on the reorder list |
| Bottles poured at tastings | Not written down | Adjustments by reason |
| What to reorder | Walking the aisles | The reorder list |
TaroStack doesn't run the register, the club's billing or the tasting bookings. 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.
