Question 1 0/10 Bubmit Excel Online Structured Activity: Inventory Classification The data for 10 inventoried items of a small company has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop inventory classification based on annual Inventory dollar usage and answer the following questions. (Note: This example illustrates that judgment must be applied when using the ABC classification method, and the 80/20 rule should only be used as a general guideline.) Open spreadsheet Questions 1. Calculate the percent of total dollar usage for each item. Round your answers to two decimal places. Classification by Annual Dollar Usage Item Number A246 N376 CO24 R116 R221 P112 8615 T049 1519 1227 Percent of Total Dollar Usage 2. What is the total projected annual dollar usage? Round your answer to the nearest cent A-Z O paly Microsoft Excel Activity #1: Inventory Classification Question 0:10 Buni BEZL P112 8615 $ 049 T519 L227 2. What is the total projected annual doilar usage? Round your answer to the nearest cent 3. Complete the following table by entering the number of items in each category and their percentage of total number of items under ABC clas Do not round intermediate calculations. Round your answers to the nearest whole number Count Percentage Jearch this course 4. Complete the following table by entering the percent of total annual doilar usage of items in each category. Round your answers to two decimal places Percent of Total Annual Dollar Usage Check My Work Rem x 1