Frequently asked questions

How often should you cycle count A items?

There is no standard figure. Oracle, SAP and Microsoft's warehouse software all leave it as a setting: a number of counts per year, or days between counts. Monthly, 12 a year, is a reasonable starting point, and vendor guides suggest anything from weekly to quarterly. The right number is the one your counting hours can sustain, adjusted by the errors the counts find.

What is ABC cycle counting?

It is cycle counting with the count frequency set by class. Items are ranked by a measure such as annual usage value, the units used in a year times the unit cost. The small group at the top that carries most of the value is class A and is counted most often; the long tail is class C and is counted least. B sits in between.

How do you calculate how many cycle counts to do per day?

Multiply the number of items in each class by its counts per year, add the classes, and divide by your working days. 200 A items counted 12 times, 400 B items 4 times and 1,400 C items once make 5,400 counts a year; over 250 working days that is about 22 counts a day.

What does "every 60 working days" mean for a cycle count?

It is a frequency written as an interval. SAP converts the number of counts per year into a number of working days on the plant's factory calendar, so on a 240-working-day calendar 4 counts a year becomes every 60 working days. Divide the working days in your year by the interval to get the counts per year back.

What is a hit or miss in cycle counting?

A hit is a count that lands within the tolerance set for the item; a miss is one outside it. In Oracle Inventory the tolerance is a positive and negative percentage of the system on-hand quantity, and hit or miss is judged on the first count only, not on recounts. The hit rate is hits divided by counts.

Does cycle counting replace the annual stock take?

It can. Oracle's documentation says cycle counting can replace a complete physical inventory or run alongside it. Whether yours may depends on your auditors and the controls around the records. Auditing standards expect inventory to be counted at least once a year, and allow counts at other dates where those controls are effective.

Should the counter see the expected quantity?

Preferably not. A count made while looking at the system figure drifts toward it. Microsoft's warehouse app never shows the expected quantity during a cycle count, and its documentation says the design prevents intentional miscounts. Record the count first, compare it with the book quantity afterwards, and recount any line that disagrees.

What is the difference between a cycle count and a stock take?

A stock take, or full physical inventory, counts every item at one moment, usually with trading stopped. A cycle count counts a planned slice of items each day or week while the business keeps running, so every item is counted at least once over the year and errors are found within weeks of happening rather than at year end.

People also search for

Count the day's list against the book

The inventory counter keeps one line per item with the counted and book quantities side by side, flags every line that disagrees and gives the share of lines that match exactly.