Lesson 17 of 20
Build a Weighted Vendor Ranking from Three Data Sources
Internal Reporting & Value-Proof · Packaging / CPG
Synthetic case data — evidence from real ChatGPT, Claude, Gemini and Copilot runs.
📥 Download the practice file: case-file.txt — three data sources for a fictional CPG packaging category: a Q1 delivery log (with a free-text Notes column), four quality-incident emails, and a three-plant stakeholder survey. Paste into any AI tool to follow along.
The quarterly scorecard ranked the contamination supplier #2 — "Approved, monitor their quality trend." Every number in it was correct.
Two of every twenty-four rolls of shrink wrap arrived with metal shavings pressed between the layers. Plant quality quarantined the rolls at incoming inspection and filed QIR-2026-018: "contamination near-miss," escalated to MAJOR. Metal fragments, one shrink tunnel away from finished consumer packaging. The supplier took four days to acknowledge it and still has not supplied a root cause or CAPA.
That supplier — PeakForm — shows 88.9% on-time delivery and three quality incidents. The scorecard counts the incidents, averages the survey, and ranks PeakForm second. The arithmetic checks out. The ranking does not survive a quality director reading it.
This lesson is about the gap between a scorecard that counts and one that weighs. You will take three messy sources, brief an AI to build a weighted scorecard that treats a contamination near-miss differently from a cosmetic variance, and compress the result into a ranking a director can act on Thursday morning.
You’ve read the free three. The other seventeen are where the misses live.
The first lessons show what a general-purpose AI catches on a procurement task. The rest show what it misses — the unit conversion that survives an expert prompt, the two clauses it lists but never connects, the table that contradicts its own arithmetic. That gap is the job.
Full course access
For individual practitioners
- ✓All 20 lessons, permanent access
- ✓Practice case files for every lesson
- ✓Real ChatGPT / Claude / Gemini / Copilot evidence
- ✓New lessons included as they ship
Live team workshop
For procurement teams and their leaders
- ✓Live 2-hour workshop, run for your team
- ✓Built on the same 20-lesson curriculum
- ✓Your categories, your workflows
- ✓Led by a practitioner running AI adoption inside a Fortune 500 procurement organization