Excel Online Activity: $\backslash ($ A B C $\backslash )$

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

Open the spreadsheet and perform the $\backslash ($ A B C $\backslash )$ analysis to answer the questions below.

Open spreadsheet

Questions

$1.$ Calculate the cumulative percent of total dollar usage and choose the appropriate $\backslash ($ A B C $\backslash )$ category for each item. Round your answers to two decimal places.

$2.$ What is the total projected annual dollar usage? Round your answer to the nearest dollar.

$\backslash$$

Classification Number of items Percentage

A

$\backslash \%$

B

$\backslash \%$

C

$\backslash \%$