Perpetual inventory using LIFO

The following units of a particular item were available for sale during the calendar year:

Jan. $1$

Inventory

$4,100$ units at $$40$

Apr. $19$

Sale

$2,700$ units

June $30$

Purchase

$4,300$ units at $$44$

Sept. $2$

Sale

$4,800$ units

Nov. $15$

Purchase

$1,800$ units at $$46$ 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.

LIFO Method

$\backslash$table$[[$Date$,\backslash$table$[[$Purchases$],[$Quantity$]],\backslash$table$[[$Purchases$],[$Unit Cost$]],\backslash$table$[[$Purchases$],[$Total Cost$]],\backslash$table$[[$Cost of Goods Sold$],[$Quantity$]],\backslash$table$[[$Cost of Goods Sold$],[$Unit Cost$]],\backslash$table$[[$Cost of Goods Sold$],[$Total Cost$]],\backslash$table$[[$Inventory$],[$Quantity$]],\backslash$table$[[$Inventory$],[$Unit Cost$]],\backslash$table$[[$Inventory$],[$Total Cost$]]],[\backslash$table$[[$Jan$.1],[$Apr$.19]],,,,,,$$$,,$$$,$$