Solve using LIFO method

A B Unit Cost Total Cost Unit Cost Total Cost Unit Cost $1.200 Total Cost 30,000 Quantity 25 Quantity Quantity $ Date Apr. 3 8 11 30 May & 10 19 28 --- June 5 16 21 28 30 Balances 3 4 5 6 7 8 39 50 51 52 53 54 55 56 57 Total sales Total cost of goods sold Gross profit Ending Inventory cost Date Transaction Per Unit Total Number of Units Jan. 1 10 28 30 Feb. 5 10 16 28 Mar. 5 14 25 30 Inventory Purchase Sale Sale Sale Purchase Sale Sale Purchase Sale Purchase Sale 7,500 22,500 11,250 3,750 1,500 54,000 27,000 25,500 45,000 30,000 7,500 26,250 $ 75.00 $ 562,500 85.00 1,912,500 150.00 1,687,500 150.00 562,500 150.00 225,000 87.50 4,725,000 160.00 4,320,000 160.00 4,080,000 89.50 4,027,500 160.00 4,800,000 90.00 675,000 160.00 4,200,000 PR 6-2A LIFO perpetual inventory Obj. 2, 3 The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period are shown in Problem 6-1A. TO ME AUW Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the Inst-in, first-out method. 2. Determine the total sales, the total cost of goods sold, and the gross profit from ales for the period EXCEL TEMPLATE Answer 3. Determine the ending inventory cost as of March 31