Supplier & Inventory Performance

Links supplier delivery performance to stock health across three distribution centres · Jan–Dec 2025

Synthetic data Source on GitHub

From To Category Location Supplier

OTIF

–

Stockout rate

–

Days of cover by class ·

Excess stock value ·

–

Supplier scorecard

Click a supplier to open its purchase order lines. Red = below 85% OTIF or lead-time variance above 2 days.

Supplier	PO lines	Spend	On time	In full	OTIF	LT var (d)	Stockout

OTIF vs stockout rate by month

Supplier OTIF (left axis) against the share of SKU-location-days out of stock (right axis). December stockouts also reflect the seasonal demand peak.

At-risk SKUs ·

Projected cover = (stock on hand + open orders) ÷ forecast daily demand. A SKU is at risk when that is shorter than its supplier's promised lead time. Bars are coloured by supplier status.

Portfolio project by Chiamaka Ikpo. All data is synthetic and generated by scripts/generate_data.py. KPI definitions follow the KPI dictionary: OTIF = received lines on or before the promised date and in full ÷ received lines · Lead-time variance = standard deviation of days late · Stockout rate = SKU-location-days with zero stock ÷ all SKU-location-days · Excess = stock above the class maximum cover, at unit cost.