Course contents
Practitioner · Course 3: WIP and Finished Goods · Lesson 5 of 5

Building a complete WIP and finished goods tracker

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt)Tool: WIP and finished goods tracker
For anyone who has completed this course's first four lessons and now needs to run one tracker covering an order's own journey from cutting to shipment, on a domestic order that mixes a fresh Make to Order top-up cut with existing Make to Stock stock. Lessons 24.3.1 to 24.3.4 are assumed. Figures are teaching figures built on Order A's own specification.
Domestic brandCedar & Co., 12 shops
FactoryDelta Garments (garment factory)
ProductBasic T-shirt, single jersey 180 GSM (Order A specification)
Batch3,000 pieces, hybrid MTS stock plus MTO top-up
Bottleneck flaggedSleeve attach, largest waiting-bundle share
Final reconciliation2,940 of 3,000 pieces confirmed before delivery
02Opening

This page brings together bundle location tracking, WIP reporting, the sewing-to-store handover, and pre-shipment reconciliation into one complete tracker covering an order from cutting to delivery

Each of the previous four lessons in this course taught one piece of tracking an order's own journey through the factory: where a bundle physically sits, which operation is the real constraint, how a completed batch is counted into the finished goods store, and how finished stock is reconciled against a shipment before it leaves. This lesson does not teach a new skill; it teaches how those four pieces work together, in order, on a single Cedar & Co. batch that mixes existing Make to Stock stock with a fresh Make to Order top-up cut, a hybrid order that touches every part of the tracker.

Without seeing the four pieces linked together, a person can run each check correctly in isolation and still lose the order between them, for example checking WIP carefully but skipping the finished goods handover, or reconciling a shipment without ever having tracked the bundles that fed it. This lesson closes that gap by walking one order through all four steps in sequence.

03Before you start

What you need, and what this lesson does not cover

You need: lessons 24.3.1 to 24.3.4 of this course (bundle location, WIP reporting, the sewing-to-store handover, and pre-shipment reconciliation) are assumed, not re-taught here.

By the end of this lesson you can:

  • follow a single order through bundle location tracking, WIP reporting, handover and reconciliation as one connected sequence;
  • identify which of the four tracker sheets to check first when a question arises about an order's status;
  • build a hybrid order's own tracker entries covering both its Make to Stock stock and its Make to Order top-up cut;
  • spot where a gap between two tracker sheets, not a single sheet's own error, is the real cause of a discrepancy;
  • decide when an order is genuinely ready to close out as delivered.

Not covered here: the individual mechanics of bundle location logging, WIP report reading, handover counting, or reconciliation math, each already taught in lessons 24.3.1 to 24.3.4.

04Key terms

Words you will meet in this lesson

TermMeaning
Bundle location logA record, updated each time a bundle physically moves, of the exact zone or station where that bundle currently sits, separate from how much of it is completed.
WIP reportA single report listing every bundle's quantity issued, quantity completed and quantity remaining at every operation on a line, read together rather than bundle by bundle.
Finished goods storeThe stockroom or warehouse area where fully sewn, checked garments are held once they leave the sewing floor, before they are shipped or sent to a shop.
Handover countThe quantity of finished pieces the sewing floor formally states it is transferring, recorded at the exact point a bundle crosses into the finished goods store.
Pre-shipment reconciliationChecking a shipment's own finished goods stock against its packing list, piece for piece, before loading, to confirm the two actually agree.
Buffer stockA small stock of fast-moving components a mainly Make to Order factory keeps on hand to shorten lead time on repeat orders; here used to top up a fresh cut so a shipment can be completed without waiting for every piece to be freshly sewn.
05Teaching
The rule

A complete order tracker follows one order through four linked stages in a fixed order, and a gap between any two stages is as important to catch as an error inside one stage

Tracking an order well means more than getting each of the four checks right on its own. It means the output of one stage, the confirmed count from the sewing floor's own handover, feeds directly into the next stage, the finished goods store's own receiving count, and so on through to reconciliation. A tracker that records each stage correctly but never checks that stage two's own opening figure matches stage one's own closing figure can still lose an order's own units in the seams between sheets.

