Need the answer on Excel please.

John Smith Company's record of transactions for the month of April was as follows: Purchases Sales April April 1 (balance on hand) 4 8 13 21 29 600 @ $6.02 1,500 @ 6.06 800 @ 6.40 1,200 @ 6.50 700 @ 6.60 500 @ 6.79 5,300 3 9 11 23 27 500 @ $10.00 1,400 @ 10.00 600 @ 11.00 1,200 @ 11.00 900 @ 12.00 4,600 Requirements: Assuming that periodic inventory records are kept in units only, compute the inventory at April 30 using (1) LIFO and (2) average-cost. (b) Assuming that perpetual inventory records are kept in dollars, determine the inventory using (1) FIFO and (2) LIFO. Compute cost of goods sold assuming periodic inventory procedures and inventory priced at FIFO. (d) In an inflationary period, which inventory method -- FIFO, LIFO, average-cost -- will show the highest net income? (c)