Inventory ABC Analysis
Input Data
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
U1 1110 $2.00 $2,220.00 2.21% 2.21%
V2 1110 $5.40 $5,994.00 5.96% 8.17%
ABC Analysis: Items sorted in descending order by dollar volume
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
X4 1104 $74.54 $82,292.16 81.87% 81.87%
Problem 12-29