A bottle of wine's cost is five sums. Grapes: tons times the price a ton. Winemaking: what it costs you to ferment, press and look after a gallon. Barrels and aging, for the wines that get them. Packaging: the bottle, closure, capsule and label. And bottling. Add them, divide by the cases you filled, and divide by twelve. The arithmetic is easy. What makes it worth doing wine by wine is that the answers differ far more than the shelf prices suggest: in the example below a Pinot noir costs half as much again to make as a rosé from the same cellar. Below are three wines for a made-up small winery, where the money goes in a bottle, what moves the number, and the calculator. Every figure is this winery's own. Use your invoices.
The short version
- Gallons = tons × the gallons you get from a ton.
- Cases = gallons ÷ 2.3775, rounded down. A case of twelve 750 mL bottles is 9 liters.
- Total = grapes + winemaking + barrels + packaging + bottling.
- Cost of a bottle = total ÷ cases ÷ 12.
- Cost each wine separately. They aren't alike.
- This is production cost. Excise tax, rent, equipment and selling come after.
- TaroStack costs each lot from what you paid for what went into it. More below.
Three wines
| Pinot noir | Chardonnay | Rosé | |
|---|---|---|---|
| Tons of grapes | 4.0 | 3.0 | 2.0 |
| Price a ton | $2,800.00 | $2,200.00 | $1,800.00 |
| Gallons from a ton | 155 | 165 | 160 |
| Gallons | 620 | 495 | 320 |
| Cases | 260 | 208 | 134 |
| Grapes | $11,200.00 | $6,600.00 | $3,600.00 |
| Winemaking, a gallon | $6.50 | $5.00 | $4.00 |
| Barrels and aging | $1,800.00 | $600.00 | $0.00 |
| Packaging, a bottle | $2.10 | $1.95 | $1.80 |
| Bottling, a case | $6.00 | $6.00 | $6.00 |
| Total cost | $25,142.00 | $15,790.20 | $8,578.40 |
| Cost of a case | $96.70 | $75.91 | $64.02 |
| Cost of a bottle | $8.06 | $6.33 | $5.33 |
The Pinot costs $8.06 a bottle and the rosé $5.33. Priced alike at wholesale, the rosé has been carrying the Pinot.
Where the money goes in a bottle of Pinot
| A bottle | Share | |
|---|---|---|
| Grapes | $3.59 | 45% |
| Packaging | $2.10 | 26% |
| Winemaking | $1.29 | 16% |
| Barrels and aging | $0.58 | 7% |
| Bottling | $0.50 | 6% |
| Total | $8.06 |
Grapes are the largest line, and packaging is second, ahead of everything that happens in the cellar. A heavier bottle or a foil capsule is a decision worth a real share of the cost.
What moves the number
Yield. Gallons from a ton depends on the fruit, the press and how hard you press. On the same four tons:
| Gallons from a ton | Cases | Cost of a bottle |
|---|---|---|
| 145 | 243 | $8.35 |
| 155 | 260 | $8.06 |
| 165 | 277 | $7.80 |
Ten gallons a ton is between 26 and 29 cents a bottle here. Measure your own yield for each lot: tons over the scale, and gallons in the tank after pressing.
Grape price. At $3,400.00 a ton in place of $2,800.00, the same Pinot costs $8.83 a bottle.
Losses after pressing. Racking, filtering, topping and bottling each leave wine behind. The calculator turns gallons straight into cases, so type the gallons you expect to bottle, not the gallons you pressed.
Time. A wine aged eighteen months ties up its cost for eighteen months. The calculator doesn't charge for that. Add a line of your own if you borrow to carry it.
From cost to price
Production cost is the floor, not the price. Excise tax, the building, equipment, insurance, your own time and the cost of selling all sit on top of it. How those add up for a whole year is in winery business plan and winery profit margin. Pricing a bottle for a shop or a wine list is in how to price wine. Having a winery make the wine changes which of these lines are yours: see custom crush winery.
Get the calculator
Download the wine production cost calculator. One sheet and a read-me: type the tons and price of the grapes, your gallons from a ton and your own costs, and it works out the gallons, the cases and the cost of a case and a bottle, a row for each wine. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The sheet costs a wine from one price for grapes and one figure for the cellar. A real Pinot is three vineyard lots at three prices, pressed on different days at different yields, blended in March, with a fifth of it held back for a reserve. Bottles came from two deliveries at two prices. By bottling day the true cost of the blend is a sum nobody has time to do, so last year's number gets used.
How TaroStack does it
TaroStack costs the wine from what actually went into it.
Receiving records each delivery as a lot, at what you paid, freight included: grapes, bottles, corks, labels.
Each crush, blend and bottling is a batch that takes its inputs off stock by lot. The batch notes which lots it used, automatically, and its cost comes from theirs.
Actual against standard. A lot that pressed out thin, or a bottling that cost more than planned, shows it.
Margins by product on real cost, so the Pinot and the rosé are each seen for what they earn.
A price-creep report by supplier shows when glass or corks went up.
| The question | One-price sheet | In TaroStack |
|---|---|---|
| What the blend really cost | Last year's number | From the lots that went in |
| What this lot yielded | Remember to measure | Used and made, on the batch |
| Which wine earns its keep | Guess | Margins by product |
| Whether glass went up | Compare invoices | Price creep, by supplier |
TaroStack doesn't work out excise tax or file TTB reports. Recipes, batches and costs are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
