Tableau DA 5-2: Exercise, Perpetual: Inventory costing methods LO P1 ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard March Sunday Monday Tuesday Wednesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 16 23 24 25 26 28 29 30 31 tableau 1. Compute the cost assigned to ending inventory using FIFO. 2. Compute the cost assigned to ending inventory using LIFO. 3. Compute the cost assigned to ending inventory using Weighted Average. LHER ompute the cost assigned to ending inventory using LIFO. erpetual LIFO: Cost of Goods Sold Cost per unit Cost of Goods Sold Date w of units Sold Goods Purchased of units Cost per unit 100 @ $ 50.00 400 $ 55.00 March 1 # of units 100 100 400 March 5 Inventory Balance Cost per unit Inventory Balance $ 50.00 = $ 5,000.00 $ 50.00 = $ 5,000.00 $ 55.00 = 22,000.00 $ 27,000.00 $ 50.00 = $ 20,000.00 $ 55.00 = $ 1,100.00 $ 21,100.00 Larch 9 = $ @ 400 20 @ @ $ $ 50.00 55.00 20,000.00 1.100.00 21,100.00 400 201 $ @ $ 60.00 50.00 55.00 60.00 2001 50.00 55.00 $ 30. 60.00 62.00 $ Larch 29 $ 21,100.00 Compute the cost assigned to ending Inventory using Weighted Average. (Round your average cost per unit to 2 decimal places.) Inventory Balance Veighted Average Perpetual: Goods Purchased of Date Cost per u units March 1 100 @ $ 50.00 Cost of Goods Sold Cost per unit Cost of Goods Sold of units sold #of units 100 @ Cost per unit $ 50.00 Inventory Balance $ 5,000.00 Larch 5 werage Larch 9 Barch 18 werage tarch 25 Larch 29