Bundle locationLesson 24.3.1WIP reportLesson 24.3.2Sewing-to-store handoverLesson 24.3.3Pre-shipment reconciliationLesson 24.3.4
A complete order tracker links four stages, in order. Each stage's own closing figure must match the next stage's own opening figure, or units can be lost precisely in the gaps between correctly run individual checks.
What you meet in real life

A hybrid order touches all four tracker stages differently than a single-source order does

What can differThe shapes you meetWhy it matters to you
Single-source orderAn order built entirely from one fresh cut, like a straightforward Order A shipment, moves through all four stages as one continuous batch.The four sheets can be filled in as a simple sequence, with one batch identifier carried through all of them.
Hybrid order, MTS stock plus MTO top-upCedar & Co.'s batch combines existing Make to Stock stock already in the finished goods store with a fresh Make to Order top-up cut moving through bundle location and WIP stages.The tracker must show two separate paths converging at the finished goods store stage, not one path, before a single reconciliation covers both.
Where the bottleneck sitsA bottleneck flagged in the WIP report, as in lesson 24.3.2, can delay only the fresh-cut portion of a hybrid order, since the buffer stock portion is already finished.A delay shown in the WIP report does not automatically delay the whole hybrid batch; checking which portion it affects avoids a false alarm.
Who checks each stageOn a purely domestic Make to Stock floor, the same production team may check every stage internally. On an order also serving an export buyer or agent, an independent check at handover or reconciliation, as Meridian Sourcing performs in lesson 24.3.4, adds a further layer.The number of independent checks an order receives should match how much is riding on getting the final count right, not be the same for every order regardless of value or destination.
When to close the trackerAn order is not ready to close simply because its packing list is printed; it closes only once reconciliation confirms the finished goods stock matches, as taught in lesson 24.3.4.Closing a tracker early, before reconciliation, buries exactly the kind of shortfall this course has taught how to catch.
The case we follow

Cedar & Co.'s hybrid batch moves through all four tracker stages, with a bottleneck at sleeve attach and a shortfall caught at reconciliation

Cedar & Co. needs 3,000 pieces of a basic T-shirt, built to Order A's own specification, for its 12 shops. Delta Garments already holds 300 pieces of matching buffer stock in its finished goods store; the remaining 2,700 pieces are cut fresh and enter the sewing line as 45 bundles of 60.

Through the sewing floor, bundle location logs (lesson 24.3.1) track each of the 45 fresh-cut bundles by zone, and the WIP report (lesson 24.3.2) flags sleeve attach as the operation with the largest waiting-bundle share partway through the run. Once sewing finishes, the sewing floor hands over 45 bundles, 2,700 pieces, and the finished goods store's own receiving count (lesson 24.3.3) confirms 2,640 pieces, a 60-piece shortfall traced to one bundle. Combined with the existing 300 pieces of buffer stock, the batch's total finished goods stock stands at 2,940 pieces against a 3,000-piece packing list, and reconciliation (lesson 24.3.4) flags exactly this gap before delivery to Cedar & Co.'s own distribution point.

The worked number

Following the batch through all four stages shows the final 60-piece shortfall traces back to the same handover gap, not a new problem

Fresh cut handed over: 45 bundles, 2,700 pieces
Fresh cut received into finished goods store: 44 bundles, 2,640 pieces
Existing buffer stock: 300 pieces
Total finished goods stock: 2,640 + 300 = 2,940 pieces
Packing list quantity: 3,000 pieces
Final shortfall: 3,000 − 2,940 = 60 pieces, matching the handover-stage gap exactly

The 60-piece shortfall identified at reconciliation is not a new, separate problem; it is the same gap first visible at the sewing-to-store handover stage, carried forward because the batch was not corrected before combining it with the buffer stock. Tracking all four stages together, rather than checking each one in isolation, shows the shortfall's origin immediately instead of requiring a fresh investigation at the point of shipment.

