Skip to main content

Hi Folks

 

We are using APPS 10 and looking at the various Lot Size options within IFS, when planning MRP requirements does the system start with the Min Lot size them move to Max then multiple or does one of these options take priority over the rest? (does one supersede the other)

Should the Max and Multiple be the same value?

Trying to figure out of there is some logic flow to these values if all three are filled in.

 

Min Lot Size: The value in this field indicates that the lot size for this part will be at least equal to the quantity specified. If the value is 0 (zero), the lot size will not be calculated.
 

Max Lot Size: The maximum lot size defines the maximum size of lots generated by material requirements planning (MRP). 

 

Multiple Lot Size: A value in this field indicates that MRP will round up net requirements to a multiple of this value when calculating the receipts. Shop orders created from shop order requisitions will use multiple lot size values defined here.

​@Robert Ross These parameters control the quantities in order when converted from the order proposals.

The functionality is illustrated with the following examples:

  1. Min Lot Size
    If the requirement is 10 and the Min Lot Size is set to 15, the order will be created for 15 units, as this is the minimum allowed quantity. The order quantity cannot be less than the defined minimum.

  2. Max Lot Size 
    If the requirement is 30 and the Max Lot Size is set to 20, the system will create one order for 20 units (the maximum allowed quantity). For the remaining 10 units, an additional order will be needed.

    • If the Minimum Lot Size is 15, the second order cannot be created for 10 units (less than the minimum). Instead, it will be created for 15 units.
    • If there is no Minimum Lot Size (value = 0), the second order will be created for 10 units, matching the remaining requirement.
  3. Multiple Lot Size
    The order quantity is determined as a multiple of the specified lot size. For example, if the Multiple Lot Size = 20, an order will be placed for 20 units instead of 15 when the requirement is 10. When the requirement is 30, an order is created for 40 units (multiple of 20). Lets assume there is no Min or Max sizes set in both scenarios. Otherwise those needs to be taken into consideration too.​​​​​​​

Hope this help understanding the functionality.

 

Thanks ​@Buddhika Kurera 

This helps a lot, can I ask a follow up to the above. 

 

If the requirement is 10 and the Multiple Lot Size is set 20 then an order will be placed for 20 units, even if the Min Lot Size is set to 15. Does the system take the Multiple Lot Size into consideration before the minimum (if the minimum as been set and not zero)?

Similar to the Max Lot Size example, is the Min Lot Size always considered secondary to the Max & Multi Lot size (if it has been set)

Hello,

Wanted to share insight how MRP code works when it comes to this.

After MRP discovers a net requirement, it applies the scrapping algorithm to it and hence the mrp planned supply can be greater than the net requirement.

mrp planned supply := Net requirement / (1 - (inventory part planning scrap factor/100))

 

  1. Then it checks if this raw mrp planned supply is less then min order qty
    • if it is, mrp planned supply gets adjusted
  2. Okay... then system takes the output from step 1 above and applies the multiple formula (if there is a multiple lot size > 0)
    • mrp planned supply := mul order qty * CEIL(mrp planned supply / mul order qty)
    • example: 20 * CEIL(35/20) = 20 * 2 = 40
  3. Then logic checks if there is any max order qty > 0
    • if there is, and the mrp planned supply is greater or equal to max size then system creates as many supplies of max order qty to fulfill the total mrp planned supply
  4. Then system checks if there is any remaining Mrp Planned Supply after step 3
    • if there is, then system applies same logic as in step 1 and 2 above

Hope this helps

-Mats

Thanks for the info above it is a great help.

Reply


Terms & ConditionsCookie settings