Question $16(10$ points$)$

A company manufactures $4$ Sizes of Screwdrivers, Ordering costs and carrying costs are unknown, but it is known that they are the same for each size. At present each size is produced $4$ times per year $.$ If the demand for each size is as follows, calculate the order quantities to minimize inventories $(6$ Marks$)$ and maintain the same total number of runs. Calculate the old and new average inventories$(4$ Marks$).$ Is there any change in the number of orders per year calculations in the Workspace provided or Use the worksheet.$)$

$\backslash$table$[[$Item$,\backslash$table$[[$Annual$],[$usage$]],\backslash$table$[[$Present$],[$Orders$]],\backslash$table$[[$Present lot$],[$size$]],\sqrt[\phantom{2}]{A_D},\backslash$table$[[$New Lot$],[$Size$]],\backslash$table$[[$New$],[$orders$],[$per year$]]],[1,$$$10,000,4,,,,],[2,$$$8,100,4,,,,],[3,$$$6,400,4,,,,],[4,$$$3600,4,,,,],[,$Total,,,,,$-],[,\backslash$table$[[$Average$],[$inventory$]],,-,,,]]$