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

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,