Skip to content

ABC analysis for your inventory: where to focus when you have 3,000 items and one afternoon

A handful of items make most of your revenue; a long tail makes almost none. ABC analysis sorts them in an hour so you can guard the winners, simplify the tail and stop treating every item the same.

By Wameed field teamOnboarding and support

5 min read

In short: ABC analysis ranks your items by value and splits them into three classes:A (about 10–20% of items producing about 70–80% of revenue),B (the next 20–30% producing about 15–20%) andC (the long tail, about half the items, producing 5–10%). Run it by exportingsales by item for 6–12 months, sorting by revenue, and calculating cumulative percentages. Then treat the classes differently:A gets tight reorder points, weekly counts and never runs out;B gets standard rules;C is bought on demand, counted rarely and pruned. The exact percentages vary; the principle does not.

You cannot give 3,000 items equal attention. ABC tells you where attention pays.

The principle

The Pareto rule says a small share of causes produces most of the effect. In a shop, a small share of items produces most of the revenue (and often the profit). Managing all items the same wastes effort on the tail and under-protects the head.

How to run it, step by step

Step 1: get the data

Exportsales by product for the last 6–12 months, with units, revenue and, if possible, margin. Wameed’s sales and inventory reports give you sales by product, stock valuation and turnover that you can export to a spreadsheet. Seereports that matter.

Step 2: sort by revenue

Sort descending by revenue (or by margin if you want a profit-based ABC).

Step 3: calculate cumulative share

For each item:

  • Share = item revenue ÷ total revenue.
  • Cumulative share = running total of shares.

Step 4: draw the lines

ClassCumulative revenueTypical share of items
Aup to about 70–80%10–20%
Bnext about 15–20%20–30%
Clast about 5–10%50–70%

Use the thresholds that suit your trade; a boutique and a supermarket differ.

Step 5: add context

Before you act, flag:

  • New items that have not had time to sell.
  • Seasonal items in the off-season.
  • Items sold out during the period.
  • Strategic items (traffic drivers, loss leaders).

A worked example

A shop sells 1,000 items with SAR 1,000,000 in revenue.

ClassItemsRevenueShare of revenue
A150 (15%)SAR 780,00078%
B250 (25%)SAR 170,00017%
C600 (60%)SAR 50,0005%

Six hundred items produce SAR 50,000: SAR 83 each over the year. Those C items take shelf space, counting time and cash. Meanwhile, a stock-out on one A item may cost more than the revenue of fifty C items.

How to manage each class

ABC
Availability goalNever outHighAcceptable to be out
Reorder pointTight, with safety stockStandardOrder on demand
Count frequencyWeeklyMonthlyQuarterly or at annual count
SupplierBest terms, a backup supplierStandardConsolidate or drop
PricingWatch competitorsReview quarterlyClearance candidates
DisplayPrime positionStandardBack or online only
ReviewMonthlyQuarterlyTwice a year

Seereorder points and safety stock,stock count how-to andslow-moving stock clearance.

Variations

A profit-based ABC

Rank bygross margin rather than revenue. A product with low revenue and high margin may matter more than it looks; a high-revenue, low-margin item may be a traffic driver rather than a profit centre.

XYZ: how predictable is demand?

Add a second dimension,X (steady),Y (variable),Z (erratic). An AX item (high value, steady demand) is easy to automate; a CZ item (low value, erratic) should be bought only when a customer asks.

ABC by category

Run the analysis within each category, so a niche category is not overwhelmed by a larger one.

What to do with the C tail

  1. Prune. Remove items that have not sold in a year, after clearance.
  2. Consolidate suppliers and order less often, together.
  3. Special-order rather than stock.
  4. Check for hidden winners: some C items are new or were out of stock.
  5. Keep a few for range, where they bring customers in.

What to do with the A items

  1. Never let them stock out. Safety stock and a backup supplier.
  2. Protect margin. Negotiate; watch price changes.
  3. Count them weekly, because errors here matter most.
  4. Secure them against theft. Seeshrinkage in Saudi retail.
  5. Feature them in the shop and online.

Common mistakes

  • Running it once and forgetting it.
  • Treating new items as C.
  • Pruning strategic items.
  • Ignoring seasonality.
  • Using revenue only when margin tells a different story.

A 90-minute plan

MinutesTask
0–20Export sales by product, 12 months
20–40Sort, calculate shares, assign classes
40–60Flag exceptions
60–80Set count frequency and reorder rules per class
80–90List 20 C items to clear

Frequently asked questions

What are the A, B and C percentages?

Roughly 70–80%, 15–20% and 5–10% of revenue; the exact split depends on your trade.

Does Wameed produce an ABC report automatically?

You can export sales by product, valuation and turnover reports and classify in a spreadsheet.

How often should I redo it?

Quarterly, and before peak seasons.

Should I stop selling C items?

Not automatically. Prune the dead ones and keep those that serve a purpose.

  • #تحليل ABC
  • #تصنيف المخزون
  • #قاعدة باريتو للمخزون
  • #ترتيب أولويات المخزون
  • #ABC analysis
  • #inventory classification
  • #Pareto stock

Share this article

Ask about your own shop

Thirty minutes on your products, your tax setup and your hardware — not a slide deck.

Keep reading