Hello,
We issue our packaging material as fractional units. Let’s say 10 units can fit in a box, so on the BoM the required qty is 0.10 per. A 55 piece order shows 5.5 units needed, but that’s really 6 boxes needed as you can’t use half a box.
My question…is it possible round demand like this up so that system shows the actual consumed qty?
Thank you.
Yes, you can do this by entering the scrap % on the material in the BOM.
I would expect UOM settings to work for this. Somehow.
I haven’t tried to fully wrap my mind around doing this intentionally - but I’ve seen it work unintentionally on receipts.
So, we buy liquid in various container sizes. I think I’ve seen where we ordered a 55-gallon drum (and we don’t allow decimals on the “DRUM” UOM), but the supplier sent us like 37 1-gallon jugs instead, and so the receiving person entered a receipt of 37 gallons (good job) but the PO line closed because it rounded the receipt to a full drum. Inventory was right, but the PO got out of whack.
I made up the numbers today, but it was something along those lines.
I would see if Min Qty and Multiple would handle this. 1 in both I think would round that to even units. Unless it changes the suggestion and not the job.
From the tech ref guide
The Multiple modifier defines the quantity increments for each job or purchase suggestion. For example, if you enter 100 for this multiple, all job/purchase suggestion quantities will be values like 200 or 1,100 - multiples of this value. When generating suggestions against a demand source, the MRP engine rounds this quantity up to the nearest multiple value.
Ah, much better suggestion than mine.
Thanks for the suggestions!
I’ll play around with some of the ideas presented and let you know what I come up with.
Hey Greg, I just wanted to circle back and verify that your suggestion does indeed work.
Many thanks!!