MRP - Calculation - BARS Conversion to Stock
There is a problem, the purchase is based on a Tube with 6 meter (6000mm), and depending on the quantity of parts, we have to calculate the actual work order requirement manually.
Examples:
1 - A 153 units , with 583mm by piece, by normal system calculation is requesting 153 pieces x 583mm / 6000mm = 14.8665 6000mm tubes and actually 16 bars will be needed because 6000/583 = 10.2916 pieces, analyzing only The whole part is 10 pieces per bar, disregarding the leftover. 153 pieces / 10 pieces per bar is 15.3 bars, ie we need to round up to 16 bars.
2 - An 8 piece WO from the above by normal system calculation is requesting 8 * 583/6000 = 0.777333 bars. In the same concept, and actually 1 bar is required.
We want the MRP calculation to “understand” based on the length of each part.
Thanks in advance!
-
Official comment
In BoM we've the field "Rounding Type"
Do you mean, you can use this?
-
Hi Rafael
In which unit are the bars stored?
in bars: How are rests of bars managed?
in meters: how is the length of each bar determined?e.g. 3 m: That can be 3 bars 1 meter each.
When cutting to size, there may be waste, as the saw blade also has a certain width or the material must be held in place in some way as during processing.
For some companies, the administration was too complex. The direct manual inspection can be more effective depending on stock levels.
regards
Martin
-
Hi Martin !
Thanks for your answer !
My ideia is the WorkOrder, in some cases, has in another field the quantity of material that exceeds the calculation, but it's not going to be consume, this field complete the real quantity that I need to buy.
I need to purchage , for example, 16 bars, the Work Order will consume 15.3 bars.
As you said, the manual inspection will take care about the rest.
Please sign in to leave a comment.
Comments
3 comments