Tableau DA 5-2: Exercise, Perpetual: Inventory costing methods LO P1, A1

Tableau DA 5-2: Exercise, Perpetual: Inventory costing methods LO P1, A1 ATV Company 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 Wednesday Tuesday Thursday Friday Saturday Sunday Monday Legend No Purchases or Sales Purchases Sales + 1 2 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Book Print 17 18 19 20 21 22 23 rences 24 25 26 27 28 29 30 31 Check 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. Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO Goods Purchased of units unit 100 $ 50.00 Cost per Date Cost of Goods Sold Cost per unit Cost of Goods Sold of units sold #of units Inventory Batang Cost per Unit Inventory Balance 5 50.00 $ 5,000.00 March 1 100 @ March 5 March March 10 9 March 7.14 points March 18 Book March 25 March 20 Totals Required 2 > Required 1 Required 2 Required 3 Compute the cost assigned to ending Inventory using LIFO. Perpetual LIFO Goods Purchased Cost of Goods Sold Date of #of units Cost per unit units sold Cost per unit Cost of Goods Sold March 1 100 5 50.00 March 5 # of units Inventory Balance Cost per unit Inventory Balance $ 50.00 - 5,000.00 100 March March to March 25 March 25 March 20 Totals Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using Weighted Average. (Round your average cost per unit to 2 decimal places) Cost of Goods Sold Weighted Average Perpetual: Goods Purchased # of Date Cost per unit units March 1 100 @ $ 50.00 March 5 #of units sold Cost per unit Cost of Goods Sold of units Inventory Balance Cost per unit Inventory Balance 50.00 5 5,000.00 100 Average Marcha March 18 Average March 25 March 20 Total