To cost a beer, add the batch's ingredients, the labor to brew, cellar and package it, and a share of overhead, then divide by the pints you actually packaged, not the pints you brewed. For the three-barrel pale ale below, that's $249.18 of ingredients, 10 hours of labor and $180 of overhead over 688 pints: 94 cents a pint. A taproom pint at $7 and a keg at $180 leave very different amounts from that, and the calculator shows both. It's free, and the numbers are yours to change.
The short version
- Cost malt, hops, yeast and the small stuff for one batch.
- Divide by gallons packaged, not gallons brewed. The loss is part of the cost.
- Add labor and overhead a batch, then a package if there is one.
- Test each way you sell: taproom, keg, cans.
- TaroStack costs each batch from the lots it used and shows the real yield. More below.
An example: a three-barrel pale ale
| What goes in | Amount | You pay | Cost in the batch |
|---|---|---|---|
| Pale malt, 2-row | 165 lb | $42.00 for 55 lb | $126.00 |
| Crystal malt | 15 lb | $52.00 for 55 lb | $14.18 |
| Cascade hops | 2 lb | $16.00 a pound | $32.00 |
| Centennial hops | 1.5 lb | $18.00 a pound | $27.00 |
| Yeast, one sixth of a pitch | $180 pitch, six generations | $30.00 | |
| Water salts and cleaning chemicals | $12.00 | ||
| CO2 | $8.00 | ||
| Ingredients, the batch | $249.18 |
The batch is 93 gallons into the fermenter and 86 gallons into kegs. At 8 pints to the gallon, that's 688 pints.
| A pint | |
|---|---|
| Ingredients ($249.18 ÷ 688) | $0.36 |
| Labor: 10 hours at $22 | $0.32 |
| Overhead, $180 a batch | $0.26 |
| Full cost | $0.94 |
Had you divided by the 744 pints brewed, ingredients would look like 33 cents. The 7 gallons left in the kettle, the fermenter and the lines were paid for too.
Taproom and keg
| Where it sells | Price a pint | Fees | Left | Margin |
|---|---|---|---|---|
| Taproom pint | $7.00 | 3% | $5.85 | 84% |
| Keg to a bar: $180 a half barrel | $1.45 | 0% | $0.51 | 35% |
A half barrel holds 124 pints, so $180 is $1.45 a pint. The taproom pint leaves eleven times what the keg pint does. That isn't an argument against kegs. The taproom's $5.85 still has to pay the taproom: rent, bartenders, glassware. The keg's 51 cents is nearly clean. But it does tell you how many kegs it takes to matter: 124 pints at 51 cents is $63 a keg.
Two costs aren't in the calculator, and you should add your own: federal and state excise tax, and the keg itself if it doesn't come back.
Hoppy beers move the numbers
Run an IPA through the same sheet. Hops go from $59 to perhaps $240, and dry hops soak up beer, so 82 gallons come out where the pale ale gave 86. That's 656 pints carrying a bigger bill. Ingredient cost roughly doubles a pint. Price it like the pale ale and it's the beer that sells best and earns least. Recording what each batch really yielded is what a brew log is for.
Get the calculator
Download the beer cost calculator. Two sheets and a read-me: the batch cost and the prices. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A full plan for a taproom brewery is in brewery business plan.
Where this stops working
The calculator holds one recipe at one set of prices. Hop contracts change, malt goes up a dollar a sack, and each batch yields a little differently. A brewery with eight beers on tap would need eight sheets kept current, and the honest yield for each.
How TaroStack does it
TaroStack costs each batch as it's brewed.
Each beer is a recipe. Record a brew and the malt, hops and yeast come off stock, from the lots you hold, at what you paid for them, freight included.
Cost follows the real yield. Packaging the batch records the gallons that made it into kegs or cans. The cost of a keg comes from the batch's actual output, and your batch history shows whether a recipe yields what it claims.
Actual against standard. See what the batch used and cost against what the recipe said it would.
Stock in tanks counts. Beer in the fermenter is a lot with a value, so the month's stock value includes it. What to keep on hand is in brewery inventory spreadsheet.
| The job | Calculator | In TaroStack |
|---|---|---|
| Ingredient cost of a batch | Typed from invoices | From the lots used |
| Gallons lost | Estimated | From what was packaged |
| Eight beers | Eight sheets | A recipe each |
| Value of beer in tanks | Not counted | A lot with a cost |
TaroStack costs ingredients and packaging; labor, overhead and excise are yours to add. It doesn't write TTB reports. Recipes, batches and true cost 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.
