Create a finance-focused reporting feature that provides itemised actual product costs on a batch-by-batch basis, allowing comparison of costs across different production and packaging routes.
Business Problem
Current product costing views can mask cost differences by averaging costs across products. Where the same finished product is produced at different production sites and/or packaged by different co-packers, finance teams require visibility of the true batch-level costs associated with each route.
Existing reporting provides some of the underlying data but does not consolidate it into a single finance-ready report.
Proposed Solution
Introduce a new report that displays actual production costs at batch level, grouped by product and showing production and packaging locations.
Suggested Report Fields
• Product
• Batch Reference
• Production Site
• Packaging Site / Co-packer
• Volume Produced
• Volume Packaged
• Ingredients Cost
• Materials Cost
• Total Actual Cost
• Cost per hl
• Cost per Unit
These fields are based on the required output identified during the support review.
Key Use Cases
1. Compare the actual cost of the same product across different production sites.
2. Compare costs between different packaging sites and co-packers.
3. Identify cost variances that are hidden by averaged product costing.
4. Support finance reporting, margin analysis, and operational decision-making.
5. Provide a single source of truth for batch-level cost analysis.
Expected Benefits
• Improved financial visibility.
• More accurate product profitability analysis.
• Easier comparison of internal production versus co-packed products.
• Reduced manual data extraction and spreadsheet work.
• Better decision-making around production and packaging strategies.
Priority / Justification
High value for breweries operating multiple production sites, contract packaging arrangements, or co-packer networks where actual costs vary significantly between routes. The feature would address a gap in current reporting capabilities identified by Breww Support.