Each of the last four lessons taught one piece of the same real problem: a stock system's number can drift from the truth, a cycle count catches that drift early, a confirmed variance needs sorting into its real cause, and the cause's cost needs measuring against margin, not raw value. Run separately, on separate sheets or in separate conversations, these four checks lose the connections between them. A shortfall found in a cycle count should carry straight through to a cause investigation and then to a margin-cost figure, on the same record, not as four disconnected notes.
This lesson brings the four skills together into Cedar & Co.'s own complete tracker: a domestic, hybrid retailer running Make to Stock shops alongside Make to Order repeat runs with Delta Garments, using Order A's T-shirt figures and Order B's jeans figures as the two reference points the tracker already knows.
You need: all four preceding lessons in this course: book versus physical count (3.1), cycle counts (3.2), sorting shrinkage causes (3.3), and margin cost (3.4).
By the end of this lesson you can:
Not covered here: the individual calculations themselves, already taught in Lessons 3.1 to 3.4. This lesson is an assembly exercise over skills you already have.
| Term | Meaning |
|---|---|
| Inventory accuracy rate | The physical count divided by the book stock, shown as a percentage, measuring how closely the system matches reality. |
| Cycle count | Counting one small group of items on a regular rotating schedule, instead of counting the whole stockroom at once. |
| Inventory shrinkage | Stock that is missing from a location without a recorded reason such as a sale or an approved transfer, distinct from a fabric's own shrinkage after washing. |
| Cost of inventory inaccuracy | The share of an order's own planned margin lost to units the book stock claims exist but that are not actually there to sell. |
| Hybrid account | A buyer relationship that combines Make to Order and Make to Stock business with the same factory. |
| Combined decision view | A single tracker view that lines up every confirmed shortfall's count, cause and margin cost, so the largest real problem is visible at a glance. |
Treating book-versus-physical checking, cycle counting, cause-sorting and margin-costing as four unrelated tasks means the same shortfall gets re-described four times, in four places, often by different people, with details drifting each time it is retold. A single tracker with four linked sheets keeps one shortfall as one record: the location and style from the count, the schedule and tolerance from the cycle count, the confirmed cause once investigated, and the margin cost once calculated, all traceable back to the same original variance.
| What can differ | The shapes you meet | Why it matters to you |
|---|---|---|
| Business model | Cedar & Co.'s Make to Stock shops run cycle counts on a regular retail schedule; its Make to Order repeat runs with Delta Garments follow an order-specific timeline instead, so the same tracker needs both a standing schedule and an order-linked one. | A hybrid account cannot use one single counting rhythm for all its stock; the tracker must hold both patterns without confusing them. |
| Market | A domestic, multi-shop retailer like Cedar & Co. logs shrinkage causes shop by shop; an export order like Order A or Order B's jeans logs a shortfall by shipment or distribution centre instead. | The location field on each tracker sheet needs to fit both a shop-based and a shipment-based business without forcing one format onto the other. |
| Scale of findings | A large retailer may run dozens of cycle counts a week across 12 shops, most within tolerance; only the exceptions need to reach the shrinkage log and the margin-cost sheet. | The tracker should make it easy to see which of many routine counts actually needs the next three stages, not force every count through all four sheets. |
| Who acts on a finding | A book-versus-physical mismatch is usually a store manager's action; a cause investigation may involve a receiving clerk; a margin-cost figure above a threshold may need an agent's or a buyer's own decision. | The combined view should make clear who owns the next step for each open shortfall, not just what the numbers are. |
| Product families | A hybrid account selling apparel alongside other product families, such as socks or home-textiles, uses the same four sheets, only the unit counted (pieces, pairs, sets) and the item groups on the cycle count sheet change. | The tracker's structure holds across product families; only the specific items and units listed need adapting. |
Cedar & Co. operates 12 shops on a hybrid basis: most stock is Make to Stock, forecast and replenished shop by shop, but a fast-selling style occasionally triggers a small Make to Order repeat run placed directly with Delta Garments. This quarter, the tracker holds two open shortfalls: Store 7's 40-unit basic T-shirt shortfall, already investigated in Lesson 3.3 (12 units administrative error, 6 units administrative error, 22 units unknown shrinkage), and a newly confirmed cycle-count variance on a repeat run of jeans-style trims ordered to match Order B's own construction, still awaiting cause investigation.
The tracker's combined view lets Omar see both open items side by side: one already costed against margin, one still moving through the earlier stages, without losing track of either.
The worked numberEven before the trims shortfall's cause is confirmed, the tracker's provisional figure already shows it is smaller in margin exposure than Store 7's confirmed shortfall, even though Store 7's 40-unit count is larger than the trims' 15-unit count. Ranking by margin exposure, not raw units, tells Omar to keep Store 7's corrective actions as the priority while the smaller trims variance completes its own investigation on its normal schedule.
A cycle count that flags a variance but never reaches a cause investigation leaves a known problem unexplained indefinitely. A cause investigation that never reaches a margin-cost calculation leaves a business unable to judge whether the finding was serious or trivial. The four sheets are only worth building as one tracker if a shortfall actually moves through all of them; treating each sheet as its own isolated spreadsheet, filled in once and never connected to the others, recreates the exact fragmentation this course exists to fix.
The four skills in this course are not four separate jobs; they are four stages of following the same problem from start to finish. First you notice a gap between what the system says and what is really there. Then you check it often enough to catch it quickly. Then you work out why it happened. Then you work out what it actually cost. Doing all four on the same record, for the same shortfall, is what turns four small checks into one useful tool that tells a business exactly where to focus.
Omar has time this week to close out the corrective actions on only one of the two open shortfalls in the tracker: Store 7's confirmed 40-unit shortfall (USD 176 margin exposure, cause already sorted) or the repeat-run trims shortfall (USD 48 provisional exposure, cause still pending).
Should Omar prioritise the trims shortfall this week because it involves the factory relationship with Delta Garments, which he considers more important? Decide before opening the answer.
No. Omar should prioritise Store 7's shortfall this week, because it has the larger confirmed margin exposure and a corrective action ready to apply now, while the trims shortfall's own investigation is not yet finished.
1. Store 7's USD 176 margin exposure is confirmed and larger than the trims shortfall's USD 48 provisional figure, so it represents more real cost recovered by acting this week. 2. Store 7's corrective actions, a receiving-process fix, a stockroom-process fix, and a security response, are already defined and ready to apply, while the trims shortfall still needs its cause confirmed before any corrective action can be chosen. 3. The relationship with Delta Garments is not the deciding factor; the tracker's job is to rank by confirmed cost and readiness to act, not by which counterparty feels more important.
Acting on the trims shortfall before its cause is confirmed risks applying the wrong corrective action, while Store 7's shortfall is fully ready for resolution now.
Adding Store 7's confirmed exposure to the trims shortfall's provisional figure gives the tracker's own current total:
USD 224 is a small figure against Cedar & Co.'s own scale of business, which is itself useful information: the combined tracker shows this quarter's inventory inaccuracy is a minor, manageable issue rather than a systemic one, a conclusion that would be far less certain without a single view connecting all four checks together.
Use all four sheets of the T21-C03 Inventory accuracy and shrinkage tracker workbook together: "Book vs physical count," "Cycle count schedule," "Shrinkage log," and "Cost of inaccuracy on margin." Start from a fresh count, follow it through cause and cost, and review the combined ranking before deciding what to act on first.
[Download the Inventory accuracy and shrinkage tracker workbook](../../templates/T21-C03-inventory-accuracy-shrinkage-tracker.xlsx)
Download the Inventory accuracy and shrinkage tracker (Excel)
1. Why track the same confirmed shortfall as one record across all four sheets, rather than as four separate entries?
2. Store 7's shortfall shows USD 176 confirmed margin exposure; a smaller repeat-run shortfall shows USD 48 provisional exposure but involves more units. Which should rank higher for priority?
3. A cycle count flags a variance later found to repeat on a second count. What should happen next in the tracker?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Inventory accuracy rate | معدل دقة المخزون | Taux de précision du stock | Envanter doğruluk oranı | The physical count divided by the book stock, shown as a percentage, measuring how closely the system matches reality. |
| Cycle count | الجرد الدوري | Inventaire tournant | Döngüsel sayım | Counting one small group of items on a regular rotating schedule, instead of counting the whole stockroom at once. |
| Inventory shrinkage | عجز المخزون | Démarque des stocks | Envanter firesi | Stock that is missing from a location without a recorded reason such as a sale or an approved transfer, distinct from a fabric's own shrinkage after washing. |
| Cost of inventory inaccuracy | تكلفة عدم دقة المخزون | Coût de l'imprécision des stocks | Envanter hatasının maliyeti | The share of an order's own planned margin lost to units the book stock claims exist but that are not actually there to sell. |
| Hybrid account | حساب مختلط | Compte hybride | Hibrit hesap | A buyer relationship that combines Make to Order and Make to Stock business with the same factory. |
| Combined decision view | عرض القرار المجمّع | Vue de décision combinée | Birleşik karar görünümü | A single tracker view that lines up every confirmed shortfall's count, cause and margin cost, so the largest real problem is visible at a glance. |
The next course moves from a single store's own stock accuracy to deciding which stock a retailer's own store network can share with its online channel, and when a store should fulfil an online order from its own shelf. Back to the course map