The Update Demand Forecast program updates each product's lead time, based on lead time parameters set at the system, buy line, or product level. Lead time is the number of days it takes for you to prepare and process the purchase order, the vendor to ship the material, and your warehouse to receive the material.
Lead time parameters include the following:
Lead Factor - Defines the maximum number of processed purchase orders in the forecast period.
Minimum Lead Samples - Identifies the minimum number of processed purchase orders in the forecast period.
Default Lead Time Days - Defines the default lead time set at the buy line and system level.
Note: The system only checks the transfer order cycle when determining lead time on child branches in a central warehouse.
The system uses a Lead Time Variable in many calculations, such as the safety stock:
If LT < 1, then LTSD = 0
If LT 1 to 15, then LTSD = (LT + 7) * HRSC
If LT 16 to 60, then LTSD = ((LT/2) + 15) * HRSC
If LT 61 or higher, then LTSD = ((LT/4) + 30) *HRSC
Note: LT = Lead Time, LTDS = Lead Time Safety Days, HRSC = Hits Related Safety Coefficient
In addition to the lead time variable, the system uses the following steps when calculating the lead time:
In order to calculate lead time, the system checks for overrides. Overrides can also be set at the system, buy line, or product level. For example, your vendor calls you to tell you they are snowed in and it will take an additional three days to get the items to you. You can use the override settings to change the lead time for those items.
The system makes several checks to determine the lead time:
The system first checks for a lead time override at the buy line level or the product level.
If the product is... | Then... |
in a buy line | If an override lead time is set in Buy Line Maintenance or Override Lead Time Maintenance, the system checks for an expiration date:
If an override lead time is not set at the buy line level, then the system checks for a lead time override at product level. |
not in a buy line | check for an override lead time at the product level. |
You can set a manual override in the Lead Days field in Forecast Parameters Maintenance, or in the Ovrd LT Days column in Override Lead Time Maintenance. Setting a value in one field or column causes the same value to display in the other field or column.
Is an override set at the product level? | Then... |
Yes | check for an expiration date:
|
No | check the Lead Factor field in the Product Forecast Parameters window to determine how the system calculates the lead time. |
The Lead Fctr field in Forecast Parameters Maintenance controls how the system calculates the lead time for the product.
If the Lead Factor field is set to... | Then... |
null or blank | the system uses the Lead Factor in the Buy Line Maintenance window. |
0 | the system checks for a value in the Lead Days field:
|
> 0 | the system determines the lead time by checking a sample of most-recent purchase orders. For more information, see Determining the Range of Purchase Orders to Use below. |
If there are no overrides at the product or buy line level, the system checks for a minimum and maximum number of purchase orders to sample for the lead time.
Because recent data is more accurate for estimating lead times, the system checks the lead time derived from recent purchase orders in the forecast period for the product. The system checks a range of purchase orders to derive an accurate median lead time value using the minimum samples up to the lead factor. If there are insufficient purchase orders within the forecast period, the program resorts to a default lead time. For more information, see How Standard and Median Forecasting Works and Entering Forecast Period Parameters to determine your forecast periods.
The system makes several checks to determine which range to use:
Determine the minimum number of purchase orders in the forecast period to use in calculating a product's lead time. If the Minimum Lead Factor field in the Product Forecast Parameters window is set to null, then the system checks:
If... | Then... |
product is in a buy line | use the value of Minimum Sample in Buy Line Maintenance to determine the minimum number of purchase orders to use for calculating lead time. |
product is not in a buy line | use the value of the |
Otherwise, the system uses the value of Minimum Lead Factor as the minimum number of purchase orders to use for calculating lead time.
Determine the maximum number of purchase orders in the forecast period to use in calculating a product's lead time. If the Lead Factor field in the Product Forecast Parameters window is not 0, then the system checks:
If the Lead Factor is ... | And the product is in a buy line... | And the product is not in a buy line... |
null or blank | if the Lead
Factor in the Buy Line Maintenance window is null or 0,
lead time is equal to the value of the otherwise, use the Lead Factor in the Buy Line Maintenance window to determine the number of purchase orders within the forecast period to use for calculating the product's lead time. | use the value of the |
Otherwise, use the value of Lead Factor in the Product Forecast Parameters window as the maximum number of purchase orders to use for calculating lead time.
The system then calculates a final lead time based on the determined range of purchase orders. After determining the minimum and maximum samples of purchase orders to check, the system calculates the median lead time for the product.
Compare the number of purchase orders in the forecast period with the minimum lead samples and lead factor parameters to be used for the product:
If the number of purchase orders in the forecast period is... | Then... |
less than the minimum lead samples | if the product is in a buy line, the lead time is equal to the default lead time the system calculates and displays in the Lead Factor field in the Buy Line Maintenance window. if the product is not
in a buy line, the lead time is equal to the value of the |
equal to the minimum lead samples | calculate the lead time days using a number of purchase orders equal to the minimum lead samples. |
more than the minimum lead samples but less than the lead factor | calculate the lead time days using the available purchase orders within the forecast period. |
equal to or greater than the lead factor | calculate the lead time days using a number of purchase orders equal to the lead factor. |
Note: The values selected for the lead factor and minimum lead samples can be determined at two different levels. For example, the lead factor can be determined at the product level and the minimum lead samples can be determined at the buy line or system level.
Calculate and record the lead time of the selected purchase orders:
Purchase Order Lead Time = Purchase Order Create Date - Purchase Order Receive Date
Select the median lead time.
This value is the calculated lead time entered in the Lead Days field in Product Forecast Parameters.
See Also: