Inventory ABC Analysis
Input Data
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
A1750 $10.00 $17,500.00 1.61% 1.61%
B300 $1,500.00 $450,000.00 41.38% 42.99%
ABC Analysis: Items sorted in descending order by dollar volume
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item
B300.000 1500.000 $450,000.00 41.38% 41.38%
A
A
I3000.000 50.000 $150,000.00 13.79% 78.16%
B
B
B
C
C
C
C
Problem 12-40