Cedar & Co. batch — 3,000 pieces on the packing list2,940 pieces confirmed (98%)60-piece gap, traced to handover
The 60-piece gap found at reconciliation matches the gap first seen at handover exactly. Linking the tracker's four stages means the same shortfall is recognised once, not rediscovered twice.
The method

Run a complete order tracker across all four stages in five steps

  1. Log bundle locations for every bundle moving through the sewing floor, as taught in lesson 24.3.1, keeping a live picture of where the order physically sits.
  2. Read the WIP report across all bundles to flag the real constraint, as taught in lesson 24.3.2, and note which portion of a hybrid order it affects.
  3. Record the handover and receiving counts as bundles complete and move into the finished goods store, as taught in lesson 24.3.3, catching any shortfall at its earliest point.
  4. Combine fresh-cut finished goods with any existing buffer stock, carrying forward any shortfall already identified rather than treating the combined total as a fresh figure.
  5. Reconcile the combined finished goods stock against the packing list before shipment or delivery, as taught in lesson 24.3.4, confirming the tracker's own final figure traces back through all four stages.
The trap

Treating the four tracker sheets as separate checklists instead of one connected record, so a shortfall caught early is lost by the time it reaches reconciliation

If each of the four stages is checked correctly but recorded as if it were unrelated to the others, a shortfall flagged at handover can quietly disappear from view once the batch is combined with buffer stock, only to resurface at reconciliation as if it were a new, unexplained gap. The four stages exist as one tracker precisely so that a number identified early is carried forward, not re-discovered from scratch at the last possible moment before shipment.

06In plain words

An order does not move through a factory in one single step; it moves through cutting, sewing, a handover into the finished goods store, and finally a check against what is supposed to ship. Each of the last four lessons taught how to do one of those checks well. This lesson shows that the real skill is treating them as one continuous story about a single order, not four separate, disconnected jobs. When a batch mixes stock that already existed with pieces freshly cut and sewn, both paths have to be tracked and then brought together correctly before anyone can say the order is really ready. A gap that shows up right at the end, just before shipment, is almost always a gap that was already visible earlier, if the four stages had been read as one record instead of four separate ones.

07Quick check
  • A complete order tracker links bundle location, WIP reporting, the sewing-to-store handover, and pre-shipment reconciliation as one sequence, not four unrelated checks.
  • A hybrid order's fresh-cut portion and its existing buffer stock portion must each be tracked through their own path before being combined.
  • A shortfall found late, at reconciliation, often traces back to a gap already visible at an earlier stage, if the stages are read together.
  • The WIP report's own bottleneck flag applies only to the fresh-cut portion of a hybrid order, not automatically to buffer stock already finished.
  • An order only closes once its finished goods stock is reconciled against the packing list, not simply once production or handling stops.
08Workplace scenario

Cedar & Co.'s own operations lead must decide whether the batch is ready to release to distribution once the 60-piece gap is confirmed at reconciliation

The tracker's full record for Cedar & Co.'s batch shows the shortfall traced consistently from handover through to reconciliation: 60 pieces missing, tied to one specific bundle at the sewing-to-store handover stage.

  • The bundle location log and WIP report both show the fresh-cut portion completed sewing without any other flagged issue besides the sleeve attach bottleneck, already resolved.
  • The handover count found 45 bundles sent, 44 received, a 1-bundle, 60-piece shortfall.
  • Combined with the existing 300 pieces of buffer stock, total confirmed finished goods stock is 2,940 of the 3,000-piece packing list.
  • Cedar & Co.'s 12 shops are waiting on this batch for a seasonal delivery window.

Should the operations lead release the batch to distribution at 2,940 pieces with the packing list corrected, or hold the batch until the missing bundle is found or replaced? Decide before opening the answer.

Show decision

The operations lead should hold the batch briefly to attempt to locate or replace the missing bundle, since the tracker's own record shows exactly where and when the 60 pieces went missing, making it a targeted, likely quick search rather than an open-ended delay.

1. The tracker's four linked stages already point to one specific bundle at one specific point, the sewing-to-store handover, rather than a vague, unexplained gap somewhere in the batch. 2. A targeted search based on a precisely traced shortfall is a matter of hours, not days, since the bundle's last confirmed location and handling window are already known from the tracker. 3. Releasing the batch at 2,940 pieces without attempting the search first would ship Cedar & Co.'s own 12 shops 60 fewer pieces than planned, when the shortfall may still be fully recoverable.

