Free Excel templates

A free brewery cost per barrel calculator in Excel

Barrels by channel, prices and costs in; standard cost per kegged and canned barrel, contribution per barrel by channel, EBITDA, the debt service coverage ratio and break-even barrels out. No macros.

The file comes prefilled with Kettlewick Brewing Company, the fictional brewery of the book, for 2025: 3,900 barrels sold through five channels, a standard cost of $258.01 for a kegged barrel and $355.01 for a canned barrel, contribution of $1,033.64 per barrel of taproom draft against $151.80 per barrel of distributor cans, EBITDA of $479,378, a DSCR of 1.37 and a break-even of 2,862 barrels.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Brewery_Cost_per_Barrel_Calculator.xlsx (18 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This file is the costing page of The Craft Brewery Owner. The book explains every line: why the barrel is the unit of account, what a standard cost card holds, why a barrel earns what its channel pays, when excise is owed, why the fermenters set the ceiling, and how the year is planned to the bank covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Barrels sold by five channels; the pint, four-pack, keg and case prices with the units per barrel; the yield; ingredients, utilities, excise and packaging per barrel; taproom labor, card fees, distributor support and delivery; production labor and overhead, other fixed costs, debt service and member distributions.
Calculator
Barrels brewed, the standard cost of a kegged and a canned barrel, variable and full production cost per barrel, price, variable cost and contribution per barrel for each channel, EBITDA, the DSCR, break-even barrels and the barrels needed for a DSCR of 1.25, each with a one-line definition beside it.
Read Me
How to replace the case with your own brewery, and which inputs to check with your advisers.
Checks
The calculator compared with the figures printed in the book for the case.

Three things to try

Move ten percent of your distributor cans to the taproom. Contribution rises far more than revenue does, and break-even falls. Then ask whether your cellar and your taproom can actually carry those barrels.

Raise the can packaging input. The canned standard cost and the contribution of every canned channel move at once; the kegged lines do not.

Replace the case. Type your own barrels and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading