8.6 Inventory Record Accuracy, Cycle Counting & Excess Disposition

Inventory Record Accuracy, Cycle Counting & Excess Disposition

Every model in this chapter — economic order quantity, reorder point, safety stock, MRP netting, multi-echelon positioning — consumes one input: the inventory record. If the record is wrong, every downstream calculation is wrong, and no amount of modelling sophistication rescues it. This is the least glamorous and most consequential topic in materials management.

---

Measuring Accuracy Correctly

Inventory record accuracy (IRA) is the percentage of records where the counted quantity matches the system quantity within a defined tolerance:

$\text{IRA} = \frac{\text{Records within tolerance}}{\text{Records counted}} \times 100$

Three rules the exam tests:

1. Measure by part and location, not by total value. A location holding 60 units where the system says 50, and another holding 40 where the system says 50, net to a perfect total value with two wrong records and two future stockouts. Value comparison hides exactly the errors that cause operational failure.
2. Define tolerance by item, and keep it tight. Tolerances are typically zero for serialized and high-value items and small percentages for bulk or weight-counted material. A tolerance loose enough to pass everything measures nothing.
3. Count the location, not the item across locations. An item that is right in total but in the wrong location will still fail a directed pick.

Typical targets: 99%+ for A items, 97–98% for B items, 95%+ for C items — and 100% for serialized, lot-controlled, regulated, or hazardous material where traceability is a legal obligation rather than an efficiency measure.

What Inaccuracy Actually Costs

• Stockouts on items the system says are available — the most damaging outcome, because no replenishment was triggered.
• Excess inventory from ordering against understated on-hand.
• Expediting and premium freight to recover from surprise shortages.
• Lost productivity — pickers travelling to empty locations, and searches that consume more time than the pick.
• MRP degradation — inaccurate on-hand quantities corrupt every netting calculation down the bill of material.
• Loss of user trust, after which planners build private spreadsheets and informal buffers, and the formal system quietly stops governing anything.

---

Cycle Counting vs. Annual Physical Inventory

The core exam point: cycle counting's purpose is not to adjust the books. It is to find and eliminate the process failures that create errors. An organization that counts diligently and adjusts every discrepancy without investigating causes will count the same errors forever. The adjustment is the symptom; the root cause is the deliverable.

Designing the Program — ABC-Based Frequency

Worked sizing. A facility holds 6,000 SKUs: 600 A items counted 12 times a year, 1,400 B items counted twice, and 4,000 C items counted once. $(600 \times 12) + (1{,}400 \times 2) + (4{,}000 \times 1) = 7{,}200 + 2{,}800 + 4{,}000 = 14{,}000 \text{ counts per year}$ Across 250 working days that is 56 counts per day — a workload that must be resourced deliberately, not absorbed as an afterthought. A programme designed without this arithmetic is abandoned within a quarter.

Trigger-based counting supplements the schedule: count when the balance reaches zero, when a negative balance occurs, when a pick shortage is reported, after a cycle-count adjustment on a related item, and when an item is received or issued for the first time in a long period. Zero-balance counting is particularly efficient because verifying an empty location is fast.

---

Root Causes of Record Error

The correctable majority: in most manual operations, transaction and process errors substantially exceed theft as a cause of record inaccuracy. Organizations that treat every discrepancy as a security problem invest in surveillance and miss the far larger and cheaper win available from scanning, directed put-away, and issue discipline.

---

Excess and Obsolete Inventory Disposition

Excess inventory is more than foreseeable demand requires; obsolete inventory has no foreseeable demand at all. Both are identified by aging analysis — value by months of supply and by months since last movement — and both must be actively dispositioned, because inventory that is never reviewed is never written down and quietly overstates the balance sheet.

The Disposition Ladder, Highest Recovery First

1. Redeploy internally to another plant, region, or business unit that has demand.
2. Return to supplier under a stock rotation, buy-back, or return-for-credit clause — which only exists if it was negotiated into the agreement in advance.
3. Use in service, spares, or warranty applications.
4. Rework or upgrade into a currently saleable configuration.
5. Sell through secondary markets — brokers, liquidators, surplus auctions.
6. Sell to employees or discount channels, where brand policy permits.
7. Donate for the applicable tax treatment.
8. Recycle or reclaim material value.
9. Scrap — the last resort, and for regulated or brand-sensitive goods a certified destruction with documentation.

Accounting reality the exam expects: the loss occurred when the inventory became unsaleable, not when it is physically removed. Under lower-of-cost-or-net-realizable-value principles, impaired inventory should be written down when it is identified. Delaying the write-off to avoid recognizing the loss keeps overstated assets on the balance sheet and — more damagingly for supply management — leaves the material occupying space, consuming cycle-count effort, and hiding the demand-planning failure that created it.

Preventing the Next Batch

• Aging reports reviewed on a fixed cadence with a named owner and an action decision on each line.
• Negotiated return and stock-rotation rights in supply agreements, particularly for distributors and for items with obsolescence risk.
• Cancellation and liability windows defined at contract signature, so a demand change does not automatically become a raw-material liability.
• Phase-out planning synchronized to component lead times, as covered in life-cycle management.
• Root-cause review of each write-off — was it a forecast failure, a phase-out planning failure, an engineering change, or a minimum-order-quantity artefact? Each has a different and correctable remedy, and the disposition is worth nothing if the cause survives.