The lead time analysis provides a view of all the lead times available to apply to an item. It also calculates a supplier or work orders actual to committed lead time and on time delivery performance.
Running a Lead Time Analysis
- Select all items or select a few items by filtering the selection. The most common filter is to select items by supplier from the Vendor drop down / multi-select group.
- After filtering the data, make certain the items you wish to analyze have been selected by clicking the "Select all" button. You may also run all items by not filtering the data and clicking on "Select All."
- Click "Run Analysis" to commence the lead time analysis.
- Once the analysis is completed, you can download the results as an excel by clicking on the excel "Download Report" icon.
Lead Time Analysis Column Description
The lead time analysis provides the following additional information and analysis results related to lead time performance. The yellow highlighted cell designates which lead time value is being used in DemandCaster. All values are in calendar days.
- View: Click to view the items requirement planning details
- Number or Name: The item name or number depending on the value to use in system settings. Placing your cursor over the value will show the item name or number depending on the primary view option chosen.
- Location: If the DRP module is enabled, the location of the item. This is a physical geographic location and not an inventory location within a warehouse.
- Supplier: The items designated supplier. If the field shows the value "Unknown" that typically means that the items is an internally produced item. In DRP, the supplier may be another location that serves as the source for the destination location or the same as the location if the item is manufactured in the location.
- Total Lead Time: Calculated as the selected Lead Time (or Order Lead Time) in days plus Transfer Lead Time plus Lead Time Cushion (which is a value that is based on a percent of lead time). This value is what is used for the reorder point calculation.
- Lead Time Cushion: The number of days beyond the lead time to be added to accommodate temporary increases in lead time. This is a value that is entered as a percent and then calculated as days.
- ERP Lead Time: This is the lead time that is pulled from your ERP. This is the normal time from the issuance of a purchase or start of a production to receipt or completion. This is the lead time period which demand is offset as it explodes a bill of material requirement.
- Calculated: This is the average actual lead time in days that is determined by calculating the difference between each orders order date and receipt date over the last 12 months. Please note that for blanket orders this calculation will not be accurate since the order date would be the same for all line items in the blanket order. As such, we recommend, if available, pulling the line item release date.
- User Defined: The user may enter a lead time directly in DemandCaster. This overrides the ERP Lead Time value while providing the same functionality.
- Order Lead Time (days): The number of calendar days from order to expected receipt. In other words, the lead time period which we use to define the first bucket with a Suggested Order. This is used primarily in production to set an order time that is different than the production lead time (ERP or user defined lead time) to allow the components to explode at the shorter production lead time. The value is applied only if the time is greater than the ERP or user defined lead time. Order lead time is used for all formulas.
- Transfer Lead Time (days): Calendar days to transfer from source to destination. For purchased items this may be used to define the transit time from the supplier to your dock.
- % On Time: This calculates the number of orders that were received at the assigned due date. In system settings the user may enter a value in days that act as a buffer for on time. For example, entering a value of 1 will consider on time those orders arriving either 1 day earlier or later than the due date.
- % Early: This calculates the number of orders received prior to the due date based on the due date buffer.
- % Late: This calculates the number of orders received after the due date based on the due date buffer.
- Avg. Days Late: Calculates the average days beyond the lead time the orders arrived. This value is used when calculating safety time.
- Clicking on the icon next to the item number, takes you to the item detail where you can open the Lead Time analysis detail in the General Item Analysis tab as described below.
View Item Lead Time Analysis Detail
- Click the Item Options tab
- Clicking the “Lead Time” tab opens the detail of the lead time settings.
- You can change the lead time of the item by clicking on the appropriate radio button or enter the desired value in user defined field. To learn more, read the article How to change the lead time of one or many items
- Click (Open) to view the basis of the "Calculated" lead time