Hello,
I am trying to develop a batch manufacturing app. We produce various juices and beverages. For each product, we have a bill of materials which might include simple raw materials (e.g. bottles, sugar, water, etc.), but could also include WIP items (e.g. lemon juice), since we are purchasing lemons and juicing them on site.
We produce to order, but the orders contain the finished products (e.g. case of lemonade). The lemonade BOM would include water, sugar, bottles, boxes, and lemon juice.
In this example, we have to track 3 processes -- juicing the lemons, mixing the lemon juice with the other ingredients, and filling them into bottles. We combine the packaging in the last step since it happens at the same time.
Where it can get tricky is that we might also have orders for bottles of just lemon juice. The BOM for that item would be just the lemon juice as well as the packaging. There would be a juicing step to make that product, but no mix step. The lemon juice that goes into this product would be the same as the lemon juice that goes into the lemonade.
What I'm trying to achieve is setting this up to where we can select what order line items we want to produce, and then combine them to create manufacturing orders for each step of the process (e.g. juicing, mixing, filling/packing). I have an order entry screen that automatically creates the line items so we can assign case quantities. I also have item configuration, and can add BOMs pretty easily. I'm having a hard time figuring out how to go from order quantities and consolidating that down into manufacturing orders that takes into account the multi levels of the BOMs. I would appreciate any insight anyone has to offer.
Thanks!
LinkedIn
Twitter
