Let me tell you about the Tuesday morning last Black Friday that made me build our supplier scorecard.
It was 6:30 in the morning, still dark outside, and the dock already had 14 trucks lined up. Three suppliers' freight arrived at once, and every single ASN was wrong. Supplier A said 200 cartons; 160 showed up. Supplier B's cartons were labeled with last month's lot codes. Supplier C never sent an ASN at all — the driver was standing at the door with a handwritten delivery note. My eight-person receiving crew worked until 11 that night to untangle it.
Sitting on the dock afterward, I had exactly one thought: which of these three suppliers is actually the worst? I couldn't answer — gut feel from the crew wasn't evidence.
That's the morning our supplier scorecard was born.
How the Problem Surfaced: Bad Freight Nobody Logged, Good Freight Nobody Praised
Here's the embarrassing part. Our warehouse runs 200-plus people. We've had a WMS for years, and every transaction is in the system. But ask me a simple question — over the past year, which supplier delivered on time most consistently? Whose freight arrived clean and ready to put away? Nobody could answer.
The data was all there — ASN records, arrival timestamps, QC logs, variance reports — scattered across four places. Nobody had ever stitched them into one table. So suppliers raised prices every year and we swallowed it; freight arrived like garbage and all we could do was yell at the receiving crew — who, to be honest, did nothing wrong.
At the end of 2024, finance pulled a number for me: the labor cost of handling receiving exceptions added up to about 1.5 full-time heads a year. That was the day I decided the supplier scorecard was job number one for 2025.
The Three Metrics in a Supplier Scorecard, and Where to Pull Them from the WMS
Don't build a scorecard with fifteen metrics. Three is enough — every extra metric adds half an hour of arguing at the review meeting.
First, OTD — on-time delivery rate. Loads arriving within the agreed ASN date or time window, divided by total loads. Every ASN in the WMS has an expected arrival time; receiving confirmation stamps the actual one. Subtract, and every late or early arrival shows up. One thing we learned: early doesn't count as on time. Arriving two days early and clogging the dock with nowhere to unload still costs you points — the receiving lead settled it with one sentence: when the early truck's driver is cursing at the gate, whose fault is it? The supplier's.
Second, inbound quality rate. Batches passing QC spot-check inspection divided by total batches. Pulled from the QC module's inspection records. We score it by batch, not by carton — one damaged carton in a load is a different problem from a load where every label is wrong. Any supplier whose batch pass rate drops below 80% basically has no packaging or quality control at all.
Third, ASN accuracy. Loads where the ASN's quantities, SKUs, and lot codes match the physical freight exactly, divided by total loads. This is the metric that hurts the receiving crew the most — a wrong ASN breaks the whole flow: the system won't reconcile, someone counts cartons by hand, and the dock turns into a parking lot. The data comes straight from the WMS receiving variance report — zero manual entry.
The definitions of these three metrics follow standard industry KPI conventions (warehouse KPI references like those published by ISM are a good cross-check); our data extraction is our own, but the definitions line up with the common standards. As for the targets — what counts as an "A" for OTD — ours are example targets. Every warehouse's volume and product mix is different. Copy the method, not our numbers.
The ABCD Grading: What the Weighted Scorecard Looks Like
Three metrics, unequal weights. We tried equal weighting for one quarter and scrapped it — ASN accuracy hits receiving efficiency far harder than on-time rate does.
| Metric | Weight | A (example) | B (example) | C (example) |
|---|---|---|---|---|
| OTD on-time delivery | 30% | ≥95% | 90–94% | 80–89% |
| Inbound quality rate | 30% | ≥98% | 95–97% | 90–94% |
| ASN accuracy | 40% | ≥97% | 92–96% | 85–91% |
Weighted composite: 90+ is A, 80–89 is B, 70–79 is C, below 70 is D. Again, these are example targets — we run a fast-turn consumer goods warehouse; adjust the bar to your product mix.
The moment the grades came out, the effect was immediate. In Q1 2025, across our 40-plus core suppliers: 9 A's, 21 B's, 8 C's, 3 D's — and all three D's were procurement's long-standing "relationship" suppliers: cheap pricing, years of history. The data went up on the screen and the room went quiet.
Now here's the counterintuitive call, and I want my fellow warehouse folks to hear this clearly: A-grade suppliers usually quote 3–5% higher than D-grade ones. But on total cost, the A suppliers are the cheapest. A D-grade supplier's "cheap" price is paid for with your receiving labor, your dock turns, and your stockout risk. We ran the math on one D-grade packaging supplier: the extra labor and rework it caused us in a year equaled 12% of its quoted price. That 12% never shows up on an invoice — it hides inside your productivity.
How to Run the Quarterly Review with the Supplier Scorecard on the Table
You've got the scorecard. How do you run the QBR — the quarterly business review? Here's our fixed format, once a quarter. Every C-grade or below supplier gets a session; we also invite two A suppliers for recognition.
Who attends: from our side, the warehouse manager (me), purchasing, and QC. From the supplier's side, it must be someone who can make decisions — a sales rep who can't commit to a fix is useless in that room. Four agenda items, one hour, done:
Item one: show the data. Put the supplier's three metric trend lines for the quarter on the screen — the lines speak for themselves. Item two: hear them out. Give the supplier 15 minutes on causes — sometimes it's genuinely our fault, like when we changed a receiving time window without telling them. Item three: set corrective actions. C and D suppliers must leave the room with fixes defined — what, who, by when — and we track them. Item four: set next quarter's targets. Make them specific: ASN accuracy from 81% to 90%, not "try harder."
At our Q1 2025 review, one D-grade corrugated box supplier had scored D two quarters running. We gave them 60 days and three corrective actions, all in the minutes. Sixty days later: ASN accuracy had crawled from 55% to 63%, and one action never materialized. We switched. The new supplier quoted 4% higher but runs 97% ASN accuracy, and receiving overtime dropped by roughly 20 hours a month. Purchasing winced at the 4% at first; three months later they said it was worth it.
And one honest observation: the scorecard isn't a penalty ticket — it's leverage at the negotiating table. We used to negotiate pricing with our voices; now we negotiate with data, and suppliers respect it more. One B-grade supplier saw itself stuck at B and volunteered to send someone to shadow our dock for three days to find the problems. You can't buy that kind of cooperation.
Running the Numbers: What One D-Grade Supplier Really Costs You in a Year
Let me use ASN accuracy to show you our warehouse's real math (an example calculation — plug in your own numbers).
One D-grade supplier, 60% ASN accuracy, 50 loads a month. A clean load takes 20 minutes to receive; a bad-ASN load burns an extra 40 minutes in manual reconciliation. 50 loads × 40% exception rate × 40 minutes = 800 minutes, about 13.3 hours a month. At a fully loaded receiving labor cost of $25 an hour (example), that's 13.3 × 12 × 25 = $3,990 a year.
And that excludes the hidden costs: the dock tied up by problem freight while trucks queue behind it; variances that never reconcile, so pickers hunt all over the building for stock; overtime rates doubling in peak season. That $3,990 is just the visible tip.
So whenever someone tells me "switching suppliers is such a hassle," I put this math on the table. One hassle, a year of peace.
Three Reminders for My Fellow Operators
First, don't overcomplicate it on day one. Three metrics, four grades, run it for two quarters. Add more metrics and the people pulling the data burn out first — then the scorecard dies.
Second, the data must come from the system automatically — never let anyone fill in a form by hand. A hand-filled scorecard deforms within three months. The person filling the form and the person being scored will eventually "negotiate" a prettier number.
Third, give D suppliers an improvement period before you switch. Some are genuinely bad; some just never heard your standards clearly. Talk once, put the standards on the table — then switch with a clear conscience.
A supplier scorecard comes down to one sentence: stop managing suppliers by gut feel. Feed the receiving data in, and the grades come out by themselves. Every dollar saved in receiving drops straight to the bottom line.
By Chen Feng, Warehouse Operations Manager
