Inventory ABC Analysis
Input Data
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item 1 560 $150.00 $84,000.00 83.50% 83.50%
Item 2 490 $4.10 $2,009.00 2.00% 85.49%
ABC Analysis: Items sorted in descending order by dollar volume
Volume Unit cost Dollar volume
% Dollar
volume
Cumulative $-
vol %
Item
Item 1 560.000 150.000 $84,000.00 83.50% 83.50%
A
B
B
C
C
Problem 12-42
Inventory EOQ Model
Input Data
Demand rate, D 560
Problem 12-42 (Item 1)
Inventory EOQ Model
Input Data
Demand rate, D 600
Problem 12-42 (Item 4)
Inventory EOQ Model
Input Data
Demand rate, D 450
Results
Economic order quantity, Q* 99.09
Maximum inventory 99.09
Problem 12-42 (Item 6)