Rojas Company's record of inventory transactions for the month of April are as follows. April 1 4 Purchases - Units Balance on hand 100 Purchase 400 Purchase 300 Purchase 200 Purchase 600 Purchase 200 @ a @ @ Cost $ $ $ $ $ $ April 5 12 27 28 5.00 5.10 5.30 5.35 5.60 5.80 Sales - Total Units 300 200 800 150 11 18 26 30 @ @ @ @ $ 7.00 $ 7.00 $ 7.00 $ 7.00 @ I Using the Periodic method Compute the following: Ending inventory using the LIFO method COGS using the weighted average method Goods Available for Sale $ $ 1,775 enter directly 7,830 enter directly Jenter directly Using the Perpetual method compute the following: Gross Profit using the FIFO method $ 2,514 enter directly PLEASE SHOW YOUR WORK - BE CAREFUL AND UTILIZE EXCEL FOR EFFICIENCY