Conducting an ABC Analysis

Analyze the following data to produce an ABC classification based on annual dollar spend Part A: Supplier Name Annual Dollar Spend Texas Instrument $131,890.00 Murata 561,270.00 3M 3,444.00 Emerson Network Power 84,930.00 Fairchild Semiconductor 427,490.00 Celestica Corporation 5,000.00 Mabuchi Motors 6,344.00 Volex 190,562.00 Tyco Electronics 19,672.00 Pegatron 34,000.00 Seiko 100, 112.00 Sharp Electronics 3,022.00 Supplier Name Annual Dollar Spend Classification Texas Instrument $131,890.00 Murata 561,270.00 3M 3,444.00 Emerson Network Power 84,930.00 Fairchild Semiconductor 427,490.00 Celestica Corporation 5,000.00 Mabuchi Motors 6,344.00 Volex 190,562.00 Tyco Electronics 19,672.00 Pegatron 34,000.00 Seiko 100, 112.00 Sharp Electronics 3,022.00Part Unit Unit Annual Number Usage Cost Dollar Usage 1 1,100 $2.00 600 40.00 3 100 4.00 1,300 1.00 5 100 60.00 6 10 25.00 100 2.00 8 1,500 2.00 9 200 1.00 10 500 1.00 Part Annual Cumulative Cumulative Number Dollar Dollar Percentage Classification Usage Usage Usage 10 TOTAL