Cycle count planner by ABC class
Plan a cycle counting program by ABC class. Set count frequencies and see counts per year, counts per working day and the counter hours it will take.
Plan an inventory project
Calculator
ASCM defines cycle counting as “an inventory accuracy audit technique in which inventory is counted on a cyclic schedule rather than once a year,” often “more frequently for high-value or fast-moving items.” This planner turns an ABC count policy into daily work: how many counts per day it takes, and how many counter hours that is.
How to use the planner
- Classify items or locations into A, B and C. A common method ranks items by annual usage value (units used times unit cost) or by picks, and puts the small group at the top in A.
- Enter the number of items in each class. If you count by location and items live in several locations, enter locations.
- Set counts per year for each class, for example monthly for A (12), quarterly for B (4) and once a year for C (1).
- Counting days per year: working days on which counting happens, after holidays and any peak weeks when counting stops.
- Counts per hour: time a sample of real counts in each area before you trust this number.
The formula
Counts per year = (A items × A frequency) + (B items × B frequency) + (C items × C frequency)
Counts per working day = counts per year ÷ counting days (the results round this up)
Counter hours per day = counts per working day ÷ counts per hour
Example (fictional). A warehouse has 400 A items counted monthly, 1,100 B items counted quarterly and 3,500 C items counted once a year. It counts on 250 days a year, and one counter completes 30 counts an hour.
| Class | Items | Counts per year each | Counts per year |
|---|---|---|---|
| A | 400 | 12 | 4,800 |
| B | 1,100 | 4 | 4,400 |
| C | 3,500 | 1 | 3,500 |
| Total | 5,000 | 12,700 |
- Counts per working day: 12,700 ÷ 250 = 50.8, shown as 51
- Counter hours per day: 50.8 ÷ 30 = 1.7 hours
Reading the result
The program fits in under two hours of one person’s day. A items are 8% of the items but 38% of the counts, which is the point of an ABC program: effort goes where errors cost most.
Plan for more than the planner shows. Variances above tolerance need recounts, and recounts take longer than first counts because someone has to look for the missing stock. If one count in ten needs a recount, add about five counts a day to the example. Then check that the time exists on the floor, ideally in a quiet window when the locations are not being picked.
Making the program work
- Count at the right moment. Counting a location when its quantity is low, for example just before replenishment, is faster and finds errors sooner.
- Add triggered counts. A negative balance, a pick short from a location that should hold stock, or an unexpected zero are reasons to count now, outside the schedule.
- Track the result. Record each day’s accuracy with the inventory accuracy calculator or in your system.
- Find the cause. ASCM describes the key purpose of cycle counting as identifying items in error, “thus triggering research, identification, and elimination of the cause of the errors.” A program that only adjusts balances will count the same errors next month.
Common mistakes
- Frequencies chosen without checking labor. A policy that needs six hours a day will be dropped in the first busy week.
- C items never counted. Once a year is the floor. Do not let the class slip.
- Counting while picking continues in the same location, which creates false variances.
- Adjusting before a recount. Confirm large variances before they post.
- Forgetting multi-location items. An item in six locations is six counts if you count by location.
When the simple model stops working
- Very different count times by area, such as bulk floor stacks, small-parts bins and serialized items. Plan each area separately with its own counts per hour.
- Lot, serial or expiry control, where each count also checks identifiers and takes longer.
- Seasonal volume, where counting stops at peak and has to catch up afterward.
- Control groups and process audits, which add counts outside the ABC schedule.
When counts are written on paper and keyed in later, adjustments arrive late and the system shows stock that was already found missing. Building count tasks, scanning and approval rules into the WMS is part of inventory management software work, and the counters learn the new routine through onboarding and training.
Scope your project.
Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.