SHOW ALL STEPS AND FORMULAS PLS

Question #2 10 marks Determine the ABC ranking for each of the below items Item Unit Cost Annual Sales Units 22001 $ 2.50 500 22002 $ 10.50 500 22003 $ 7.50 750 22004 EA $ 3.25 100 22005 $ 5.25 900 22006 $ 0.05 12,000 22007 $ 0.75 1,000 22008 $ 120.00 5 22009 $ 100.00 10 22010 $ 12.00 3 22011 $ 7.00 20 22012 $ 16.00 12 22013 $ 2.00 410 Copy and paste the items into the table below. Use this table to sort and rank the items, calculate the appropriate percentages, and determine the ABC classification of each item Item Unit Cost Annual Annual % of Cumulative ABC Ranking Sales Units $ Sales total $ sales %