Tracking costs on additive batches requires the Additive Batch Tracking & Addition Calculator add-on feature and the Cost Tracking add-on feature.
Costs can be set and tracked on batches in your additive inventory. With each addition action, InnoVint not only depletes from your inventory, but also directly applies the associated cost per unit added to any lot. The cost will also be proportionally distributed to any and all lots that receive volume from the original lot.
(Alternative method: Additive costs can also be applied to a juice or wine lot indirectly as an overhead cost item, rather than entering costs on the additive batch level. To detail this option, click here.)
This article covers:
- Adding cost to an additive batch
- Receiving new inventory of an additive batch with same cost
- Receiving new inventory of an additive batch with different cost
Adding cost to an additive batch
Direct costs can be added as part of the creation of a new batch. From the Additive Explorer, select the additive to add a new batch to. In the top right, click on Add batch and fill in the appropriate attributes. (For more detailed instructions on how to add new additives and batches, click here.)
The Total Cost is the cost of all the items for that batch in your inventory. In the example above, the Total Cost is $900 for 3 x 75kg bags of Tartaric Acid (225kg in all), or $12.00 per kilogram. Calculating the cost per addition unit is dependent on the accuracy of the total amount and total cost.
Adding direct costs to an additive batch assigns a cost per addition unit. (E.g. an addition of 500g of this batch of Tartaric Acid will apply a cost of $6.00.) Note that the cost per addition unit remains the same, even if the on-hand inventory is in the negative. So even if my on-hand inventory shows -10.5 kg of Batch #1357, an addition of 500g of Batch #1357 to Lot A will still apply a cost of $6.00 to Lot A, and the on-hand inventory will be depleted to -11.0 kg.
For a batch that is already in your inventory, you can also edit your batch attributes, including cost. Keep in mind that this will add a direct cost to all lots that have already received an addition of that batch and/or received volume from a lot that had an addition of that batch.
What if I receive another delivery of the same batch with the same cost per unit?
Edit the batch attributes, updating the Total amount (hint: adjust the # of items) received in inventory and the Total Cost. This will distribute the cost per unit proportionally across all lots that have already received an addition of this batch, and any additions in the future. (i.e. It will affect all previous and future costs associated with the addition of this batch.)
What if I receive another delivery of the same batch with a different cost per unit?
There are 2 options for adding inventory of the same batch with different costs:
- Follow the same instructions as above. This will distribute the new cost per unit proportionally across all lots that have already received an addition of this batch and any additions in the future. (i.e. it will affect all previous and future costs associated with the addition of this batch.)
- Create a new batch with some distinction in the batch name to delineate it, different from the original batch. In the example below, batch #'s 10347812-A and 10347812-A (2nd delivery) are the same batch, but at different costs per unit.