Consider the following Warehouse Inventory movement $($Supplier $-$ Warehouse $-$ Production$)$ of Chemical X with highly volatile price:NOVEMBER $01$: Inventories on hand are $80$ units at Rack $1$ for $$3/$unit and $100$ units at Rack $2$ for $$4\mathrm{.}50/$unitNOVEMBER $04$: Purchased $100$ units at $$2.$NOVEMBER $05$: $120$ units issued to production.NOVEMBER $07$: $40$ units of inventories purchased on $4$ NOVEMBER at $$2$ are returned to the supplier.NOVEMBER $10$: $80$ units issued to production.NOVEMBER $15$: $40$ units issued to production.NOVEMBER $20$: $20$ units purchased at $$3\mathrm{.}5.$NOVEMBER $25$: $10$ units issued to factory.NOVEMBER $29$: $50$ units purchased at $$2.$NOVEMBER $30$: $2$ units from November $25$ issuance were returned to warehouse due to production line shut down. $2$ units were assessed to be in good condition.

$1.$ Create a stock card using the given inventory flow

$2.$ What is the ending Inventory $3.$ At what period range did the warehouse experience out of stock?

$4.$Calculate the total ending inventory cost using LIFO, FIFO and weighted Moving averagemethod of valuing Inventory