Procurement supplier lead-time distribution calculator

Calculate nearest-rank median completed lead time and nearest-rank 90th percentile completed lead time with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use nearest-rank median completed lead time and nearest-rank 90th percentile completed lead time to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Orders: ID, order date, full-receipt date or none
A,2026-10-01,2026-10-05 B,2026-10-01,2026-10-08 C,2026-10-10,none
As-of date
2026-10-20
Observed day basis: working or calendar
working
Working weekdays: Monday 1 through Sunday 7
1,2,3,4,5
Excluded working dates, comma-separated, or none
none
Nearest-rank median completed lead time (days)
2
Nearest-rank 90th percentile completed lead time (days)
5
Mean completed lead time (days)
3.5
Completed orders
2
Orders not fully received
1
Largest ongoing age on same day basis
7

Try another scenario

Orders: ID, order date, full-receipt date or none
A,2026-10-01,2026-10-05 B,2026-10-01,2026-10-08 C,2026-10-10,none
As-of date
2026-10-20
Observed day basis: working or calendar
calendar
Working weekdays: Monday 1 through Sunday 7
1,2,3,4,5
Excluded working dates, comma-separated, or none
none
Nearest-rank median completed lead time (days)
4
Nearest-rank 90th percentile completed lead time (days)
7
Mean completed lead time (days)
5.5
Completed orders
2
Orders not fully received
1
Largest ongoing age on same day basis
10
Calculation method

Calculation method

Nearest-rank median completed lead time (days)

Count from the day after ordering through receipt day, then select rank ceil(0.5×n).

Nearest-rank 90th percentile completed lead time (days)

Select rank ceil(0.9×n) from completed observations only.

Mean completed lead time (days)

Average completed observations, keeping ongoing orders separate.

Completed orders

Count valid full-receipt dates on/before as-of.

Orders not fully received

Count none receipt dates; these are censored observations rather than zero lead times.

Largest ongoing age on same day basis

Count order-to-as-of age for incomplete orders under the selected calendar convention.

Symbols and units
a
Orders: ID, order date, full-receipt date or none
b
As-of date
c
Observed day basis: working or calendar
d
Working weekdays: Monday 1 through Sunday 7
e
Excluded working dates, comma-separated, or none

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A completed-order distribution with ongoing ages shown separately. This is not a censored-data survival estimate or a forecast of future supplier lead time.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

OECD: procurement performance and contract-record background; calculations follow the displayed rules ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.