Skip to main content

Lead time analysis

This article explains the vendor lead time analysis, available to subscribers of the insights package

Updated over a week ago

Overview

The world is ever changing and supply chain disruptions have become the unexpected norm. To help you navigate and mitigate, we built a dashboard to measure supplier's on time performance, enabling our users to adjust the system lead time to actual lead times where needed to ensure timely ordering.

The supplier performance can also help our users focus their time on managing the suppliers that need to shape up, or highlight areas in need of supply base diversification. Selecting alternative suppliers if possible in locations where logistic lanes might run more smoothly at a given point in time.

Lead time analysis

The lead time analysis is found under the Vendors tab.

Vendors > select a supplier > Lead time analysis

After clicking Vendors, you'll be greeted with a vendor overview page from where you'll need to click on a vendor name.

This opens up the vendor details page, which has two parts:

  1. Overview (opens by default)

  2. Lead time analysis

Now click on the Lead time analysis

Welcome to the Lead time analysis dashboard

The dashboard is split into three parts:

  1. KPI's: On top the user has four KPI’s showing calculations for the selected vendor

  2. Performance chart: in the middle, the chart shows historical delivery performance of the vendor:

    1. red indicates the system lead time

    2. yellow is the calculated average

    3. purple shows the actual deliveries

  3. Historic delivered purchase orders (PO's) included in the lead time analysis calculations

    1. by default all delivered PO's within the time frame contribute to the calculations.

    2. the user can toggle out PO's that deviate and should not be included.

KPI’s

The user is greeted with four KPI's (key performance indicators) for the chosen supplier. The data reflects the time frame displayed in the "number of months"

Lead time analysis KPI's explained

All values are based on the selected vendor

Lead time days

Current lead time value in the system, ERP or overwritten in AGR on the chosen vendor

Average Lead time

The average measured lead time on the purchase order level, in last 12 months (settings, default). Or as chosen in the Number of months dropdown on the top of the page

[order date - arrived physical date]

On time deliveries

Percentage of on time deliveries, on the purchase order level.

Settings: Months included in the calculation (default 12 months).

Settings: first order date, last or ignore with multiple

Number of deliveries

Count of total number of deliveries in last 12 months (settings, default).

Or the number of months chosen in the dropdown on the top of the page

On time delivery calculations

Status / Ranking

Calculation method

On Time Deliveries

Number of deliveries where order date + stated lead time match actual delivery date (+/- buffer that is configured globally)

Early Deliveries:

Number of deliveries that have delivery time < than order date + stated lead time

Late Deliveries

Number of deliveries that have delivery time > than order date + stated lead time

List of Purchase orders

At the bottom of the page, the user can see a list of all purchase orders that contribute to the lead time analysis.

These are received purchase orders within the time frame chosen in settings (default is 12 months), or the number of months selected at the top of the page.

By clicking on the expand icon > each purchase order is expanded so the user can view the individual purchase order lines.

Each line is calculated individually against the item lead time, if it exists, else each line is measured against the vendor lead time.

Note the lead time analysis results are calculated against a single Purchase order on the header level, in line with the settings chosen, where the default calculation method is “Use first delivery date

Settings

Navigate to the cogwheel icon > settings

General > Lead time analysis (scroll down to the bottom)

These are global settings, controlling calculations in the vendor overview and the Lead time Analysis.

Lead time & vendor settings

Description

On time buffer days

An option to add buffer to the on time measurement: system lead time vs actual lead time. Often used for estimating internal inbound receiving time, days after arrival before it has physically arrived in the receiving site.

Lead time calculation method

The lead time analysis is measured on the Purchase order as a whole, the user can choose to measure against the first delivery, last delivery or to ignore orders with multiple delivery dates.

Number of months for calculations

Time horizon to include for lead time analysis, impacts KPI's for Purchased value, number of deliveries, On time delivery performance, Avg lead time, min & max lead time

Number of purchase orders

A sub rule after the Number of months for calculations.

In case it helps to minimize the number of purchase orders displayed in the list below the lead time analysis.

Stock holding percentage

Calculates the column: stock holding cost.

% cost of the current stock value.

By default the value is set to 0, prompting the user to insert their average stock holding cost percentage for the company.

Stock holding cost should cover: cost of capital, insurance, housing, forklifts, electricity, warehouse staff (servicing), risk and admin for example.

Many companies know this value as rough estimate, often around 25-20% per year

Lead time analysis Example of using different settings:

Use first delivery

The List of Purchase orders below has the default calculation method on “Use first delivery date” from Settings to control “Delivery date” and “Actual lead time”.

Here the supplier get's a perfect score as each of these delivered purchase orders had a first delivery within the stated lead time +/- buffer days

Use last delivery

Now for the same list of purchase orders, we use the calculation method "latest delivery date" from settings to control “Delivery date” and “Actual lead time”, which has now turned PO 11 red and measuring 21 days as the actual lead time. In this case only 1 product was delivered later than 12 Nov while others were on time.

Expanding the PO, will show the purchase order lines, here we can see that one line was delivered on November 26th while the others came in on November12th.

Ignore orders with multiple deliveries

The third setting option is applied in the screenshot below “Ignore orders with multiple deliveries”, We now see that PO 11 is gray and the "use" button is toggled out. Because PO 11, had more than one delivery date it does not contribute to the resulting KPI's graph and averages.

Did this answer your question?