ABC analysis

profileBrian_1234
ABC.xlsx
Home>Business & Finance homework help>Operations Management homework help>ABC analysis

Sheet1

Item Annual Usage Unit Cost Usage value % of total value Classify
8 9000 44.9 404100 35.63% A
9 5800 35.62 206596 18.22% A
2 6200 32.6 202120 17.82% A
3 8500 10.2 86700 7.64% B
10 820 82.6 67732 5.97% B
1 2400 19.51 46824 4.13% B
6 750 55.7 41775 3.68% B
7 8200 3.6 29520 2.60% C
5 6000 4.5 27000 2.38% C
4 3200 6.8 21760 1.92% C
1134127

Sheet2

Sheet3