Solve in excel plz

7. Lynne Chappell manages the inventory of supplies in a large hospital. To determine which items should be closely monitored, Lynne decided to use the ABC classification scheme to group the items on the basis of their value. As the following table shows, she took a random sample of 20 items and recorded the annual usage and unit cost of each. How should cach item be classified? Unit Cost Unit Cost Inventory (inU.S. Annual Inventory inU.S. Annual dollars) Usage tem 800 R82 70 G65 50 100 L 90 M94 50 130 V45 30 170 T62 200 117 80 70 200 80 80 20 P21 A12 K43 50 60 220 70 30 180 076 E27 90 W22 30090 H19 010 520 120 037 700 100 N88 5 100