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 Thursday Friday Saturday Sunday Monday Legend No Purchases or Sal.. Purchases Sales 2 3 3 5 6 7 8 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 March 1: Purchase 100 units, $50 each March 5: Purchase 400 units, $55 each March 9: Sales 420 units, $85 each March 18: Purchase 120 units, $60 each March 25: Purchase 200 units, $62 each March 29: Sales 160 units, $95 each Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using FIFO. Periodic FIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Date # of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units In ending Inventory Cost per unit Ending Inventory $ 0 100 $ $ 5,000 March 1 March 5 March 18 March 25 Total 0 100 $ 400 $ 120 $ $ 820 50.00 $ 55.00 60.00 62.00 $ $ 5,000 22,000 7,200 12,400 46,600 400 80 50.00 55.00 60.00 62.00 200 0 $ 0 120 $ 22,000 4,800 7,440 39,240 0 700 $ 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. Complete this question by entering your answers in the tabs below. Cost of Goods Sold Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using LIFO. Periodic LIFO Cost of Goods Available for Sale Cost of Date # of units Cost per Goods unit Available for Sale March 1 March 5 March 18 March 25 Total #of units sold Cost per Cost of Goods Sold Ending Inventory #of units in ending Ending unit Inventory inventory Cost per unit 0 0 Required 1 Required 2 Required Compute the cost assigned to ending inventory using Weighted Average. (Round average cost per unit to 2 decimal places.) Average Cost Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Average Cost of Goods Average # of units Average Date # of units Cost per # of units Available for Cost per Cost of Ending Cost per in ending unit sold Sale Unit Goods Sold inventory unit Inventory March 1 March 5 March 18 March 25 Total $ 0 $ 0