I hadn’t really thought of this before, but when I buy bulk packs of an object and break it down for re-sale I have just treated the bulk pack as multiples of the individual item.
For example: In previous testing, 24x pack of bottled water, or 30x cans of coke, I’ve been able to enter into
manager as 24 or 30 individual items and then just calculated the individual cost myself. I’d been fortunate enough that when dividing the price by the number of objects, it’s been a non-repeating decimal. But today that wasn’t the case and it messed with my OCD
So doing some quick research I found the references to
Manufacturing Orders which are now
Production Orders and I’ve been able to create an inventory item for a
12, 24, and 30 pack items at a unit cost per pack, and then
Produced it down to individual items.
This is what I did:
- created an
12 packand bought 2 of them
- created a single individual
- created a
production orderand turned 2 bulk packs into 24 individual packs.
This works, but I was wondering for items that really don’t change other than the fact they are broken down or multiplied together, is there a better way to handle it?
It seems odd that I have to do this for every carton of stock I want to track (it goes beyond bottles of water and cans of coke and could break down to any stock ordered in bulk and sold in lesser quantities).
The only way I could think of would be if manager could account for inventory ordered in bulk by way of either:
- being able to enter QTY (packs, cartons, groups) each containing QTY (individual items) bought for UNIT cost of GROUP items, or
- being able to record QTY (total items purchased eg. 24 bottles and not 2 packs) individual items for a TOTAL group price and have manager calculate the individual price (which can then be a repeating decimal, or a fraction).
Is there another way of dealing with it I haven’t thought of/come across yet?