ABC inventory management is a method for classifying items according to their relative importance.

For the given inventory data that follows, determine which items are type A, type B, and type C.

Please provide answer in excel with formulas and explanation

Transcribed Image Text:

Cumulative % Cumulative % Part Line Average Weekly Sales Cost ($ Value) Dollar Volume Dollar Volume SKU $1.00 ABC Classification 1. 21,000 $21,000 4,000 $40.00 $160,000 1,600 $3.00 $4,800 4 12,000 $1.00 $12,000 1,000 $100.00 $100,000 50 $50.00 $2,500 7 800 $2.00 $1,600 8 10,000 $3.00 $30,000 4,000 $1.00 $4,000 10 5,000 $1.00 $5,000 11 250 $2.00 $500 12 1,900 $55.00 $104,500 9, Cumulative % Cumulative % Part Line Average Weekly Sales Cost ($ Value) Dollar Volume Dollar Volume SKU $1.00 ABC Classification 1. 21,000 $21,000 4,000 $40.00 $160,000 1,600 $3.00 $4,800 4 12,000 $1.00 $12,000 1,000 $100.00 $100,000 50 $50.00 $2,500 7 800 $2.00 $1,600 8 10,000 $3.00 $30,000 4,000 $1.00 $4,000 10 5,000 $1.00 $5,000 11 250 $2.00 $500 12 1,900 $55.00 $104,500 9,

Answer rating: 100% (QA)

Part Line Average Weekly Sales CostValue Dollar Volume Cumu... View the full answer