Record the inventory, purchases and cost of goods sold data in a perpetual inventory using the last in first out method

LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Number of Units Date Transaction Per Unit Total Inventory 60 $600 Apr. 3 8 Purchase 120 11 Sale 80 720 2,000 2,000 30 Sale 50 May 8 Purchase 100 800 10 Sale 60 $36,000 86,400 160,000 100,000 80,000 120,000 60,000 88,000 126,000 168,000 172,800 189,000 19 Sale 2,000 2,000 BB0 30 28 100 Purchase Sale June 5 60 2,100 2,100 16 Sale BO 21 Purchase 180 960 2,100 28 Sale 90 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit , using the last in, first-out method. Under LIFO, funits are in inventory at two different costs, enter the units with the HIGHER unit cost first in the cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column