Recalculating ABC codes for Cycle Counting

We are starting up our cycle counting process here in Denver and have many new parts created each month. I see there is a Parts Missing ABC codes report and so my question is how often should the Recalculate ABC codes process be run? I can see where running this each year is a minimum, but is any one out there running this recalc quarterly?

it feels like once a year is not enough with the amount of new parts we have.

Also I see that duplicating parts copies in the original parts ABC code.

Thanks in advance.

Brad

@BoostERP,
I usually recommend running the recalc at least quarterly, even if it’s just to review the recommended rankings, NOT to update. But it really depends on the company’s inventory turns. It doesn’t hurt to review the report monthly.
I have at least two clients which recalc their ABC codes quarterly. (Side note, they also run the Safety/Min/Max Recalc quarterly as well).

I personally do not have a problem with running this monthly… there are several thoughts on this, and it is one that brings up arguments on both sides… here is my argument.

  1. ABC Codes are purely to decide what items should be counted and how often
  2. ABC codes are defined based mostly on dollar value of stock plus volume
  3. IF an item has increased in value/volume during the past month, and it now calculates to an “A”, where before, it was a “B”, Shouldn’t it be counted more often?
  4. If an item no longer falls into the “A” category, and drops to a “B” because of the item above, is that really a problem?

To me, its simple… the items will float (or sink) from one level to another as their use changes over time. but it will still be counted regularly, based on its current ABC Code.
(FYI, if you disagree with me, you might be wrong :grin:)

2 Likes

Thank you both for the feedback I think the monthly review and quarter updates will be a good starting point.

1 Like

Although you are completely correct, I think you’re wrong, Tim.

Wrong

1 Like

Hey Tim,

You wouldn’t happen to know the exact components of the ‘volume’ component of that equation, would you?
In my testing, it looks like it is the summed values of transactions for the period of the report, but I’m not certain which specific transactions are counted. I would think product movement type transactions (MFG-STK, STK-CUS…) would be included, but are cost adjustments (ADJ-CST)??

One would think I could just add these things up and answer my own question… I can’t seem to match the numbers in the Calculate ABC Codes report.

Hello… I am new to the group and new to using Epicor. I updated our ABC percentages and let the process run. Unfortunately if I run a report it doesn’t seem to have worked. I have no B’s. Any procedures on how to do this?