$(2)$ Classify each material into ABC category and determine the average inventory in dollars. $(10pts)$

Give the number of orders you have assigned for these categories in the Number of Orders column $($Use $8$ for A$,4$ for B$,$ and $2$ for C$).$

Find and define the threshold you used and how you came up with them.

$\backslash$table$[[\backslash$table$[[$Material$],[$No$.]],\backslash$table$[[$Price$/],[$unit$]],\backslash$table$[[$Demand$],[$units$]],\backslash$table$[[$Consumption$],[$$$/$year$]],\backslash$table$[[$ABC$],[$Classification$],[($A$/$B$/$C$)]],\backslash$table$[[$Number of$],[$Orders$]],\backslash$table$[[$Average$],[$Inventory$],[$$$]]],[1,2\mathrm{.}00,15,000,,,,],[2,6\mathrm{.}45,1,400,,,,],[3,9\mathrm{.}35,12,200,,,,],[4,12\mathrm{.}70,5,500,,,,],[5,2\mathrm{.}25,4,500,,,,],[6,10\mathrm{.}35,12,000,,,,],[7,38\mathrm{.}50,205,,,,],[8,6\mathrm{.}00,1,700,,,,],[9,2\mathrm{.}40,40,000,,,,],[10,4\mathrm{.}00,3,000,,,,]]$