A raw material store's book stock can look correct on paper while a physical count shows something different, and both of those can disagree with what production actually used once pieces are counted against the standard fabric consumption. Trusting only one of these three figures leaves a real problem undetected. This lesson teaches how to bring book stock, physical count and actual usage together into one reconciliation, and applies it to a periodic check Meridian Sourcing, the agent, runs on Delta Garments' raw material store for a hybrid Order A shipment.
Without this three-way check, a small daily gap between what was issued and what was actually used can go unnoticed for weeks, growing into a shortage nobody can explain by the time it is finally counted.
You need: the material issue and issue slip from Lesson 2, and the roll balance calculation from Lesson 3.
By the end of this lesson you can:
Not covered here: tracking one roll's own balance (Lesson 3), or building the complete tracker workbook (Lesson 5). This lesson only teaches how to reconcile the store's own figures against actual usage.
| Term | Meaning |
|---|---|
| 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. |
| Physical stock count | Counting the real units sitting on the shelf or in the stockroom by hand, to check against the book stock. |
| Reconciliation | Comparing two records of the same fact, such as a stock count and a system balance, to confirm they agree. |
| Fabric consumption | The amount of fabric (by weight or length) one garment piece uses, the basis for calculating an order's total fabric requirement. |
| 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. |
Book stock tells you what the records say should be left. A physical count tells you what is actually on the shelf. Actual usage, the pieces production reports as cut multiplied by the standard fabric consumption, tells you what should have been consumed if nothing went wrong. When all three agree within a small, expected margin, the store's own figures are trustworthy. When they diverge, the size and direction of the gap points to what actually happened, whether that is unrecorded wastage, an unissued return, or a genuine loss.
| What can differ | The shapes you meet | Why it matters to you |
|---|---|---|
| Business model | A firm, confirmed portion of an order, like part of Order A, reconciles against one fixed quantity. A hybrid order, combining a firm quantity with buffer stock held against likely reorders, reconciles the firm and buffer portions separately, since mixing them hides which portion actually shows a variance. | Reconciling a hybrid order as one single total can mask a real problem in either its firm or buffer portion. |
| Market | An export order under a fixed shipment date needs reconciliation run frequently enough to catch a variance before the shipment date, since there is little time to investigate late. A domestic order has more room to reconcile on a routine, less urgent schedule. | A tighter export deadline makes prompt reconciliation more valuable, not the reconciliation method itself different. |
| Who performs it | An internal storekeeper or production manager can reconcile as part of routine store discipline. An agent such as Meridian Sourcing, representing the buyer's interest, may run an independent periodic reconciliation as an audit, since the agent answers to a buyer who was not present to see the fabric received or issued. | An independent reconciliation by an agent carries the same method but adds a layer of verification the buyer itself cannot perform from a distance. |
| Product family | A garment factory reconciles fabric by weight or length; a hosiery mill reconciles yarn by weight; a home-textiles converter reconciles fabric by length; a terry mill reconciles yarn rather than a finished-fabric count. | The unit reconciled changes by product family, but the three-way comparison, book stock, physical count and actual usage, applies to all of them. |
Order A is structured as a hybrid: a firm quantity Northline Apparel has confirmed, plus a smaller buffer quantity Delta Garments holds fabric for in case Northline Apparel reorders before the season ends. Meridian Sourcing, the agent representing Northline Apparel in Egypt, periodically checks Delta Garments' raw material store's own figures on Northline Apparel's behalf, since Northline Apparel itself is not present at the factory day to day.
For one day's cutting on the firm portion, the store issued fabric for a planned batch of 500 pieces, but the cutting room's own production report shows only 480 pieces were actually cut that day, the rest carried over to the next day.
The worked numberThis 4.1 kg gap is not automatically a loss. It should either appear as unused fabric returned to the store's own book stock for tomorrow's cutting, or be accounted for as wastage beyond the standard 7% marker allowance. Reconciliation means checking which of these explains the 4.1 kg, rather than assuming it is either fine or a problem without checking.
Book stock and physical count can match each other closely while both are wrong compared to what production actually consumed, for example if an earlier over-issue was never corrected in the book stock at all. The cost of this mistake is a raw material store that looks reconciled and accurate while a real material usage variance sits undetected, compounding with each cutting session until it surfaces as a much larger, harder-to-explain gap.
A raw material store's own figures are only trustworthy when three things are checked together: what the records say is left, what is actually on the shelf, and what the pieces actually made say should have been used. A small gap between fabric issued and fabric a piece count justifies is not automatically a loss; it needs explaining, either as a return, extra wastage, or a genuine shortage. Checking only two of the three figures can let a real problem hide behind an apparent match.
On a different day, the store issued fabric for a planned batch of 800 pieces, but the cutting room's production report shows only 760 pieces actually cut. Meridian Sourcing checks the store's records for a returned-fabric entry or an extra-wastage note explaining the difference and finds neither.
Should Meridian Sourcing record this 8.2 kg gap as normal rounding and close the reconciliation? Decide before opening the answer.
No. An 8.2 kg gap with no recorded return and no recorded extra wastage should be investigated before the reconciliation is closed, not written off as rounding.
1. 8.2 kg is a meaningful quantity, not a rounding-level discrepancy, at roughly 40 pieces' worth of fabric by the standard consumption. 2. Neither of the two explanations reconciliation checks for, a return or extra wastage, is recorded, so the gap currently has no accounted-for cause. 3. Closing the reconciliation without an explanation risks normalising an unrecorded loss, especially on a hybrid order where Northline Apparel, through its agent, expects the buffer portion's own fabric to be accounted for accurately.
The method's own rule, investigate any variance beyond a small expected margin, applies exactly here: an unexplained 8.2 kg is a finding to chase, not a rounding note to accept.
Order A carries a FOB price of USD 3.20 per piece on 15,000 pieces, giving:
If the 8.2 kg gap above repeated across just ten similar batches without ever being explained, that would total 82 kg of fabric, worth 82 × USD 5.60 = USD 459.20 at the fabric's own purchase price, quietly gone from a store that is supposed to be holding buffer stock precisely so Northline Apparel can reorder with confidence. Against Order A's USD 48,000 value, the sum itself may look small, but its real cost is the buffer stock's own reliability: a buyer who cannot trust the reconciled figures cannot trust the buffer exists when a reorder is actually needed.
Use the T24-C02 Raw material store tracker workbook, "Reconciliation log" sheet. For each period, record the book stock, the physical count, the pieces actually cut, the actual usage this implies, and the resulting variance with its explanation. Start with the worked examples above, then add your own reconciliations.
[Download the Raw material store tracker workbook](../../templates/T24-C02-raw-material-store-tracker.xlsx)
1. Why does a raw material store's reconciliation compare three figures instead of just book stock against physical count?
2. A store issues fabric for 600 planned pieces, but only 590 pieces are actually cut, at a standard consumption of 0.25 kg per piece. What is the material usage variance?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| 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. |
| Physical stock count | الجرد الفعلي | Comptage physique | Fiziksel sayım | Counting the real units sitting on the shelf or in the stockroom by hand, to check against the book stock. |
| Reconciliation | التسوية | Rapprochement | Mutabakat | Comparing two records of the same fact, such as a stock count and a system balance, to confirm they agree. |
| Fabric consumption | استهلاك القماش | Consommation de tissu | Kumaş tüketimi | The amount of fabric (by weight or length) one garment piece uses, the basis for calculating an order's total fabric requirement. |
| 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. |
Next you will bring together everything from this course, store identity, material issues, roll balances and reconciliation, into one complete working tracker. Back to the course map