This is a 3 part question, please show work in excel to help me understand

Southern Markets Inc. is considering the use of ABC analysis to focus on the most critical SKUs in its inventory. Currently, there are approximately 20,000 different SKUs with a total dollar usage of $10,000,000 per year. a. What would you expect to be the number of SKUs and the total annual dollar usage for A items, B items and C items at Southern Markets, Inc.? Number of A items = number) Dollar usage for A items =$ nearest whole number) Number of B items = number) Dollar usage for B items =$ nearest whole number) (Enter your response rounded to the nearest whole (Enter your response rounded to the (Enter your response rounded to the nearest whole (Enter your response rounded to the (Enter your response rounded to the nearest whole (Enter your response rounded to the Number of C items = number) Dollar usage for C items =$ nearest whole number) c. Rank the SKUs in descending order on the bais of their annual dollar usage and full in the table with the ranked SKUs percentage of dollar usage (Enter your response rounded to two decimal places) Based on the percentages of dollar usage. the class of U404 is Based on the percentages of dollar usage. the class of A.104 is Southern Markets Inc. is considering the use of ABC analysis to focus on the most critical SKUs in its inventory. Currently, there are approximately 20,000 different SKUs with a total dollar usage of $10,000,000 per year. a. What would you expect to be the number of SKUs and the total annual dollar usage for A items, B items and C items at Southern Markets, Inc.? Number of A items = number) Dollar usage for A items =$ nearest whole number) Number of B items = number) Dollar usage for B items =$ nearest whole number) (Enter your response rounded to the nearest whole (Enter your response rounded to the (Enter your response rounded to the nearest whole (Enter your response rounded to the (Enter your response rounded to the nearest whole (Enter your response rounded to the Number of C items = number) Dollar usage for C items =$ nearest whole number) c. Rank the SKUs in descending order on the bais of their annual dollar usage and full in the table with the ranked SKUs percentage of dollar usage (Enter your response rounded to two decimal places) Based on the percentages of dollar usage. the class of U404 is Based on the percentages of dollar usage. the class of A.104 is