Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Legend No Purchases or Sales Purchases Sales V 0 Purchase 100 units $50 each 14 6 8 1101 111 12 113 14 15 16 17 18 19, 201 21 22. 23 24. 25 26 127 28 129 130 31 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 Legend No Purchases or Sales Purchases Sales 1 2 3 14 7 100) Purchase 400 units $55 each 110 11. 12 13 14 15 16 17 18 19, 201 121 22. 23 124. 25. 26 27 28 29 130 131 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 Legend No Purchases or Sales Purchases Sales 2 1 3 14 15 6 7 100 Sales 420 units $85 each 101 111 12 13 14 15 16 17 18 19 200 121 22 23 24 25 26 27 28 129 30 31 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 Legend No Purchases or Sales Purchases Sales 1 2 3 5 6 18 101 11 112. 13) 14 115 16 117 18 19 120 21 22 123 Purchase 120 units $60 each 24 25 26 27 28, 129 1301 131 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 Legend No Purchases or Sales Purchases Sales 1 2 3 14 6 7 8. 19 5 10 11 12. 13 14 115 16 17 18 19. 201 21 122 23 24 24 Purchase 27 28. 129 30 | 200 units $62 each 31 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 Legend No Purchases or Sales Purchases Sales 1 2 3 15 6 8 19 110 11 12. 113) 14 15 16 17 18 19, 120 121 122 23 24 25 26 27 28, 29 30 Sales 160 uni $95 each 131 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: Date Goods Purchased # of Cost per units unit 1001 @ S 50.00 Cost of Goods Sold Cost per Cost of Goods Sold unit # of units sold # of units Inventory Balance Cost per Inventory Balance unit $ 50.00 = $ 5,000.00 March 1 100 @ March 5 March 9 March 18 March 25 March 29 Totals Required 1 Required 2 Required 3 Required 3 Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Cost of Goods Sold Inventory Balance Date Goods Purchased # of units Cost per unit 100 @ $ 50.00 # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance March 1 100 @ $ 50.00 = $ 5,000.00 March 5 March 9 March 18 March 25 March 29 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.) Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance March 1 100 @ $ 50.00 100 @ $ 50.00 $ 5,000.00 March 5 Average March 9 March 18 Average March 25 March 29 Totals
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started