I am not an accountant so please forgive the lack of correct terminology or understanding of the product in a financial sense - I’m just trying to use Manager in a way that fits in with our small community group’s needs.
We show films - which in Manager are Divisions. This allows us to monitor profit/loss for each of the films we show. All income and expenditure is recorded at Division level (see attached image) - and broadly works very well. When we sell (say) a beer, the income records correctly in Inventory Sales; the cost of sale records correctly in Inventory Cost
Now I want to work at a slightly more detailed level. I want to be able to work out the exact profit of something we make on day of the film and which is made up of multiple components. A beer is a single component, but a Gin and Tonic comprises 2 units of gin and 1 unit of tonic. Both the Gin and the Tonic are inventory items, which have been recorded at unit level (eg a bottle of gin is 20 units of gin).
I’m sure it ought to be achievable but I can’t work out how.
Inventory Kits don’t work because you can’t “write off” at Inventory Kit level (we might make a G&T and have to throw it away, or, more likely it will be drunk by a Volunteer as we see volunteer refreshments as an absorbed cost - we log them against a Volunteer Refreshment account within the Division).
Production Orders don’t work because whilst the income from the sale of the produced item is logged against the Division, the cost of the component items is not.
Is there a way of achieving this ? Many thanks.
