spreadsheet problem

Operations issues in Supply Chain Management 17. Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory value, and (c) an ABC inventory matrix. Is the firm stocking the correct inventories? ANNUAL USAGE (UNITS) CURRENT INVENTORY (UNITS) ITEM NUMBER UNIT COST ($) 6.00 5.25 100 8,000 120 6,500 4,000 1,500 1,000 2,000 B8867 J1252 K9667 L2425 M4554 16334 W9856 X2215 Y3214 Y6339 375 500 800 20,000 100 5.50 70.00 0.75 1.50 32.00 4.00 500 2,000 800 8,000 1,000 3,500 500 125