A question I am often asked is ‘What is the expected cost of this product?’ for in progress batches, and I wanted to know if there is any easy way to pull this from breww?
I can see the Cost Report on the Recipe, and there is also the Cost Report on the batch, but neither of these are a complete picture, as I need to add additional costs on top of these, e.g. packaging, beer duty.etc to arrive at the figure I am being asked for.
Is there an easy way to do this?
If not, I plan to propose a feature request in the Cost Report tab of the in progress gyle, to show an Expected Planned Packaging Cost, based on the planned packaging, as this will know packaging components & also duty. This would then be replaced with the actual cost once racked. Does this seem a sensible way to approach this problem, or does anyone have any better ideas?
Hi Steve, Thanks for your comment! It sounds like the Product expected cost breakdown report should be helpful for this; you will be able to find this in Reporting > Pre-built production & inventory reports. This is also discussed further here: Expected cost reporting. The product expected cost breakdown will consider the expected costs of the stock items on the latest recipe for the beer, the materials associated with the product’s packaging, as well as duty costs. However, this report doesn’t look at specific batches. I hope this helps and let me know if you have any other questions. Cheers!
Thanks @ben-collard can’t believe I missed this!
It’ll be really helpful.
Just for my knowledge - as it isn’t gyle based, am I right in assuming breww is drawing the ingredients cost from ‘Latest Landed Cost’? Or does it depend on whether or not the item is currently in stock (has multiple batches/prices, or is completely out of stock), and uses the Average figure?
Hi Steve, thanks for your reply! When you run the report, you will be able to choose to use the Latest landed cost or the Expected purchase price for the stock item costs. Cheers!
1 Like