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. X open seresthert The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory baiance after each sale, assuming the last-in, firstout method. Present the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Round your answers for quantity values to the nearest whole number, for unit cost values to the nearest cent, and for total cost values to the nearest dollar. a particular item were available for sale during the calendar uncin ac 140 units punti been collected in the Microsoft Excel Online file. Open the the required analysis, and input your answers in the question perpetual inventory system. Determine the cost of goods sold inventory balance after each sale, assuming the last-in, firstthe data in the form illustrated in Exhibit 4. Under LIFO, if units oo more different costs, enter the units with the LOWER unit tory Unit Cost column. Round your answers for quantity values number, for unit cost values to the nearest cent, and for total arest dollar