I was wondering if there was any function that would allow us to compare the actual costs of a batch compared to the expected costs on a line by line basis.
The only way we do this at the moment is to look at the ingredients and costs added to the batch, then on another screen open the recipe cost report for the same beer and compare line by line manually.
Given the data is all in BREWW, could we have a report that pulled this data out for us?
There’s no update to report on this yet, Geoff. We’re working hard to improve Breww all the time, but with multiple requests coming in every day, it takes quite a bit of keeping up with!
We will always post an update on the thread if there’s been any news, so keep an eye on the thread for updates. You can also make sure you’re subscribed to notifications by using the button on the right of the thread.
For more information on how feature requests work and for help on voting and subscribing to updates, please see this guide:
This is one of the items I was expecting to get to in a month or two, so I am glad to see it getting talked about here.
For me the comparison of expected cost of stock items vs actual cost per batch is half of the job.
What I need as well is for Breww to take the actual cost of stock items and divide it by the total amount of litres in bright tank pre package. this will give a real time cost of goods taking into consideration the stock items and what ever liquid losses might have occurred along the way.
From this data point Breww may be able to track the losses between Bright tank and final pack volume, which would inform us on how efficient each pack type is. For example we loose much more liquid when canning vs. casking, which in turn is one of many data points that informs me to how much of a price premium per litre we should be charging for canned beer vs. casked beer.
What I (and I believe Geoff-marriott is getting at) is seeking is a robust and accurate cost of goods and cost of goods sold. This info is paramount to being a profitable brewery, not just knowing what processes are losing you liquid or costing you money but also actively tracking them is a job that more than pays for it’s self.
To summarise.
Tracking expecting recipe cost vs actual recipe cost as a whole.
And
Expected vs Actual recipe cost vs expected and actual Lt in bright tank.
These two are a great start to getting the actual cost of goods per lt.
Thank you for your service Luke - I have been enjoying using Breww so far