Skip to content
Inventory Management | Part 7 of 8

Cycle Counting and Inventory Accuracy

Count a few items every day by ABC class, measure record accuracy against a tolerance and correct the causes of deviations, not only the quantities.

Every parameter in materials planning assumes that the system knows how much is on the shelf. A reorder point of 2,485 units is worthless if the system shows 3,000 and the bin holds 2,200.

Wrong records are a hidden cause of both stockouts and excess. Cycle counting checks them a few items at a time, all year.

The idea

Instead of counting everything once a year, count a small number of items every day. Each item is counted several times a year, according to its class.

Class Counts per year Tolerance Items in the plant Counts per year in the plant
A 4 0 % 180 720
B 2 2 % 300 600
C 1 5 % 720 720
Total 1,200 2,040

For the drive unit plant that is 2,040 counts per year. In 50 working weeks it means 41 counts per week, about eight per day. One person needs less than an hour a day.

Record accuracy

Record accuracy = counts within tolerance / all counts

In the example plant, 43 of the last 50 counts were within tolerance: 86 percent. That sounds high. It means that one record in seven is wrong enough to trigger a wrong order. The goal is 97 percent.

Measure the figure every month and show it next to stockouts and stock value. A plant that only corrects quantities will find the same deviations again next quarter, so the causes matter more than the count.

Six rules for the count

  1. Count blind. The counter does not see the book quantity.
  2. Count when stock is low. At the reorder point or when a bin is empty, the count is fast and exact.
  3. Recount every deviation outside the tolerance before anything is corrected.
  4. Find the cause before you correct the quantity.
  5. Record the cause with a code.
  6. Fix the process behind the most frequent code.

The usual causes

A short list of codes is enough:

  • Missed booking: material was taken or put away without a transaction.
  • Wrong quantity booked: a typing error or a full pack booked for a partial withdrawal.
  • Wrong unit: pieces against packs, meters against rolls.
  • Wrong location: the stock exists, in another bin.
  • Mixed parts: similar parts in one bin, typically old and new versions.
  • Damage or loss: scrap that was never booked.

Count the codes every month. In most warehouses two of them explain more than half of the deviations, and both have a process fix: a scan at the withdrawal point, a clear unit on the bin label, a separate location for every version.

Start small

Begin with the A items of one group. In the pilot group of 40 items the plan is short: 9 A items four times, 8 B items twice and 23 C items once give 75 counts per year, fewer than two per week.

Counting and the annual inventory

Many companies want cycle counting to replace the annual stocktake with its shutdown weekend. Whether that is possible depends on the accounting rules that apply to you and on your auditor. Clarify it before you change the method.

The operational benefit does not depend on the answer. Records that are right 97 times out of 100 make every parameter in the system trustworthy.

Newsletter

One Lean idea.
Every two weeks.