$1.$ Perform an ABC analysis using the data below. Calculate the dollar volume, $\%$ dollar value, and classification using Excel. Submit the Excel file.

Item Annual Demand Cost$/$unit Dollar Volume $\%$ Dollar Value Classification

A$1111,000$ $$2\mathrm{.}50$

B$215500$ $$60$

C$325400$ $$8$

D$1132,000$ $$15\mathrm{.}50$

E$218100$ $$1,200$

F$345100$ $$750$

G$1162,000$ $$3\mathrm{.}50$

H$21450$ $$125$

I$1181,500$ $$3\mathrm{.}00$

J$261300$ $$10\mathrm{.}50$

K$1173,0000\mathrm{.}99$

L$121200$ $$5\mathrm{.}99$

a$.$ How are items determined to be A$,$ B$,$ or C$?$