Inventory ABC Analysis
Input Data
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item 1 410 $0.75 $307.50 0.63% 0.63%
Item 2 330 $17.00 $5,610.00 11.49% 12.12%
ABC Analysis: Items sorted in descending order by dollar volume
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item
Item 5 240 $110.00 $26,400.00 54.07% 54.07%
A
Item 9 100 $125.00 $12,500.00 25.60% 79.67%
A
B
B
C
C
C
C
C
Problem 12-39