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 Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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 Date Goods Purchased # of units unit 100 $ 50 00 Cost per # of units sold Cost of Goods Sold Cost per Cost of Goods Sold unit # of units Inventory Balance Cost per unit Inventory Balance $ 50.00 - $ 5,000.00 March 1 100 March 5 March 9 March 18 March 25 March 20 Totals $ 0.00 $ 0.00 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. 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 Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales Purchase 100 units $50 each 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Tableau UA 5-4: exercise, perpetuar: inventory cosung menous LU PI, AI 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 Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 2 3 4 4 1 6 7 8 9 Purchase 400 units $55 each 10 11 12 13 14 15 16 17 18 19 20 21 22 23 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 Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 2 3 4 5 6 LO 7 CO Sales 420 units $85 each 10 11 12 13 14 15 16 17 18 19 20 21 22 23 shown in the Tableau Dashboard esa perpetuar inventory system. It entered into purchases and sales for march as March Wednesday Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 20 21 22 23 Purchase 120 units $60 each BA 0 3 9 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 24 25 27 28 Purchase 200 units $62 each 29 31 1 2 5 6 7 8 9 12 13 14 15 16 19 20 21 22 23 26 D 27 28 29 Sales 160 units $95 each BB Noyt Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Date Goods Purchased #of units Cost per unit 100 @ $ 50.00 of units sold Cost of Goods Sold Cost per unit Cost of Goods Sold March 1 of units Inventory Balance Cost per unit Inventory Balance 50.00 $ 5,000.00 March 5 100 es March March 18 March 25 March 20 Totals $ 0.00
