ABC Analysis: how to

ABC Analysis is a common management approach for prioritizing, classifying, or categorizing inventory. Inventory classification is usually based on an items price or cost times it’s usage or consumption quantity. Typically ‘A Items’ are the highest dollar quantity and represent 5 to 10% of the items and 50 to 70% of the total dollars. The ABC Analysis Principle is that A items are treated differently than C items.  A Items might be counted more frequently and have different planning parameters, higher inventory turns, higher safety stock and customer service levels.

  1. Make a list of part numbers
  2. Determine total quantity used over some period of time
  3. Obtaining the cost for each part
  4. Calculate usage $ value for each part by multiplying the quantity and the cost
  5. Sort the list from high to low $
  6. Calculate the total usage $ value for all items
  7. Calculate each item’s percent of total usage $ value
  8. Select percentage cut offs for each ABC group, for example:

Here’s an example …

Example of ABC Analysis

Next steps

Once you have classified your parts you can use this data to drive key materials management activities. For example, coordinating your perpetual inventory cycle counting program – you might routinely verify your Category A parts on a monthly basis but only review your category C parts twice a year.

You might use flow orders, kanban, or VMI for your C parts but require detailed negotiated purchase orders for your A parts.

In a warehouse you might want to be sure the A items are near the shipping dock and the C items are toward the back.

You might even want to take a close look at the C items and purge a few.

The main point is – one size doesn’t fit all parts, choose the materials management approach that best serves each inventory category.

4 thoughts on “ABC Analysis: how to

  1. Hi Lawrence, do you recommend to perform ABC analysis of all items by product family level? or do you mean all the raw materials across all product families?

    1. Wayne, ABC Analysis is a method for classifying and categorizing that can be applied in many ways. The warehouse would want to sort all items – raw materials, assemblies, and finished goods for inventory cycle counting and location slotting purposes. While a purchasing manager might only be interested in ABC’s for purchased items. One trouble is that most ERP systems have only one ABC class and so we often have to do the ABC analysis and catorigorization off line.

    1. 1. Total Annual Usage $ = sum of all items
      2. % Total Annual Usage = item annual usage / Total
      3. Cumulative % for item 1 = item 1 Total %, item 2 cumulative % = item 1 + 2, item 3 cumulative = cumulative % for item 2 + annual % for item 3, and so on

Leave a Comment ...