Course contents
Practitioner · Course 4: Procurement, MOQ and Material Follow-Up · Lesson 5 of 5

Building a complete material procurement and follow-up tracker for an order

Level: PractitionerTime: 40 minutesOrder used: Order A and B, and Cedar & Co.'s own domestic runTool: Procurement and follow-up tracker
For a merchandiser or production planner at a garment factory who must set up and maintain one complete procurement and follow-up tracker covering every material an order needs, across more than one order running on the same floor. Lessons 1 to 4 are useful background but not required. Figures are teaching figures.
FactoryDelta Garments
Orders on the floorOrder A (export), Order B (export, the jeans, denim), Cedar & Co.'s domestic run
Business modelHybrid (MTO and MTS lines together)
SuppliersColorline Dyeing, Suez Denim, and Delta Garments itself
ToolProcurement and follow-up tracker (this course's workbook)
02Opening

This page explains how to build one complete procurement and follow-up tracker that covers every material an order needs, from purchase order to confirmed delivery

This page is for a merchandiser or production planner at a garment factory who must set up and maintain one working tracker covering every material purchase order running through the floor. Lessons 1 to 4 taught what a minimum order quantity is, how to close a gap against it, how to issue and confirm a purchase order, and how to follow up a delivery before its promised date. This lesson brings all of that into one tool: a single procurement and follow-up tracker listing every material purchase order, its supplier, whether it met or was combined to meet the supplier's MOQ, its price, its promised delivery date, its follow-up date and status, and the action taken. This is chiefly an information-flow skill: keeping every material's status visible in one place, across a factory floor that can be running more than one order, in more than one business model, at the same time. Without one tracker covering every line, a factory can lose track of which materials are secured, which still need following up, and which need action, especially where several orders share the same floor and sometimes the same suppliers.

03Before you start

You need: the MOQ recognition and negotiation methods from Lessons 1 and 2, the purchase order method from Lesson 3, and the follow-up method from Lesson 4.

By the end of this lesson you can:

  • list the columns a complete procurement and follow-up tracker needs for every material line;
  • populate a tracker row for a new material purchase order, including its MOQ status;
  • update a tracker row once a supplier's delivery is followed up;
  • record the correct action taken for any at-risk or late delivery;
  • use one tracker to manage materials across more than one order and business model on the same floor.

Not covered here: the MOQ, purchase order, and follow-up methods this tracker relies on (Lessons 1 to 4, already covered).

04Key terms

Words you will meet in this lesson

TermMeaning
Order trackerA working document that logs each stage of an order against its planned and actual date.
Purchase-order quantityThe fabric quantity actually written on the purchase order sent to a mill: the bare consumption total plus whichever buffer has been agreed.
Minimum order quantityThe smallest amount a mill will accept or process as one order, which a calculated yarn requirement is often rounded up to.
EscalateTelling the people who need to know, early, that a delay may change the delivery date, instead of waiting for it to happen.
Buffer stockA small stock of fast-moving components a mainly Make to Order factory keeps on hand to shorten lead time on repeat orders.
Production trackingComparing a stage's actual finish date against its planned date throughout production, to catch a delay while it can still be fixed.
05Teaching
The rule

A complete procurement and follow-up tracker has one row per material purchase order and eleven fixed columns, and it is complete only when every material an order needs actually has its own row

A procurement and follow-up tracker is a single working document, not a set of separate notes or emails, listing every material purchase order a factory's orders need. Each row holds eleven fixed pieces of information: the order, the material, the supplier, the PO number, the PO quantity, whether it meets the supplier's MOQ, the unit price, the promised delivery date, the follow-up date, the status, and the action taken. A tracker is complete for a factory floor only when every material every order on that floor needs has its own row, whether or not that material's delivery has been followed up yet; a missing row means nobody is tracking whether that material is even secured.

One tracker row = one material purchase orderOrderMaterialSupplierPOnumberPOquantityMOQstatusUnitpricePromiseddateFollow-updateStatusAction
A procurement and follow-up tracker holds eleven fixed columns per material purchase order.* A tracker missing even one row a floor's orders actually need is not tracking that floor's full material requirement.
What you meet in real life

The same eleven columns apply to every material, but how many rows are active at once, and how they are grouped, differs when more than one order and business model share a floor

What can differThe shapes you meetWhy it matters
One order vs. more than one order on the same floorDelta Garments' hybrid line, running Order A, Order B (denim), and Cedar & Co.'s own domestic run together, needs each order's own rows kept clearly separated by order, even inside one shared tracker file.Mixing rows from different orders without a clear order label risks reading one order's on-track material as if it also covers a different order's own requirement.
A row met on its own vs. a row combined with another orderSome rows show a purchase order that met a supplier's MOQ on its own; others, like Order A's fabric top-up from Lesson 2, show a combined order across two rows.The MOQ status column must show which is which, so a combined row's own quantity is never read as a full, independent order.
A row still pending vs. a row confirmed and followed upSome rows show a purchase order issued but not yet confirmed; others show a confirmed delivery already followed up at its own follow-up point.A tracker with blank follow-up dates on old purchase orders flags a confirmation or follow-up call that still needs to happen.
An at-risk or late row vs. an on-track rowAn on-track row needs no further action beyond its follow-up note; an at-risk or late row must show the action taken, escalated if needed.An at-risk row with a blank action column is an unresolved problem, not a completed one, even though the risk itself has already been recorded.
Socks, terry, and home-textile product familiesA hosiery, terry, or bedding order's tracker uses the same eleven columns, with that product's own materials and suppliers in the material and supplier columns.The tracker's structure does not change by product family; only which materials and suppliers appear in it does.
The case we follow

Delta Garments' hybrid floor runs Order A, Order B (denim), and Cedar & Co.'s own domestic run, and each needs its own complete rows in the same tracker

Delta Garments is running a hybrid floor: Order A and Order B, both confirmed export orders for Northline Apparel, and Cedar & Co.'s own domestic Make to Stock reorder, all at the same time. Mona keeps one procurement and follow-up tracker file, with Order A's combined dye-lot row from Lesson 2, Order B's denim purchase order from Lesson 3, and Cedar & Co.'s own reorder and follow-up from Lesson 4, each in its own clearly labelled row. When Suez Denim confirms Order B's denim delivery, Mona updates only that row; Order A's and Cedar & Co.'s own rows stay exactly as they were until their own next update is due.

The worked number

Three orders' material rows sit in the same tracker file, each judged complete or at risk independently

Order A (export): 1 material row, combined dye lot, on track
Order B (export, denim): 1 material row, confirmed purchase order, on track
Cedar & Co. domestic run: 1 material row, followed up 5 working days before its promised date, on track
Total rows in the shared tracker file: 3 rows, tracked as three separate, order-labelled lines

Three rows sit in one file, but each order's own row is judged on its own facts: Order A's row is on track because its combined dye lot met Colorline Dyeing's MOQ, Order B's row is on track because Suez Denim's confirmed date fits inside the fabric-stage window, and Cedar & Co.'s own row is on track because its follow-up call found dyeing already finished, regardless of what any other row shows.

The method

A five-step method for setting up and maintaining one procurement and follow-up tracker across one or more orders

1. List everymaterial everyorder needs2. Add one row,labelled withits order3. Record MOQstatus, price,promised date4. Follow upbefore thepromised date5. Record theaction for anyat-risk row
Building and maintaining a procurement and follow-up tracker is a fixed five-step method, whether one order or several share the floor.* Skipping step 2's order label, on a floor running more than one order, is how one order's material status gets mistakenly read against another's.
  1. List every material every order needs, using each order's own bill of materials and its own supplier.
  2. Add one row per material purchase order, labelled clearly with which order it belongs to.
  3. Record the MOQ status, unit price, and promised delivery date for each row, using Lessons 1 to 3's methods.
  4. Follow up and update each row's status before its promised date, using Lesson 4's follow-up point method.
  5. Record the action taken for any at-risk or late row, escalating where needed, and confirm goods do not move until that column is filled.
The trap

A common mistake is updating only the order currently being discussed and letting other orders' rows go unfollowed until their own delivery dates are already close

A common mistake, on a floor running more than one order at once, is following up diligently on whichever order is currently the most urgent conversation, while a different order's own follow-up point quietly passes unnoticed in the same tracker file. A tracker exists precisely to make every order's own follow-up point visible at a glance, regardless of which order happens to be top of mind that day; a tracker checked selectively, order by order, defeats that purpose and lets a quieter order's delivery slip past its own follow-up point unnoticed.

06In plain words

Once a factory knows how to spot a minimum order quantity problem, close it, write and confirm a purchase order, and follow up a delivery before it is late, the last step is keeping all of that in one place. A procurement and follow-up tracker is a single list with one row for every material purchase order a factory's orders need. Each row holds the order it belongs to, the material, the supplier, the purchase order's own details, whether it met the supplier's minimum, the price, the promised date, the follow-up date and status, and what was done about it. If a factory runs more than one order on the same floor, each order's rows need their own clear label. A tracker is only complete once every material every order actually needs has its own row, whether or not it has been followed up yet.

07Quick check
  • A procurement and follow-up tracker has one row per material purchase order, with eleven fixed pieces of information.
  • The eleven columns cover the order, material, supplier, PO details, MOQ status, price, dates, status, and action taken.
  • A tracker is complete for a floor only when every material every order there needs has its own row.
  • On a floor running more than one order, every row needs a clear order label.
  • A combined MOQ row must show which other order it was combined with, never read as a full order on its own.
  • An at-risk row is only resolved once its action column names what was done, escalated where needed.
  • The same tracker file can hold rows for export orders and a domestic order at the same time, kept separate.
08Workplace scenario

A new colleague at Delta Garments almost marks Cedar & Co.'s own row "on track" using Order A's follow-up note by mistake

Delta Garments' hybrid floor is running Order A, Order B (denim), and Cedar & Co.'s domestic run, and a new colleague is updating the shared tracker for the first time.

  • Order A's row shows "on track," followed up 13-Mar-2026, with a note that its combined dye lot finished dyeing.
  • Cedar & Co.'s own row has a separate, later follow-up date, not yet reached, and its own promised date of 18-Mar-2026.
  • Both rows mention "dyeing finished" because both use the same combined dye lot from Lesson 2.
  • The new colleague is about to copy Order A's own "on track" note directly into Cedar & Co.'s row, since the dye lot is shared.

The tracker's two rows, exactly as they stand before this update:

Tracker, Order A row. "On track, followed up 13-Mar-2026: combined dye lot finished dyeing." Tracker, Cedar & Co. row. "Follow-up date 13-Mar-2026, not yet reached: status pending."

Should the new colleague copy Order A's own "on track" note into Cedar & Co.'s row, since they share the same dye lot? Decide before you open the decision.

Show decision

No. The two facts that decide this are that Cedar & Co.'s own row has its own follow-up date, not yet reached, and that a shared dye lot finishing dyeing does not by itself confirm Cedar & Co.'s own later stages, cutting, sewing, and packing, are also on track.

The new colleague should make Cedar & Co.'s own follow-up call at its own follow-up point and record its own actual answer, which may well also be "on track," rather than copying Order A's note as if the two rows were the same order.

09What it costs

The cost of copying one order's follow-up note into another order's row, against making each order's own separate follow-up call

This lesson's cost is framed by what a copied note risks, rather than one fixed figure, since the tracker itself costs nothing beyond the normal cost of the calls it records. If Cedar & Co.'s own later stages actually slip, and its row was wrongly marked "on track" from a copied note, the domestic reorder can miss its 18-Mar-2026 date with no warning at all, since its own row never flagged the risk. Making Cedar & Co.'s own separate follow-up call costs only the time of one phone call, far smaller than a missed delivery discovered only when it is already too late to react.

10Working template

Procurement and follow-up tracker: the finished tool, covering every material for every order on the floor, ready to use

This course's procurement and follow-up tracker is the tool this whole course has built toward: one row per material purchase order, eleven fixed columns, and a clear order label on every row, whether the floor is running one order or several at once. [Download the tracker](templates/T13-C04-procurement-tracker.xlsx).

OrderMaterialSupplierMOQ statusPromised delivery dateStatus
Order A (export)180 GSM dyed fabric top-up, 100 kgColorline DyeingCombined with another order26-Feb-2026On track
Order B (export)12 oz denim, 4,350 mSuez DenimYes10-Mar-2026On track
Cedar & Co. domestic run180 GSM fabric, cut and sewnDelta GarmentsCombined with another order18-Mar-2026On track

Download the Procurement and follow-up tracker (Excel)

11Check yourself

1. What are the eleven fixed pieces of information a complete procurement and follow-up tracker row holds?

2. A factory floor is running four separate orders sharing one dye lot, and two of the four rows are confirmed on track after their own follow-up calls. Are the other two rows automatically also on track?

3. A tracker shows an at-risk row with the promised date, follow-up date, and status all filled in, but the action-taken column is blank. Is this row complete?

12Glossary
ENARFRTRMeaning
Order trackerمتعقّب الطلبيةSuivi de commandeSipariş takipçisiA working document that logs each stage of an order against its planned and actual date.
Purchase-order quantityكمية أمر الشراءQuantité du bon de commandeSipariş miktarıThe fabric quantity actually written on the purchase order sent to a mill: the bare consumption total plus whichever buffer has been agreed.
Minimum order quantityالحد الأدنى لكمية الطلبQuantité minimale de commandeMinimum sipariş miktarıThe smallest amount a mill will accept or process as one order, which a calculated yarn requirement is often rounded up to.
Escalateتصعيد الأمرAlerter (faire remonter)Üst makama bildirmek (eskalasyon)Telling the people who need to know, early, that a delay may change the delivery date, instead of waiting for it to happen.
Buffer stockمخزون احتياطي (وسيط)Stock tamponTampon stokA small stock of fast-moving components a mainly Make to Order factory keeps on hand to shorten lead time on repeat orders.
Production trackingتتبع الإنتاجSuivi de productionÜretim takibiComparing a stage's actual finish date against its planned date throughout production, to catch a delay while it can still be fixed.
13Next

Course 4 complete — procurement, MOQ and material follow-up is now covered

You can now recognize a minimum order quantity gap, choose the real option for closing it, issue and confirm a material purchase order, follow up a delivery before its promised date, and keep every material for every order tracked in one working tool. Back to the course map

14Ladder

RecognizeName the eleven fixed columns a complete procurement and follow-up tracker row holds.
ConnectMatch each material every order needs to its own labelled row in the tracker.
CompareContrast a tracker running one order against one running more than one order and business model on the same floor.
DecideKeep every order's rows separately complete, and close every at-risk row with a recorded action.