Question: Instructions: You work as a supply chain analyst for a manufacturing company that produces electronic components. Your supervisor has asked you to conduct an ABC

Instructions: You work as a supply chain analyst for a manufacturing company that produces electronic components. Your supervisor has asked you to conduct an ABC analysis of the company's inventory to identify the most important items and prioritize them for management.

Using the provided inventory data (see below), conduct an ABC analysis and answer the following questions:

What percentage of total inventory value is represented by the A, B, and C categories?

Which items should be classified as A, B, and C based on the ABC analysis? What are the respective inventory values and percentages for each category?

Based on the ABC analysis, what recommendations would you make to the company regarding inventory management and control?

Inventory Data:

Item Number Description Quantity on Hand Unit Cost
1001 Resistor 5,000 $0.10
1002 Capacitor 2,500 $0.20
1003 Diode 1,000 $0.30
1004 Transistor 750 $0.40
1005 Integrated Circuit 500 $0.50
1006 Connector 250 $0.60
1007 Battery 100 $1.00
1008 LED 50 $1.50

Rubric:

Criteria Points
Accuracy of ABC analysis calculations 4
Correct classification of items as A, B, or C and corresponding inventory values and percentages 3
Quality of recommendations for inventory management and control based on ABC analysis 2
Overall clarity, organization, and professionalism of presentation 1

Total Points: 10

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!