Beer Math: Brewery Production Spreadsheet

Do you wish you had a fast way to calculate how much beer you’re able to package from each batch?

Your wish has been granted.

Let’s say you need 100 half-barrels, 50 logs, 250 cases of 16oz cans, and 150 cases of bottles. How much beer do you need to brew?

This is a question that is asked and answered many times a month in your brewery (maybe many times a week). Each time it’s the same routine – two or three people pull out their cell phones, open up the calculator and start figurin’.

One person gets a number, then a second person gets a different number. The dance goes on like this until everyone agrees. It can take some time to figure out.

Let’s try a different way to save you time and all that figurin’. Put away the calculators and the scrap paper, and open up the Brewery Production + Packaging Calculator. This cool spreadsheet is going to save you some time.

The spreadsheet has notes and easy-to-follow instructions. Download it, save it where you can find it, and use it the next time you need to figure out how much beer you can package from each batch.

No cell phones or figurin’ needed. Just a cool spreadsheet to save you time.

 

You may also like to read……

Brewery Cash Management SOP

Brewery Cash Management SOP

Standard operating procedures (SOPs) are a written set of instructions that show us how to complete tasks in a consistent way. Financial SOPs are...