Blog · Procurement and supply chain · Supply chain
How a supply chain team finds single-source parts, measures inbound concentration by supplier per site and watches supplier performance trends from goods receipts and the supplier master, with the reconciliation to goods received that makes the exposure figure defensible.
Every supply chain knows its important suppliers. Few can put a number on what a month without one would cost, per site, or list the parts that depend on exactly one qualified source. The receipts and the supplier master have both. This guide sets out the continuity roll-up: single-source parts, inbound concentration by site, and the performance trends that warn before a supplier fails.
Per part:
Qualified sources = suppliers on the approved list for the part Used sources = suppliers with receipts in the window Single-source = qualified sources = 1, or used sources = 1
Per site:
Concentration = the largest supplier's share of the site's inbound value, against a threshold
Per supplier, month on month:
On-time = receipts on or before the promised date ÷ receipts Quality = receipts without rejection ÷ receipts
Supplier identifiers only.
goods received = Σ sites = Σ suppliers = Σ parts
The by-supplier equality catches a supplier under two identifiers. The by-part equality catches a part renumbered in the master mid-year.
One site, one quarter.
| Supplier | Inbound value | Share | Single-source parts | On-time, this quarter | On-time, prior |
|---|---|---|---|---|---|
| Supplier 1042 | $4.1m | 58% | 14 | 91% | 96% |
| Supplier 0377 | $1.6m | 22% | 3 | 97% | 97% |
| Supplier 2210 | $0.8m | 12% | 0 | 88% | 89% |
| Others | $0.6m | 8% | 2 |
One supplier holds 58 percent of the site's inbound and is the only source for fourteen parts, and its on-time rate has slipped five points in a quarter. That row is the finding. The exposure, at annual spend, is $16m; at the cost of a month's stoppage on the fourteen parts, whatever the site's dependency table says, which is the number the board understands.
Qualified list not maintained. A supplier qualified years ago and never used counts as a second source that does not exist in practice. Report qualified and used separately.
Parts at the wrong grain. Concentration measured on a category with fifty parts hides that one part inside it has one source. Measure single-source at the part.
Promised dates missing. Receipts without a promised date cannot produce an on-time figure. Count them and get the date onto the purchase order.
Intercompany suppliers. A sister plant appears as a supplier with high concentration. Flag intercompany and report it separately.
Mapped once, the receipts export and the supplier master produce the exposure per site, the single-source list and the performance trends every month, reconciled to goods received. Covirage builds this from the export as it is. The supply chain page describes the setup, and you can upload a sample receipts export and see the roll-up on your own rows.
Compliance asks whether spend went to the contracted supplier. Continuity asks what happens if that supplier stops. A fully compliant category can be entirely single-sourced, and consolidating spend to fix compliance makes concentration worse. They belong on the same page for that reason.
Two ways, and both are useful: annual spend on the part, which says how much is routed through one supplier, and the cost of a month without the part, which says what a failure costs. The second needs a production or service dependency the supply chain team already knows.
On-time delivery from promised against received dates, and quality from returns and rejections where they are recorded. Month on month, per supplier, a slide in either is the early signal.