I need help to determine the Periodic FIFO, LIFO and average cost. I am stuck on data input on 8/18, COGS Periodic FIFO

Corporation provides the following information related to its merchandise inventory during the month of August 2 1 Inventory on hand-2, 900 units; cost $5. 30 each. 8 Purchased 8,000 units for $5.50 each. 14 Sold 6,000 units for $12.00 each. 18 Purchased 6,000 units for $5.60 each. 25 Sold 7,000 units for $11.00 each. 28 Purchased 4,000 units for $5.80 each. 31 Inventory on hand-7,000 units. quired: ing calculations based on a periodic inventory system, determine the inventory balance Altira would report in its August 31 lance sheet and the cost of goods sold it would report in its August 2021 income statement using each of the following cos ethods