Step 1: Determine annual usage/sales for each item
Step 2: Determine the percentage of the total usage/sale by item
Step 3: Rank the items from highest to lowest percentage
Step 4: Classify the items into ABC categories
▶ Class A: 15% of item accounts for 70% – 80% of sales.
▶ Class B: 30% of items accounts for 15% – 25% of sales
▶ Class C: 55% of items accounts for 5% of sales
Item
Percent of
Number of
Items Stocked
Annual Volume
(unit)
Unit Cost = Annual Dollar
Volume
Percent of
Annual Dollar
Volume
Clas
s
#10286 17.5% 1,000 $90.00 $90,000 38.8% 72
%
A
#11526 500 154.00 77,000 33.2% A
#12760
33.9%
1,550 17.00 26,350 11.3% 23
%
B
#10867 350 42.86 15,001 6.4% B
#10500 1,000 12.50 12,500 5.4% B
#12572
48.6%
600 14.17 8,502 3.7%
5%
C
#14075 2,000 .60 1,200 0.5% C
#01036 100 8.50 850 0.4% C
#01307 1,200 0.42 504 0.2% C
#10572 250 0.60 150 0.1% C
8,550 $232,057 100.0%
A graphic representation of ABC analysis can be shown as below:
Other criteria than annual dollar volume may be used
oHigh shortage or holding cost
oAnticipated engineering changes
oDelivery problems
oQuality problems
Policies employed may include
oMore emphasis on supplier development for A items
oTighter physical inventory control for A items
oMore care in forecasting A items
Example 12.1: Omega Corporation is a small manufacturer of computer connectors in
Raleigh, North Carolina. The materials which go into a connector are summarized
below:
Material Annual usage Unit cost ($)
A-2 3,870 0.25