Across this course, four separate skills have been taught: telling a raw material store apart from a finished goods store, issuing fabric in planned batches, tracking one roll's own balance, and reconciling the store's own figures against actual usage. Used separately, on paper or in scattered notes, these four skills still leave room for one part to drift out of step with another. This lesson brings them together into one working tracker, applied to Delta Garments' raw material store as it serves both Order A's export shipment and a domestic hybrid order for Cedar & Co. at the same time.
A single connected tracker means a material issue automatically feeds the roll balance it came from, and both feed the reconciliation that checks the store's own honesty. This lesson shows how the four pieces fit together.
You need: all four previous lessons of this course: the raw material versus finished goods store distinction (Lesson 1), material issues (Lesson 2), roll balances (Lesson 3), and reconciliation (Lesson 4).
By the end of this lesson you can:
Not covered here: this is the final lesson of Course 2. Course 3 continues with the next stage in a warehouse's own operations after material leaves the raw material store.
| Term | Meaning |
|---|---|
| Raw material store | The store that holds fabric, trims and other inputs before they are issued to cutting or production, distinct from a store that holds completed units. |
| Material issue | Releasing a measured quantity of fabric or trims from the raw material store to the cutting room or production line, recorded against a specific order. |
| Roll balance | The quantity of fabric still remaining on one specific roll after each cut is taken from it, tracked roll by roll rather than only as a total store balance. |
| Material usage variance | The difference between the material a raw material store's own count shows as used and the material production actually consumed for the pieces it made, found by reconciling the two records. |
| Book stock | The quantity a stock system shows for a location, built up from every receipt, sale and transfer it has recorded. |
| Reconciliation | Comparing two records of the same fact, such as a stock count and a system balance, to confirm they agree. |
A tracker built as four disconnected sheets, one for store balance, one for issues, one for roll balances, and one for reconciliation, still leaves a storekeeper doing the linking by hand, which is exactly where drift creeps in. A complete tracker instead treats these four as one connected record: every material issue names the roll it came from, so that roll's own balance updates automatically, and every reconciliation pulls its book stock and actual usage figures from the same issues already logged, rather than being re-entered separately.
| What can differ | The shapes you meet | Why it matters to you |
|---|---|---|
| Business model | The tracker manages Order A's firm, confirmed export quantity in exactly the same structure it uses for Cedar & Co.'s hybrid domestic batches, combining a firm quantity with buffer stock. | One tracker design serves Make to Order, Make to Stock and hybrid orders without needing a different structure for each. |
| Market | An export order's reconciliation runs on a tighter schedule tied to a fixed shipment date; a domestic order's reconciliation can follow a routine, less urgent schedule. | The tracker's own structure is identical; only how often each sheet is updated changes with the market. |
| Number of orders served | Delta Garments' raw material store serves both Order A and Cedar & Co.'s domestic batches from the same physical store, so the tracker separates figures by order on every sheet, never combining two orders' fabric into one row. | A store serving multiple orders at once needs its tracker to keep each order's own figures distinct, exactly as Lesson 1 taught for raw material versus finished goods. |
| Product family | A hosiery mill's, a home-textiles converter's or a terry mill's version of this tracker uses the same four linked sheets, with the unit changed to yarn cones, fabric length, or beam-wound yarn as appropriate to that product family. | The four-part structure this course teaches transfers to any raw material store, not only a garment factory's. |
Delta Garments' raw material store holds fabric for two different buyers at once: Northline Apparel's Order A, a Make to Order export shipment, and Cedar & Co.'s ongoing domestic replenishment, a hybrid of firm shop orders and buffer stock. Rather than keeping two separate sets of notes, the storekeeper uses one tracker whose every sheet identifies which order each row belongs to.
When the storekeeper issues fabric for a Cedar & Co. batch from a specific roll, that issue is logged once; the roll balance sheet reads from it automatically, and so does the reconciliation sheet when it is next run, without the storekeeper re-entering the same figures three times.
The worked numberThis is the same 51.25 kg and the same 7.25 kg roll balance already worked through in Lesson 3, now shown as figures a complete tracker carries automatically from one sheet to the next, rather than numbers a storekeeper must remember to copy across three separate places by hand.
A storekeeper who tracks store balance, material issues, roll balances and reconciliation in four unrelated places must remember to update all four by hand every time something changes, and a missed update in just one of them breaks the whole picture without anyone noticing immediately. The cost of this mistake is not any single error; it is that small, unconnected gaps accumulate silently across four separate records until a reconciliation, run too late, reveals a confusing mismatch nobody can trace back to its original cause.
This course taught four separate skills: telling a raw material store apart from a finished goods store, issuing fabric in planned batches, tracking one roll's own balance, and reconciling the store's own figures against actual usage. A complete tracker does not keep these as four separate notes; it links them so one recorded fact, a material issue, automatically updates the roll it came from and feeds the reconciliation that checks the whole store, whether that store serves one export order, one domestic order, or both at once.
Omar, Cedar & Co.'s owner, asks whether his domestic batches can be tracked in "whatever system Delta Garments already uses for its export orders," rather than a separate spreadsheet Cedar & Co. would have to maintain itself.
Should Delta Garments open a second, separate tracker for Cedar & Co. rather than adding its batches to the existing one? Decide before opening the answer.
No. Cedar & Co.'s batches should be added to the same tracker as separate order rows, not placed in a second, disconnected workbook.
1. The tracker's own four-part structure, store balance, issues, roll balances and reconciliation, already applies to any order, whether export or domestic, firm or hybrid, since the method does not depend on which buyer it serves. 2. A second workbook would split one physical raw material store's own figures across two disconnected records, recreating exactly the drift risk this course's final lesson exists to prevent. 3. Keeping Order A and Cedar & Co.'s batches as separate rows in one tracker, rather than separate workbooks, lets the same roll balance and reconciliation logic serve both without duplicating the store's own structure.
One store, one tracker, with orders kept distinct by row rather than by a whole separate file, is what makes the four-part method in this course actually work in practice.
Order A carries a FOB price of USD 3.20 per piece on 15,000 pieces, giving:
If Cedar & Co.'s domestic batches were tracked in a separate file from Order A's own tracker, the same raw material store's physical fabric would be recorded in two places that never check each other, exactly the condition Lesson 4 identified as letting a material usage variance go unnoticed. Against Order A's USD 48,000 export value, the cost of this mistake is not a single number; it is the loss of the entire reconciliation discipline this course teaches, since a variance in one file has no way of being caught by figures sitting in the other.
Use the T24-C02 Raw material store tracker workbook in full: "Raw material store balance," "Material issue log," "Roll balance log," and "Reconciliation log." Enter both Order A's export figures and Cedar & Co.'s domestic hybrid figures as separate rows on each sheet, using the worked examples from this course as your starting templates.
[Download the Raw material store tracker workbook](../../templates/T24-C02-raw-material-store-tracker.xlsx)
1. Why does a complete raw material store tracker link its four parts instead of keeping them as separate notes?
2. A factory tracks its raw material store's balance in one spreadsheet, its material issues in another, and never links the two. What risk does this recreate?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Raw material store | مخزن المواد الخام | Magasin de matières premières | Hammadde deposu | The store that holds fabric, trims and other inputs before they are issued to cutting or production, distinct from a store that holds completed units. |
| Material issue | صرف المواد | Sortie de matière | Malzeme çıkışı | Releasing a measured quantity of fabric or trims from the raw material store to the cutting room or production line, recorded against a specific order. |
| Roll balance | رصيد اللفة | Solde du rouleau | Top bakiyesi | The quantity of fabric still remaining on one specific roll after each cut is taken from it, tracked roll by roll rather than only as a total store balance. |
| Material usage variance | فرق استهلاك المواد | Écart de consommation de matière | Malzeme kullanım farkı | The difference between the material a raw material store's own count shows as used and the material production actually consumed for the pieces it made, found by reconciling the two records. |
| Book stock | الرصيد الدفتري | Stock théorique | Kayıtlı stok | The quantity a stock system shows for a location, built up from every receipt, sale and transfer it has recorded. |
| Reconciliation | التسوية | Rapprochement | Mutabakat | Comparing two records of the same fact, such as a stock count and a system balance, to confirm they agree. |
This is the last lesson of Course 2. Course 3 continues the warehouse and distribution track with the next stage of a product's journey after it leaves the raw material store. Back to the course map