Brewers must have everything required to brew and package beer in the near-term but be careful not to amass a surplus of raw ingredients, aluminum, glass, and cardboard that would create space issues and negatively impact cash flow.
It’s an annoying problem that all too often must be solved by switching from tab to tab on a makeshift spreadsheet during lautering or in-between hop additions.
And worst of all – imagine how frustrating it would be if your current data management system locks you out of recording brewing data when you don’t have the inventory added to the system. Instead of focusing on milling in grain or adding hops during a boil, now you’re focused on tracking down the invoice – which is just not reasonable. In Beer30, you are never locked out of entering brewing data – record it once as you brew, and inventory can catch up later. Another benefit of Beer30 is that it helps you understand the actual Cost of Goods Sold (COGS) that go into each pint, bottle, can, or keg!
Using Beer30 to generate a COGS report broken down by package type, with raw material and packaging data.
We know most brewers are tracking their cost of goods sold in some way, whether it be with spreadsheets or a software program.
But the level of detail in the data and how it is then used, can make the real difference.
You cannot hope to improve efficiency or increase profitability without metrics to measure this. But if you’re not analyzing these metrics, comparing output with sales revenue, and tracking the true cost of making your beer – what is this data worth?
If you’re not tracking profitability, you won’t know how to be more efficient, or increase your net profit. And, if you don’t know how profitable you are – you can’t plan for the future at all.
So, we would like to help you begin the year on the right track and ensure you are correctly tracking – and analyzing – your brewery’s cost of goods sold.
Here are the four area of brewery operations you should be paying close attention to, when analyzing this data and measuring profitability.
As we all know, running a profitable brewery is a balancing act.
As a brewer, you want to ensure you are only holding on to raw materials as you use them – you don’t want to be sitting on stock.
This could create space issues and impact your cash flow.
On top of that, brewers and operations staff need to factor in the costs of all goods and materials that come into the brewery. For many, this requires hard-to-update databases (or worse yet, another infinitely tabbed spreadsheet) stuffed with iffy data that is tough to query and export. That’s hardly a sound basis for maximizing profitability.
What brewery professionals need are reliable, easy-to-use tools that provide easy access to accurate cost data and the ability to manipulate it as needed. Or better yet, a single tool, like Beer30, which lines up costing information side-by-side, then goes a step further, comparing material costs against profit at the click of a button.
Our side-by-side cost summary feature conveys what is coming in against what is going out, detailing:
On a monthly basis, you should be able to pull up a report to see the total $ value for each set of raw materials and packaging supplies that are sitting on your shelf and in inventory to properly assess what your assets are for your material costs.
Using Beer30 to track Grains, Hops, Adjuncts inventory, along with $ value and Low Qty Thresholds.
Once raw materials are taken from storage and put into production – costs are moved from the raw material inventory to Work in Process (WIP).
The balance in WIP represents the value of the raw materials that make up the beer in the tank. There are several factors that need to be considered when calculating the WIP costs and how they relate to your overall cost of goods sold.
One of the neat features with Beer30 is that we properly transfer all costs associated with tank splits and merging! This is super important when you’re looking at taking a base beer, and splitting it up to make variations — i.e. brewing into a 15 BBL tank a base IPA, and then splitting up into two tanks to get a 7 BBL Pineapple IPA and keep an 8 BBL Habanero IPA.
We also advise our customers to include in their WIP and brewing data other costs, such as:
Using Beer30 to generate a WIP report for any day in the month, which includes split batches, transfers, and material additions and flavorings.
As package day rolls around, it is also super critical to include all package supplies too. This includes items like:
Each factor goes into making an actual overall COGS, for the beer.
Finished goods inventory refers to the quantity of manufactured products in stock that are available for customers to purchase. It’s important to then add in the overall value of these products.
When you use the right software system to track the components that go into making each packaged goods item, the individual COGS can be immediately calculated.
If you’re using Beer30, this can be accessed instantly. And you can easily compare the costs of, for example, a 24-pack of bottles vs. 24-pack of cans vs. 1 keg.
With the finished goods calculation, you should look at it on a batch by batch comparison for reporting purposes. You should see immediately if a batch is higher or lower than the Target COGS, which is the ‘gold standard’ for that beer.
It should be constantly monitored, to ensure your business is on the right track.
This is why using software to track your data makes your life easier. It is all being tracked behind the scenes, ready and waiting for you to access, whenever you need it.
Using Beer30 to see real-time inventory and valuations for each location / warehouse / coldbox.
And of course, the final piece of the puzzle is comparing your gross revenue against your cost of goods sold.
It’s the all-important formula for a successful business – sales revenue, minus cost of goods sold is your gross profit. And without profitability, a business will not survive.
Having this data on your brewery operations available anytime is not just convenient – it is crucial.
The Beer30 sales report breaks down your sales in an easy-to-understand format, giving you essential information at a glance.
You can identify trends happening with sales on your brews, see where the demand is, and compare your revenue directly against your COGS.
Constantly monitoring this data also helps you easily detect theft or missing inventory from the coolroom / coldbox.
Using Beer30 to compare package type data for various package sizes (kegs, cans, bottles), and broken up with data on a monthly basis.
By using a brewery management software like Beer30, you can take all the factors associated with COGS – raw materials, ingredients, labor, overhead, packaging supplies, cost of yeast, and more at each stage in the brewing process – and make them all part of the bigger picture.
In a single click in our Batch History tool, you can cycle through each brand and batch and see the EXACT dollar value per BBL / HL / L – and NEVER have to look at assumed average costs.
Then you can tie all this information together to truly understand how things are progressing, and what your future looks like. Financial and operating budgets, for both your current and following financial year are determined by the profitability of your brewery.
And as a bonus, if you are using Beer30 – we have an integration with Xero and QuickBooks Online. This allows our customers to automatically sync all your raw material, packaging inventory and sales and distribution information to either Xero or QuickBooks Online.
Not only does this save you or your bookkeeper hours of time (although this is an obvious advantage!), but by integrating directly with item codes and charts of accounts, we are able to help make sure that a brewery’s balance sheet, income statements, and bank reconciliations are accurate.
If you’re interested to develop a better understanding of your profitability and how it relates to COGS – get in touch.
We can set up a demo and dive in on Beer30 will help you deepen your knowledge of your business.
You can also check out the presentation that our Founder and CEO, Pulkit K. Agrawal, put together for the Craft Beer Professionals group, entitled “You’re Capturing All This Brewery Data… Now What?” He talks all about the most important ways to Beer30 tracks data, so you can use the numbers to #BrewMoreBeer.
