Again maybe missing this, but would love to be able generate and export that compares cost of multiple batches of a same beer. As cost-price is very fluid at the moment this is important to keep track of instead of easily instead of diving deep into the cost reporting on batch level to extract the data
The values to select from would be:
Beer - batches/date range - yield/loss per batch - per batch/per container/per product cost - ingredient/packaging/duty cost - total cost
Sorry for not replying to you before. There isn’t a report currently to do this (and this data isn’t easily accessible in the Raw Data Explorer). As you’ve posted this here, it’s on the list now so we can look to add this in the future
I don’t want to nag - but this is still very high on my wishlist - I feel that I am constantly on a back foot monitoring price changes (in predictive as well as actual batch changes) - (early december/end january alone saw the costprice change with 2% here) which makes it more difficult than it should be to monitor changes and predict developments and associated price increases
Hi – I’m trying to figure out how I can run a report that would in essence give me a breakdown of COGS for a list of beer and gyles, broken down by product. I’m trying to get an understanding of how COGS changes over a series of batches where the yield fluctuates and pricing for raw materials changes.
Does something like this exist? Or is it possible to create?
The only place you can currently see packaged beer COGS per batch is on the batch cost report, found by going to an individual batch’s page and clicking Reports > Cost report. Our normal Packaged beer COGS report isn’t broken down by batch. It’s not possible to get the COGS through on a custom report at the moment, I’m afraid.
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:
Please can there be a report made or that I can adapt from raw data to show us the costs for each batch (pre racking), so we can see the cost increases as a sliding scale over a custom period, lets say also with filters by recipe or just all the raw data so I can do filtering in excel.
I know you can go into each batch individually and see the cost figure but I’m talking about a report on all batches so we can see total batch cost fluctuations over time rather than comparing snapshots of different single batches which may be packaged differently or have adhoc costs.
It would also be interesting to see this report at batch level data in a table/chart post pack to see the general % trends.
This info would all help with pricing decisions linked accurately to cost inflations.
It might already be there but I cannot find/build it.