compute ending inventory using LIFO,FIFO and AVG using both periodic and perpetual inventory methods.please show your computations.

Excel (Compute F O, an ncerning part X for the month of April was as follows. Purchases April 1 (balance on hand) 4 11 18 26 30 100 @ $5.00 April 5 400 @ 300 @ 200 @ 600 @ 200 @ 5.10 5.30 5.35 5.60 5.80 12 27 28 Sales 300 200 800 150