The data for 20 inventoried items of a small company has been collected in the Microsoft Excel Online file below. Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A 80% B C 95% 100% Open the spreadsheet and perform the ABC analysis to answer the questions below. X Open spreadsheet ABC Classification Cutoffs A 00% B C 95% 100% Projected Usage Projected Row Dollar Usage Dollar Cumulative Percent Number Annual Unit Cost Annual 5 22000 $25 00 2 9 8000 $52.00 5 12 1900 $95.00 + 4. 11 9000 $17.50 5 2 6050 $20.00 6 16 425 $179 50 3 2000 $26.00 10. A 12000 $300 $3,00 19 10 9100 $3.00 20 10 10 17 21 11 1010 300 30 22 12 13 5000 21 13 14 24 14 A 25 15 5 76 16 to 500 17 15 18 19 20 7700 1100 400 54 70 $4.70 $7.00 $177 00 $25 50 30.50 582 50 $750 20 19 1000 5040 Cumulative Cumulative Percent ABC Usage of Total of items Classification (see cell A) Projected Cumulative Cumulative Cumulative Dollar Usage Dalar Annual Usage Percent of Total Percent ABC Classification (see cell A3) NIA A NA ANA NA NA ANA NA NA A NA NA NIA NA www A NA N INA NA NIA NIA NIA NA NA ANA NA NA INA N MA INA NA NIA NA A ANIA NA NA ANIA ANA NA ANA NIA ANIA www INIA ANIA NA A A A NA A NA ANA A A ANIA AM Total ANIA Nb 6 202 22 NA NA 1. Calculate the cumulative percent of total dollar usage and choose the appropriate ABC category for each item. Round your answers to two decimal places. Item Cumulative Percent- of Total ABC Number Classification 5 % 9 % 12 %% 11 % 2 % 16 % 3 % 1 % 18 96 17 7 % 13 14 %% 4 % 6 10 15 96 8 20 % 19 2. What is the total projected annual dollar usage? Round your answer to the nearest dollar. $ 3. Complete the following table by entering the number of items in each category and their percentage of total number of items under ABC classification, Round your answers to the nearest whole number. Classification A B C Number of items Percentage