Supplier/Order Pattern Analyzer
Upload your purchase-order history as a CSV and compare each supplier's actual lead time against what you quoted. With a free account you'll also see your supplier concentration risk and a reliability ranking.
Concentration risk is calculated with the Herfindahl-Hirschman Index (HHI), the same measure competition authorities use: HHI = sum of each supplier's % share of total order quantity, squared. Below 1500 is considered low concentration, 1500–2500 moderate, and above 2500 high.
Supplier order analysis FAQ
Worked example of the HHI
If you buy from 4 suppliers with 40%, 30%, 20%, and 10% shares of total volume: HHI = 40² + 30² + 20² + 10² = 1600 + 900 + 400 + 100 = 3000 — high concentration, above the 2500 threshold. If instead you split purchases evenly across those same 4 suppliers (25% each), HHI = 4 × 25² = 2500, right at the border between moderate and high. More suppliers, and more evenly split volume, both lower the HHI.
My HHI is high — what should I do?
A high HHI doesn't necessarily mean you should switch your main supplier — sometimes it's the right call on price or quality — but it does mean a problem with that supplier (bankruptcy, a serious delay, a price hike) hits you hard because you have no short-term alternative. As a practical mitigation, qualify a second supplier for your most critical SKUs even before you buy from them, so you're not starting from zero if the main one fails you.
What does the reliability trend (improving / worsening / stable) mean?
It compares the gap between quoted and actual lead time on each supplier's most recent orders against their older ones. "Worsening" means that supplier is increasingly missing its quoted lead time — worth raising with them before it forces you to carry more safety stock. You need an order-date column to calculate this trend; without it, the tool can't determine it.
What if I don't have the same quoted lead time for every order from a supplier?
Enter the most recent or most representative quoted lead time as the "assumed lead time" — the tool compares each individual order against that value to calculate the gap. If the quoted lead time changed significantly partway through your history (say, after renegotiating terms), results will be more accurate if you only upload orders placed after the change.