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

two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column.

Schedule of Cost of Goods Sold

LIFO Method