This page teaches how to build a complete vendor base management worksheet, for a domestic buyer or brand-side merchandiser who has learned each individual skill in this course: seeing what a vendor base decides (Lesson 1), qualifying a new supplier (Lesson 2), segmenting by performance (Lesson 3), and deciding on a second source (Lesson 4). A complete worksheet does not replace any of those steps; it draws their own results onto one page, so a buying committee can see the whole vendor base's own status at a glance before a decision is made.
A buyer who keeps each check in a separate document, a spend list here, a qualification note there, a performance comparison somewhere else, forces every reviewer to reassemble the picture from scratch before any decision. Without one complete worksheet, a vendor base review takes longer than the decision it is meant to support, and pieces of evidence get missed simply because they live in different places.
You need: Lessons 1.1 through 1.4 of this course; this lesson assumes you can already run each check on its own.
By the end of this lesson you can:
Not covered here: the individual skills themselves, covered in full in Lessons 1 through 4; this lesson only covers assembling them.
| Term | Meaning |
|---|---|
| Vendor base | The full set of suppliers a buyer manages together as a system, rather than one relationship judged on its own. |
| Qualification file | The record of every check run on a candidate factory, kept as part of the vendor base once that factory is added to it. |
| Vendor performance segment | A group a vendor is placed into within a vendor base, based on its measured delivery and quality record rather than how long it has been used. |
| Value at risk | The share of a style's own order value that would be exposed if its single supplier failed to deliver. |
| Complete vendor base view | A single working document that draws a vendor base's own overview, qualification status, performance segments, and second-source decisions together for one review. |
Each earlier lesson in this course produces its own working record: a vendor base overview showing each vendor's own share of spend, a qualification file for every vendor that joined the base, a performance segment for every vendor with enough order history, and a second-source decision for every single-sourced style worth reviewing. A complete vendor base view does not recalculate any of these; it assembles their own current results in one place, so a single reviewer can see the vendor base's own full status without opening four separate documents.
| What can differ | The shapes you meet | Why it matters |
|---|---|---|
| Domestic hybrid vs. export MTO | A domestic hybrid buyer like Cedar & Co. updates its worksheet continuously as reorders and forecasts change; an export MTO buyer typically refreshes it once per season around commitment | A hybrid buyer's worksheet needs more frequent updates to stay accurate between committee reviews |
| A small vendor base | A vendor base with only two or three vendors can fit all four checks on one simple page | Fewer vendors makes the assembly step quick, but does not remove the need for all four checks |
| A large vendor base across product families | A vendor base spanning apparel, socks and hosiery, and home textiles needs the worksheet organised by category, not just by vendor | The same four-check structure applies per category; combining categories on one page without labels hides which check belongs to which vendor |
| A worksheet with a stale segment or missing qualification file | A vendor added months ago has no segmentation review yet, or a long-standing vendor's qualification file was never created before this course's practices began | A gap like this should be flagged and filled, not hidden by leaving that vendor's row blank |
| Product families | The same four-check assembly applies whether the vendor base covers apparel, socks and hosiery, or home textiles | The specific figures differ by product family; the structure of the complete worksheet does not |
Cedar & Co. has, across earlier work, built a vendor base overview showing its three vendors' own share of USD 500,000 total domestic spend, a qualification file for Delta Garments from when it first joined the base, a performance segmentation comparing Delta Garments against a 6-year vendor, and a second-source review for its T-shirt style. Omar needs all four brought onto one worksheet before Monday's buying committee meeting, so the committee can review the whole vendor base at once rather than asking Omar to describe each piece separately.
Omar pulls the four existing records into the worksheet's "Complete vendor base view" sheet, checking each vendor's own row is fully filled before the meeting.
The worked numberThe gap belongs to the 6-year vendor: it has a current spend share, a performance segment, and no live single-source style needing a second-source decision, but no qualification file exists because it joined the vendor base before Cedar & Co. began keeping one. Omar flags this gap on the worksheet rather than leaving that vendor's qualification row blank, since a missing record is different from a vendor that genuinely has nothing to report.
A common mistake is leaving a vendor's row blank where a check has simply never been run, rather than distinguishing a genuine "nothing to flag" result from a missing record. If Omar had left the 6-year vendor's qualification row blank without a note, the buying committee could easily read that blank as "qualification passed with no issues" instead of "qualification was never actually done," a very different fact with a very different follow-up action.
This mistake is easy to make because a worksheet's blank cells all look the same, whether they mean "checked, nothing found" or "never checked." Flagging the difference explicitly is what keeps a complete worksheet honest about what it actually knows.
The fix costs almost nothing: one short note in the cell, naming the gap and why it exists, turns an ambiguous blank into a fact a committee can act on. Skipping that note does not remove the gap; it only hides it until someone assumes the wrong thing about it.
A complete vendor base worksheet brings together four things this course teaches separately: each vendor's own share of the vendor base's spend, its qualification record, its performance segment, and any second-source decision affecting its styles. It does not redo any of that work; it assembles the current results so one page shows the whole vendor base's own status. Cedar & Co.'s worksheet showed two of its three vendors fully documented, with one vendor missing a qualification file simply because it joined before that practice started, a gap the worksheet should flag rather than hide.
Omar has brought the complete vendor base worksheet to Monday's committee meeting. The facts in front of the committee:
The note on the worksheet itself:
Should the committee approve next season's plan today, with the 6-year vendor's qualification gap still open and only flagged, not filled? Decide before you open the decision.
Yes, with a condition. The committee can approve the plan today, provided a qualification review for the 6-year vendor is scheduled before its next reorder is placed.
Two facts decide this. First, the worksheet's own method treats a flagged gap as visible and actionable, not as a reason to halt every decision until every gap closes; the other checks for this vendor are current, so a delayed qualification review is proportionate, not reckless. Second, approving the plan while ignoring the flag entirely would repeat this lesson's own trap, treating a flagged gap the same as a silently blank one, which is exactly what a complete worksheet is built to prevent.
Approving without any condition attached would let the flagged gap quietly become a permanent one; approving with a scheduled follow-up keeps the worksheet's own flag meaningful.
A third of Cedar & Co.'s vendor base currently carries an unresolved qualification gap. This is not itself a crisis; qualification gaps happen, especially for vendors onboarded before a formal process existed. Leaving it flagged with no follow-up date, though, converts a manageable gap into the same silent risk a missing record was already at risk of becoming.
Use the T27-C01 Vendor base management worksheet. This lesson completes the "Complete vendor base view" sheet: pulling each vendor's own row from the overview, qualification, segmentation and second-source sheets, with any gap flagged rather than left blank, ready for a buying committee review.
[Download the Vendor base management worksheet](../../templates/T27-C01-vendor-base-management-worksheet.xlsx)
1. What does a complete vendor base worksheet actually do with the four checks from Lessons 1 through 4?
2. Cedar & Co.'s 6-year vendor has no qualification file on record. What should the worksheet show?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Vendor base | القاعدة التوريدية | Base de fournisseurs | Tedarikçi tabanı | The full set of suppliers a buyer manages together as a system, rather than one relationship judged on its own. |
| Qualification file | ملف التأهيل | Dossier de qualification | Niteliklendirme dosyası | The record of every check run on a candidate factory, kept as part of the vendor base once that factory is added to it. |
| Vendor performance segment | فئة أداء المورّد | Segment de performance fournisseur | Tedarikçi performans segmenti | A group a vendor is placed into within a vendor base, based on its measured delivery and quality record rather than how long it has been used. |
| Value at risk | القيمة المعرضة للخطر | Valeur à risque | Risk altındaki değer | The share of a style's own order value that would be exposed if its single supplier failed to deliver. |
| Complete vendor base view | العرض الكامل للقاعدة التوريدية | Vue complète de la base de fournisseurs | Eksiksiz tedarikçi tabanı görünümü | A single working document that draws a vendor base's own overview, qualification status, performance segments, and second-source decisions together for one review. |
You now have a complete vendor base management worksheet, covering overview, qualification, segmentation and second-source decisions. The next course moves to the next stage of buyer-side control: what raising a buyer order actually commits a business to. Back to the course map