solve in Excel

need a chart in this issue

TASK 1 (25 Marks) A construction company stores various construction materials in its central stores as shown in below table Item Average Annual Consumption (Units) Average Cost Per Unit (OMR) 50000 45 B 10000 90 20000 225 D 40000 12 E 5000 300 F 60000 63 G 20000 67 H 40000 19 1 5000 375 J 25000 105 K 20000 105 L 5000 188 M 10000 150 N 10000 122 O 24000 100 P 16000 15 60000 20 R 50000 5 S 30000 6 27000 2 Classify the inventory by using ABC Analysis and help the company to utilize the materials efficiently TASK 1 (25 Marks) A construction company stores various construction materials in its central stores as shown in below table Item Average Annual Consumption (Units) Average Cost Per Unit (OMR) 50000 45 B 10000 90 20000 225 D 40000 12 E 5000 300 F 60000 63 G 20000 67 H 40000 19 1 5000 375 J 25000 105 K 20000 105 L 5000 188 M 10000 150 N 10000 122 O 24000 100 P 16000 15 60000 20 R 50000 5 S 30000 6 27000 2 Classify the inventory by using ABC Analysis and help the company to utilize the materials efficiently