Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021:

Aug.1	Inventory on hand2,700 units; cost $6.80 each.
8	Purchased 13,500 units for $6.20 each.
14	Sold 10,800 units for $12.70 each.
18	Purchased 8,100 units for $5.60 each.
25	Sold 9,800 units for $11.70 each.
28	Purchased 4,700 units for $5.80 each.
31	Inventory on hand8,400 units.

Using calculations based on a perpetual inventory system, determine the inventory balance Altira would report in its August 31, 2021, balance sheet, and the cost of goods sold it would report in its August 2021 income statement using last-in, first-out (LIFO).

Please do the spreadsheet all the way through showing each cell's answer. IF it is zero put zero