Purchase classes drive how much safety stock each item carries. When they drift, fast movers run short and slow movers tie up cash. This guide runs a full ABC review in one prompt and returns only the item-locations whose class should change.
Recurrency doesn't assign ABC classes. Cue a reads the current purchase class from your ERP and proposes a new one. You apply the changes in your ERP.
⏰ Time: about 10 minutes.
Before you start
Start a new chat on the Cue module.
Decide your cutoffs. This guide uses A = top 80% of usage value, B = next 15%, C = the rest. Change them to match how you define A/B/C today.
Be specific. A vague question can get a confident answer from the wrong field. The prompt below names every field and rule so nothing is left to guess.
Results cap at 500 rows. Ask for the exceptions, not every item-location.
Step 1: Run the reclass
Copy this prompt and adjust the cutoffs if needed.
Reclassify stockable, non-discontinued item-locations using trailing-12-month usage value, calculated separately for each location.
Usage value = usage quantity × unit cost, from monthly usage over the last 12 complete months. Ignore discontinued items and items that are not stockable.
Within each location, rank item-locations by usage value:
- A = the items that make up the top 80% of that location's usage value
- B = the next 15%
- C = the remaining 5% Items with zero usage value are C.
Compare that proposed class to the current purchase class. Return only the mismatches.
Give me a short summary of how many item-locations would move up and how many would move down, then a downloadable table with item code, item name, location, current purchase class, proposed class, annual usage quantity, annual usage value, and that item's share of the location's usage value. If there are more than 500 mismatches, give me the first 500 sorted by absolute usage value and tell me how to get the next page.
Step 2: Read the result
Moving up (C to B, B to A): under-protected. These are the stockouts you haven't had yet.
Moving down (A to B, B to C): carrying more safety stock than they've earned.
If the summary says there are more than 500, ask for the next page before you download.
Step 3: Spot-check before you apply
Click a few items to open them in Planning. If a number looks off, ask:
How did you calculate usage value for [item code] at [location]?
Tips
Too many mismatches to review at once? Run one location: add "for [location] only" to the first line.
Want the biggest moves first? Follow up with: "Only show item-locations moving into A."
Rerun after each month closes to catch drift early.
What happens next
Cue is read only. It can't change purchase class. Use the downloaded table to update classes in your ERP, then rerun the prompt to confirm the mismatches are gone.