please complete all 4 tables, dates March 1,5,9,18,25, and 29, thank you!
Warnerwoods Company uses a perpetual inventory system It entered into the following purchases and sales transactions for March Date Activities Units Acquired at Cost Units sold at Retail Mar. 1 Beginning inventory 110 units @ $51.2e per unit Mar. 5 Purchase 230 units $56.2e per unit Mar 9 Sales 270 units 586.2e per unit Mar. 18 Purchase 90 units @ $61.20 per unit Mar. 25 Purchase 160 units $63.20 per unit Mar. 29 Sales 140 units $96.20 per unit Totals 590 units 410 units Problem 5-1A Part 3 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 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 Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO: Goods Purchased Cost of Goods Sold Cost per # of units Cost per Date Cost of Goods Sold units unit unit March 1 Inventory Balance Cost per Inventory # of units unit Balance 110 $ 51.20 - $ 5,632.00 # of sold $56.20 230 @ 110 a 230 @ $51.20 $ 56 20 March 5 $5.832.00 12,926.00 $ 18.558.00 $ $51.20 5 56.20 0.00 0.00 $ 51.20 $ 56 20 March 9 $ March 9 $ 51.20 $ 56.20 0.00 0.00 $ 51.20 $ 56.20 5 $61.20 March 18 90 @ $ 51.20 $ 56.20 $ 61.20 March 25 160 @ $ 6320 $51.20 $ 56.20 $ 61,20 563.20 March 29 @ March 25 1601 @ $ 63.20 @ $ 51.20 S 56 20 $ 61,20 $ 63.20 @ @ March 29 1 rices $ 0,00 Totals Perpadla FIF Perpetual LIFO > Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Goods Purshased # of Cost per units unit Cost of Goods Sold # of units Cost per Cost of Goods Sold sold unit Date Inventory Balance Cost per Inventory # of units unit Balance 110 @ $ 51.20 = $ 5,632.00 March 1 March 5 March 9