Perpetual inventory using LIFO The following units of a particular item were available for sale during the calendar year: This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance afte each sale, assuming the last-in, first-out method. Present the data in the form Illustrated in Exhibit 4. Under LIFO, If units are invantorv at two or more different costs, enter the units with the LOWER unit cost first in the inventory Unit Cost column. The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inv each sale, assuming the last-in, first-out method. Present the data in the form illustrated in Exhibit 4. Under inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Schadule of Cost of Goods Sold Determine the cost of goods sold for each sale and the inventory balance after . Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in he units with the LOWER unit cost first in the Inventory Unit Cost column. Srhedula of Cost of Goods Sold