First photo is data

Second 2 are to show the format of the tables I need to have filled in for the Perpetual FIFO, Perpetual LIFO, Weighted Average & Specific ID

Required information The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units Sold at Retail Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Units Acquired at Cost 110 units $51.2e per unit 238 units $56.20 per unit 90 units $61.20 per unit 160 units $63.20 per unit 270 units @ $86.2e per unit 140 units @ $96.20 per unit 410 units 590 units 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO. (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 70 units from beginning inventory and 200 units from the March 5 purchase; the March 29 sale consisted of 50 units from the March 18 purchase and 90 units from the March 25 purchase. Perpetual FIFO Perpetual LIFO Weighted Average Specific Id of 4 Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO: Goods Purchased Cost of Goods Sold of # of units Cost per Date units unit sold unit Cost of Goods Sold March 1 Cost per Cost per March 5 230 @ $ 56.20 Inventory Balance # of units Inventory unit Balance 110 @ $51.20 = $ 5,632.00 1101 a $ 51.20 = $ 5,632.00 230 @ $ 56.20 = 12,926.00 $ 18,558.00 @ $51.20 $ 56.20 March 9 $ 110 @ 160 @ $51.20 $56.20 5,632.00 8,992.00 14,624.00 $ March 18 90 @ $ 6120 $51.20 Required information 1.00 March 18 90 $61.20 70 @ 90 @ $ 51.20 $ 56.20 = $ 61.20 = 3,934.00 5,508.00 $ 9.442.00 March 25 160 $63.20 70 90 $51 20 $ 56.20 - $ 6120 - $83.20 - 3,934 00 5,500.00 10.112.00 $ 19,554.00 160 March 29 $ @ 70 @ 70 @ @ $ 51.20 $ 56.20 $ 61.20 563.20 0.00 3,934.00 4,284,00 0.00 8,218.00 22,842.00 $51.20 $ 56.20 $ 61.20 = $63.20 - 20 @ 160 @ 1.224.00 10.112.00 $ 11,338.00 $ 11,336.00 $ Totals $