How a Global Manufacturer Finally Killed Their Seven-Spreadsheet Supplier Audit
Their procurement team was running supplier evaluations across 7 Excel files, 4 email threads, and an average of 6 weeks per cycle. Then they found out they had a critical supplier heading toward failure — and nobody had flagged it.
"We weren't managing suppliers. We were managing files. By the time we spotted a problem, it was already a crisis."
Head of Procurement · Tier-1 Component ManufacturerThe situation
The company operates a network of 80+ active suppliers across components, raw materials, and logistics. Every quarter, their five-person procurement team ran a full supplier performance review — a process that had evolved over years into something nobody had designed and everyone had inherited.
Each evaluator maintained their own Excel file. Each business function — quality, logistics, finance, operations — sent scores by email. Someone in procurement consolidated everything manually into a master file, chased missing responses, reconciled conflicting formats, and eventually produced a PDF report that was circulated via email and filed away.
Nobody had a live view of supplier health at any point in the process. The "current" picture was always weeks old.
The team estimated they were spending between 18 and 24 person-days per cycle on data collection and consolidation alone — work that produced no analytical value and delayed every decision that depended on it.
The moment that made the status quo untenable
In Q3, a critical sub-assembly supplier that had been scoring "adequate" across four straight quarterly reviews was flagged by a line manager — not by the procurement system — as having serious delivery reliability issues. When the procurement team investigated, they found the warning signs had been there in the raw data for two quarters. They just hadn't surfaced cleanly through the spreadsheet process.
The supplier required an emergency corrective action program that took three months to stabilize. The direct cost of that intervention — including expedited sourcing, production line adjustments, and management time — was estimated at €85,000. The reputational cost internally was harder to quantify.
"We realized we'd built a system that was very good at producing historical summaries and very bad at telling us what was actually happening right now."
Procurement DirectorWhat they were looking for
The brief for any solution was specific. They needed something that would:
Before vs. after
| ❌ Before EvaluationsHub | ✅ After EvaluationsHub |
|---|---|
| 7 separate Excel files per evaluation cycle | Single platform, all stakeholder input in one place |
| Email chains to chase missing scores (avg. 3 follow-ups per evaluator) | Automated reminders handle scheduling — no manual chasing |
| 6-week cycle from launch to consolidated results | 10 days average from launch to aggregated scorecard |
| Suppliers received results once per quarter, via email, with no response channel | Suppliers access their own portal, see scores in real-time, and can submit evidence or raise concerns directly |
| No automated threshold alerts — issues surfaced by accident | Automatic CAPA triggers when scores breach defined thresholds |
| Audit trail: a folder of emails and version-controlled Excel files | Full timestamped audit log, role-attributed, exportable for governance review |
| ERP data manually exported and cross-referenced | Live SAP data feeds directly into supplier scorecards |
The rollout
Implementation was phased over eight weeks. The first four weeks focused on configuring the scorecard structure, weighting logic, and stakeholder roles. The team chose to run a parallel evaluation cycle — one manual, one in EvaluationsHub — to validate that the platform outputs matched their expected results before going fully live.
Suppliers were onboarded through the self-service portal. The procurement team was clear that supplier access was not optional — visibility was a requirement for the relationship going forward, and the portal was the mechanism. Adoption among the top-40 supplier tier was close to 90% within the first full quarter.
One unexpected benefit: Supplier disputes about scores dropped significantly once suppliers could see not just their final score, but the weighted inputs from each business function. Transparency reduced friction — even when scores were poor.
The results
After three full quarterly cycles on EvaluationsHub, the team conducted an internal review of what had changed. The findings mapped across two dimensions: operational efficiency and risk posture.
The cost of the old way — quantified
These are conservative estimates based on a 5-person procurement team running quarterly evaluations across 80 suppliers, using industry-standard procurement salary benchmarks.
How we arrived at these numbers: Manual data collection estimate based on 18–24 person-days per cycle × 4 cycles × average senior procurement specialist cost of €650/day (EU benchmark). Crisis cost based on the company's own post-incident financial review. These figures are illustrative and will vary by organisation size, supplier base, and geography. EvaluationsHub does not guarantee specific financial outcomes.
Why spreadsheet-based evaluations carry structural risk
The operational cost is visible. The risk cost is harder to see until something goes wrong.
No early warning system
Threshold breaches are invisible until someone reads the final report — by which point intervention is reactive, not preventive. The window for low-cost corrective action is already closed.
Version control is not audit control
Spreadsheet version history doesn't tell you who entered which score, when, or why it was changed. In a regulatory audit or a dispute with a supplier, you have almost no defensible documentation.
Key-person dependency
The person who knows which file is current, where to find the weighting logic, and which evaluator responded late is a single point of failure. When they leave, the institutional knowledge goes with them.
GDPR and data control risk
Supplier performance data circulating across personal email accounts, shared drives with broad access, and uncontrolled file copies creates exposure that's difficult to remediate and harder to evidence.
Inconsistent weighting = unreliable rankings
When different evaluators apply different mental weightings to the same criteria, you don't have a scorecard — you have a collection of opinions. Strategic sourcing decisions made on this data carry hidden accuracy risk.
How EvaluationsHub addresses all of these
Automated threshold alerts, timestamped audit trail, role-based access, ISO 27001 certified infrastructure, configurable weighting logic — all in one platform, without requiring you to manage the security stack yourself.
See what your supplier data actually looks like
Most teams that switch to EvaluationsHub discover supplier issues they didn't know existed within the first evaluation cycle. Start a free pilot with your own supplier list — no integration required to begin.
★★★★★ 4.9/5 on G2 · ISO 27001 Certified · 200+ companies · GDPR compliant
