Inventory ABC Analysis
Input Data
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
A1500 $4.00 $6,000.00 16.76% 16.76%
B1500 $1.00 $1,500.00 4.19% 20.95%
C700 $3.00 $2,100.00 5.87% 26.82%
ABC Analysis: Items sorted in descending order by dollar volume
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item
I1200 $8.00 $9,600.00 26.82% 26.82%
A
A1500 $4.00 $6,000.00 16.76% 43.58%
A
A
B
B
C
C
C
C
Problem 12-41