Question: Q10. Given the following inventory information, construct an (a) ABC analysis by annual dollar usage, (b) ABC analysis by current inventory value, and (c) an

Q10. Given the following inventory information,

Q10. 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? (6 points) UNIT COST (5) 32.00 6.00 ITEM NUMBER A967 B886 (314 1879 E536 F876 G112 ANNUAL USAGE (UNITS) 1 100 32 54 125 CURRENT INVENTORY (UNITS) 4,500 8,000 115 254 120 5.25 12.50 0.05 0.07 423 500 0.12 1,008 H098 J125 K966 L242 M455 NO07 P231 0954 T633 W985 X221 Y321 2633 1.22 5.25 0.25 1.00 5.50 7.21 5.25 3.25 70.00 0.75 1.50 32.00 4.00 500 235 6,500 4,000 1,500 2,000 54 32 25 500 800 8,000 1,000 3,500 750 120 1,000 375 500 525 300 240 800 20,000 2,000 500 125

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!