Hi. Could there a way to produce a report to show how much of a specific ingredient is used over a time period? E.g. to see how much Mosaic T90 we’ve used over the last year? It would be particularly useful for planning hop/malt contracts etc.
Cheers Joe
Hello,
This is also a necessity for us and forms part of our weekly reporting requirements.
We would need to be able to report on which ingredients have been used (hops/ malt/ packaging materials etc.) by batch. Including;
- date used (including date dry hopped if a dry hop)
- ingredient batch number
- quantity
- stage in process (i.e. hot side or dry hop for hops)
- stock item type
- product & product code (for packaging materials)
- cost
I have an example report format I can share.
Thanks,
Linda
Hi Linda
I absolutely agree with you and to be honest being new to Breww, i am shocked it is not already there. How can you verify a monthly p+l report when you cant breakdown your costs. If either of the COGS or the sales margin reports could be adapted to show cost by individual categories, we would have a lot more control over our margins
Thanks, everyone.
We’ve just launched a new Raw Data Explorer report named Stock item usage in beer batches. Can you take a look at this and let us know if this covers what you’re looking for?
Being a Raw Data Explorer report, you get shown the default columns initially but have lots of control over which columns you’d like to show if you want to customise this.
Cheers
We’ll assume this is covering what’s needed as we haven’t heard otherwise, so I’ll close this as complete. Cheers