Hi all,
I have a scenario where my company manufactures some drinks. They do either drink mixing or repacking of a variety of flavors. I'm wondering what is the best way to model this with respect to the manufacturing and stock modules.
Essentially, the way this works is they order large containers of basic drinks and water (say 500 liters of A, 500 liters of B, 300 liters of water, etc.). They have different containers sizes for each basic drink, which they then mix in larger containers to produce more complex drinks or which they directly repack into 33cl, 50cl or 1l bottles.
The way I've modeled this so far is as follows:
- For each basic drink and water, I have different containers, i.e. A-500, A-300, A-100, etc. (which then corresponds to what they order from suppliers). I therefore have items A-500, A-300, A-100, etc. I also have an item A, but that's used for manufacturing (when I convert into volumes -- see below). I can't model this directly as A, B, C and have the quantities be liters, because they need to keep track of the *drinks in the containers* in their stock until they actually use the contents to produce something else (i.e. they don't order 500 liters of A, they order 1 container of 500 liters of A, each of which has a batch and serial number).
- A-500 comes in, is weighted and the corresponding volume is determined in a custom field during the purchase receipt (there is a 2% margin of error allowed on the volume).
- When A-500 is used for manufacturing, it goes into a Work in Progress warehouse where it no longer exists as a container, but becomes a volume of A (I pull the volume from the purchase receipt and I convert it in a custom script).
- What comes out of manufacturing is something like 100x ABC-33cl which are then assigned a batch and serial number. I have pre-computed BOMs for every possible combination. (Side question: I'd like to have the option to do 50x ABC-50cl and 50x ABC-33cl in one production order -- is that possible ATM?).
Am I going about this the right way or am I shooting myself in the foot? This seems like a lot of different items and lots of BOMs to maintain.
Thanks in advance,
Billy