Question $1-$ A company wants to implement ABC analysis for its SKUs. The following table shows the annual dollar usage for a sample of eight SKUs. Implement an ABC analysis to rank the SKUs, and assign them to their appropriate category. $($You can use Excel to solve this problem; submit your Excel file. Present the details of your calculations.$)$

$\backslash$table$[[$SKU Code,Dollar Value $($$$),$Annual Demand$],[1,0\mathrm{.}01,1200],[2,0\mathrm{.}03,120000],[3,0\mathrm{.}45,100],[4,1\mathrm{.}00,44000],[5,4\mathrm{.}50,900],[6,0\mathrm{.}90,350],[7,0\mathrm{.}30,70000],[8,1\mathrm{.}50,200]]$