Brewery Cost Calculator - Batch Costing and Beer Pricing Spreadsheet for Craft Breweries, Excel and Google Sheets, Instant Digital Download

★ Editable Excel & Google Sheets file, not a printable and not an app. No macros or add-ons to install. Instant digital download, works on Mac & Windows. Built by a commercial-finance professional; every formula is tested against a separate model, so the number holds up.

Everyone knows what the batch sold for. Nobody knows what it cost.

True cost per can or keg for a craft brewery — malt, hops, packaging and brewhouse hours — and the minimum price that holds your margin.

You don't need to be good with Excel. You type into the white cells and everything else is worked out for you. The formulas are locked, so nothing breaks by accident.

WHAT'S INCLUDED
• Dashboard — Three headline numbers and two charts. Read-only.
• Start Here — Five steps from opening the file to a real number on screen.
• Batch Costing — Where you cost one recipe. The main working sheet.
• Ingredients & Packaging — Your shelf. Enter each purchase once; used everywhere.
• Settings — Labor rate, overhead, target margin and fees.
• Instructions — What each sheet does, and what to do if a number looks off.
• About — Version, license and support.
• PDF Quick-Start Guide — two pages, first result in five minutes

PERFECT FOR
• Taproom owners pricing pints, crowlers and kegs from one batch
• Brewers costing a new recipe before it goes on the board
• Breweries selling wholesale without giving the margin away
• Contract brewers checking the numbers they were quoted

HOW IT WORKS
1. Open Settings. Set your hourly rate, overhead % and the margin you want to keep.
2. Open Ingredients & Packaging. Enter each purchase with its pack size and set yield % for anything you lose.
3. Open Batch Costing. Name the beer and enter how many sellable cans the batch produced — not the brew length.

COMPATIBILITY
✓ Google Sheets
✓ Microsoft Excel 365
No macros. No add-ons. Works immediately.

FAQ

Q: Can I cost kegs as well as cans?
A: Yes. Use the keg line for packaging and set the batch to produce kegs rather than cans. Cost them as separate items so you can compare.

Q: How do I handle excise tax?
A: As a line on the ingredient shelf priced per unit, or in overhead % if it is easier. Either way it must be in the cost before you set a wholesale price.

Q: Should taproom sales use the same cost?
A: The cost is the same; the margin is not. Copy the sheet and set a higher target margin for direct sales.

Q: Does this work in Excel and Google Sheets?
A: Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.

Q: I'm not confident with spreadsheets. Will I manage?
A: Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.