********please do this in some type of excel boxes so i know what number goes where****. thank you

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 Unita Sold at Retail Date Activities Mar 1 Beginning inventory Mar. Purchase Mar. Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Unite Mequired at coat 170 units $52.40 per unit 260 units $57.40 per unit 120 unitse $62.40 per unit 220 units $64.40 per unit 130 units $47.40 per unit 200 unita. 197.40 per unit 530 units 770 units 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO (c/ weighted average, and a specific identification. For specific identification, the March 9 sale consisted of 100 units from beginning inventory and 230 units from the March 5 purchase the March 29 sale consisted of 80 units from the March 18 purchase and 120 units from the March 25 purchase. Complete this question by entering your answers in the tabs below. Perpetual FIFO Perpetual UFO Weighted Average Specific Id Compute the cost assigned to ending Inventory using FIFO. Perpetual FIFO Goods Purchased of per unit Inventory Ban Cont Inventory of units per unit Balance 170 $ 52.40-$8.90800 Cost of Goods Sold Cost per unit Cost of Goods Sold of units sold Cost Datu March 1 March 5 March 9 March 18 Required information Complete this question by entering your answers in the tabs below. Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO Cast of Goods Sold Goods Purchased of Cost units per unit Date # of units sold Cost per unit Cost of Goods Sold Inventory Balance Cost of units Inventory Balance 170 $ 52.40- $ 8.903.00 per unit March 1 March 5 March 9 March 18 March 25 March 29 $ 0.00 Totals Palo Perpetual LIFO > 1 OSOBOW Perpetual FIFO perpetual LIFO Weighted Average Specific ta Compute the cost assigned to ending Inventory using LIFO. Perpetual LIFO: Goods Purchased #of Cost units per unit Cost of Goods Sold Cost Cost of Goods Sold Date #of units sold per unit Inventory Balance of units Cost Inventory per unit Balance $ 52.40 5 8,908,00 March 1 170 @ March 5 March 9 March 18 March 25 March 29 $ 0.00 Totals Weighted Average 3