Inventory Cycle Count: Reconcile the Snapshot and Recount

Identify exactly what is being counted

Use fictional item PK-8, location Shelf B2, measured in individual pieces. The system snapshot at 10:00 records 80 pieces. The counting team finishes at 10:10. Assume the two movements below are confirmed to have physically occurred at this location before completion.

Align the record to the physical count time

Under these facts, expected stock at 10:10 is 80 + 12 − 7 = 85 pieces. Comparing the first 83 count directly with the 10:00 snapshot would produce a misleading +3 difference because it ignores the intervening movements.

Against the time-aligned expected quantity of 85, the first count variance is 83 − 85 = −2 pieces. The comparison assumes the movement times and quantities are correct. If a movement’s timing is uncertain, retain that uncertainty instead of silently assigning it to one side of the count.

Use the recount as new evidence

With no intervening movement, the recount of 84 is compared with the same expected 85. The remaining difference is −1. The recount changes the physical observation; it does not change either confirmed movement.

Preserve the first count, recount, who performed them and their timestamps. An unexplained average of 83 and 84 would create 83.5 pieces, which is neither an observed count nor a sensible resolution for this whole-piece fixture.

Write a count exception that someone can follow

ASCM Oregon describes cycle counting as a way to find and address causes of inventory errors. Our exercise does not establish the cause of this remaining difference. A missing piece, a wrong recorded location and a count error would require different evidence.

Keep counting and adjustment distinct

Do not declare theft or write off stock from the variance alone. Follow the operation’s investigation and approval process. This teaching case supplies no policy allowing the counter to replace the system quantity automatically.

For a useful variation, hold all movements fixed and change the recount to 85. The second count then agrees with the time-aligned record, but the first count remains part of the audit trail. Explain why that is a resolved count comparison rather than proof that all other inventory records are correct.