I need full answer along with formulas.

1. 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 (Show all calculations in the Workspace provided or Use the worksheet.) Item Annual Present Present lot VAD New Lot New usage Orders size Size orders per year 1 $10,000 4 2 $6,400 4 3 $3,600 4 4 $1600 4 Total Average inventory