Lead time is the amount of time required to replenish a product in your warehouse, from the moment a purchase order is generated in the system, to the moment it is on the shelf and ready to sell. The average lead time is stored for each product in Warehouse/Item F/M. It is updated each time new product is received in PO Receipt Entry. Lead time, expressed as a number of days, is used to calculate a product’s order point, an indicator of “when to buy.”
Order Point = [Usage Rate * (Average Lead Time Days / 28)] + Safety Allowance
Lead time days are also used to calculate safety quantity when safety is defined in Warehouse/Item F/M as a percentage.
There are times when lead time on a particular receipt should be ignored and not factored into the average lead time. Generally, this occurs when a product’s lead time varies significantly from the average, and, if factored into the average, could result in an order point that is too high or too low. Other examples of receipts where you might ignore the lead time include:
Lead time is calculated by adding the last lead time and the most current lead time and dividing by two. If the next-to-last recorded lead time is over six months old, the last lead time is used (no averaging is performed) or by calculating lead time based on a user-defined number of receipts, over a user-defined number of months.
Vendor Approved Replenishment Path (ARP)
Transfer Approved Replenishment Path (ARP)
Receipts Used to Calculate Lead Time
Abnormal Lead Time Parameters for ARP Vendors
Abnormal Lead Time Parameters for ARP Transfers
Lead Time is part of the calculation for Order Point, and in cases where very long lead times occur, they can cause the order point to grow to unrealistically high levels. Similarly, if average lead time ends up being a very small number, it can lead to meaninglessly small order points.
To prevent either of these situations from occurring, you can establish a minimum and maximum lead time to use in the order point calculations.
Use a Minimum / Maximum Days for ARP Vendor Lead Time | Indicates whether to apply a minimum and maximum lead time |
Lead Time Minimum Days | Smallest # of days to use for lead time from a vendor |
Lead Time Maximum Days | Largest # of days to use for lead time from a vendor |
Same as above except for warehouse transfer ARPs.
Use a Minimum / Maximum Days for ARP Warehouse Lead Time | Indicates whether to apply a minimum and maximum lead time |
Lead Time Minimum Days | Smallest # of days to use for lead time from a warehouse |
Lead Time Maximum Days | Largest # of days to use for lead time from a warehouse |
For calculated lead times to be accurate, you need to have a reasonable number of recent receipts. These parameters establish the limits on how and when to calculate average lead time.
The first two indicate how many receipts you must have within a given number of months in order to be able to calculate the average lead time.
Assuming those minimums are reached, the next set of values indicate how many receipts you can use over the given number of months for the calculation.
# Receipts Required | Must have at least this # of receipts |
Number of Months | The # of required receipts must be within this number of months preceding |
Number of receipts to use | This is the maximum number of receipts to use for the calculation |
Number of Months | This is the maximum number of months back a receipt can be to be used in the calculation |
For calculated lead times to be accurate, you also need to set parameters to determine if a new lead time is normal or abnormal. These parameters establish what lead time information is used to calculate average lead time.
% of Average Too Low field | the percent difference below the existing average lead time for a new lead time to be considered abnormal. |
% of Average Too High field | the percent difference above the existing average lead time for a new lead time to be considered abnormal. |
Same as above except for warehouse transfer ARPs.
% of Average Too Low field | the percent difference below the existing average lead time for a new lead time to be considered abnormal. |
% of Average Too High field | the percent difference above the existing average lead time for a new lead time to be considered abnormal. |
See Also
Replenishment Parameter Maintenance Procedures