Only if the bundle genuinely cannot be located within a short window should the operations lead release the batch at the corrected 2,940-piece quantity and adjust the shop allocation accordingly, rather than holding indefinitely.

09What it costs

A shortfall traced and caught through the complete tracker costs a short search; the same shortfall missed until a shop-level stockout costs lost sales, framed against Order A's own retail figures

Order A's own specification carries a shop price of USD 19.90 (docs/02 section 7), used here illustratively for Cedar & Co.'s own basic T-shirt built to the same specification.

60 pieces × USD 19.90 shop price = USD 1,194 in shop-price sales at risk if the shortfall is only discovered once stock reaches a shop and runs short, versus a short internal search if traced through the tracker now

The complete tracker's own value is exactly this: catching the same 60-piece gap once, early, and tracing it to its source, rather than letting it surface separately and unexplained at each stage, or worst of all, only at a shop counter weeks later.

10Working template

WIP and finished goods tracker: use all four sheets together to follow one order from cutting to delivery

Open the WIP and finished goods tracker and use its four linked sheets in sequence: "Bundle location log," "WIP report by operation," "Sewing floor to finished goods handover," and "Pre-shipment reconciliation." Enter Cedar & Co.'s batch above across all four sheets, following the same batch or bundle references through each one, then run one complete order of your own through the full tracker from cutting to delivery.

[Download the WIP and finished goods tracker workbook](../../templates/T24-C03-wip-finished-goods-tracker.xlsx)

Download the WIP and finished goods tracker (Excel)

11Check yourself

1. What is the main skill this lesson adds beyond the individual checks taught in lessons 24.3.1 to 24.3.4?

2. Cedar & Co.'s batch shows a 60-piece shortfall at both the handover stage and later at reconciliation. What does this tell you?

3. Why should the operations lead attempt a targeted search before releasing Cedar & Co.'s batch at the reduced 2,940-piece quantity?

12Glossary
ENARFRTRMeaning
Bundle location logسجل موقع الحزمةRegistre de localisation des liassesDemet konum kaydıA record, updated each time a bundle physically moves, of the exact zone or station where that bundle currently sits, separate from how much of it is completed.
WIP reportتقرير الأعمال قيد التشغيلRapport d'encoursAra stok raporuA single report listing every bundle's quantity issued, quantity completed and quantity remaining at every operation on a line, read together rather than bundle by bundle.
Finished goods storeمخزن البضاعة الجاهزةMagasin de produits finisBitmiş ürün deposuThe stockroom or warehouse area where fully sewn, checked garments are held once they leave the sewing floor, before they are shipped or sent to a shop.
Handover countعدد التسليمComptage de remiseDevir sayımıThe quantity of finished pieces the sewing floor formally states it is transferring, recorded at the exact point a bundle crosses into the finished goods store.
Pre-shipment reconciliationمطابقة ما قبل الشحنRapprochement avant expéditionSevkiyat öncesi mutabakatChecking a shipment's own finished goods stock against its packing list, piece for piece, before loading, to confirm the two actually agree.
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; here used to top up a fresh cut so a shipment can be completed without waiting for every piece to be freshly sewn.
13Next

Lesson 24.4.1: What a warehouse management system actually replaces from a paper-based store

You can now track an order's own journey from cutting to finished goods reconciliation using a spreadsheet-based tracker. The next course moves on to what a warehouse management system changes once a warehouse outgrows a paper-based or spreadsheet-based store. Back to the course map

14Ladder

RecognizeName the four linked stages a complete order tracker follows, from bundle location through to pre-shipment reconciliation.
ConnectSee how a hybrid order's fresh-cut and buffer stock paths must each be tracked before being combined into one total.
CompareTrace a shortfall found late at reconciliation back to the earlier stage where it first appeared.
DecideChoose whether an order is genuinely ready to release, based on the tracker's full linked record, not one stage in isolation.