For Qty/Parent in a parts BOM, is there a way for me to say:
For every 5 of a parent I consume exactly 1 material.
If I am producing anywhere between 1 and 5 of a parent, I need 1 material, between 6-10 I need 2, 11-15 I need 3, etc?
You could set the child quantity as .20 and then round up. You may have to set the UOM to not allow decimals on the child part’s UOM
This can cause issues if you have that child material in multiple locations (Op Seq) in the BOM. It will not sum the quantity together.
I was trying to avoid winding up with decimal QOH for the child part. We don’t actually consume .2 if we make one, we consume 1.
if the child item is set to “EACH” and EACH is defined as zero decimals, you can still define the BOM to be 0.2 each. When you create a job for 5, it will consume exactly 1 of the child… if your job is for 2 units, then the inventory system knows it cannot store .8, so it rounds up… it will consume 2 of the children from stock.
I often use the example of “making cookies”… it takes 1 EGG to make 2 dozen cookies… so I could make a BOM that says it takes 1/24th of an egg per cookie… If I want to make 3 dozen cookies, I will need to remove 2 eggs from the fridge, but I will only use 1.5 of the egg. the 1/2 egg will go down the sink (or fed to my cat).
Hi, I agree with this however we have a challenge with costing. We never make 1 cookie (using your example) so in my BOM I don’t want it to cost 1 egg. I would like it to cost 1/24th of an egg. The consumption and demand on stock is correct but the BOM cost is not. Any ideas??
you also need to set the “costing lot size” in the Part/Site tab… in this example you would set this to 24, and the system should work.
2 Likes
Tim this was exactly the thing I was looking for! Thank you.
I will make this field visible in the Engineering and Costing Workbench!