I work with small items that are purchased in bags of varying amounts (200 - 750 units per bag). I use these to construct my products, however, I may use 50 of one product, 200 of another, and 20 of yet another. I'd like to be able to track the purchases as bags, but calculate inventory and cost based on units in the bags (i.e. 2 bags of 500 at 10.99 each will track 1,000 products at $0.02198 per unit). Setting it up this way will allow me to calculate the costs of materials used in producing my merchandise.
I guess I could enter the actual units in the bag and calculate the price per unit, I would just need to be able to adjust the precision used for the unit cost. However, I would like to know if there's a way to automate this type of conversion.
Thank you for any help you can provide!
-Mark