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.
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.
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
Four sheets. Blue type is an input; black type is a formula.
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.