ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in
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. Legend No Purchases or Sales Purchases Sales 10 17 24 31 4 11 18 25 5 12 19 26 March 6 13 20 27 7 14 21 28 8 15 22 29 Purchase 100 units $50 each 16 23 30 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. Legend No Purchases or Sales Purchases Sales 3 10 17 24 31 4 11 18 25 12 19 26 March Purchase 400 units $55 each 13 20 27 7 14 21 28 1 8 15 22 29 2 9 16 23 30 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. Legend No Purchases or Sales Purchases Sales 3 10 17 24 31 4 11 18 25 5 12 19 26 March 6 13 20 27 7 14 21 28 1 8 15 22 29 2 Sales 420 units $85 each 16 23 30 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. Legend No Purchases or Sales Purchases Sales 3 10 17 24 31 4 11 18 25 Purchase. 120 units $60 each 5 12 19 26 March 6 13 20 27 14 21 28 1 8 15 22 29 2 9 16 23 30 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. Legend No Purchases or Sales Purchases Sales 3 10 17 24 31 4 11 18 25 Purchase 200 units $62 each 5 12 19 March 6 13 20 27 7 14 21 28 1 8 15 22 29 2 16 23 30 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. Legend No Purchases or Sales Purchases Sales 3 10 17 24 31 4 11 18 25 5 12 19 26 March 6 13 20 27 7 14 21 28 1 8 15 22 29 Sales 160 units $95 each 2 9 16 23 30 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 March 1 March 5 March 9. March 18 March 25 March 29 Totals Goods Purchased # of units 100 @ Cost per unit 50.00 S # of units sold Cost of Goods Sold Cost per unit Cost of Goods Sold = Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Date March 1 March 5 March 9 March 18 March 25 March 29 Totals Goods Purchased # of units 100 @ Cost per unit $ 50.00 # of units sold Cost of Goods Sold Cost per unit Cost of Goods Sold < Required 1 # of units 100 @ Inventory Balance Cost per unit Inventory Balance 5,000.00 $ 50.00 = $ Required 3 > 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: Date March 1 March 5 Average March 9 March 18 Average March 25 March 29 Totals Goods Purchased # of units 100 @ Cost per unit $ 50.00 # of units sold Cost of Goods Sold Cost per unit Cost of Goods Sold < Required 2 # of units 100 @ Inventory Balance Cost per unit Inventory Balance $ 50.00 = $ 5,000.00 Required 3 >
Step by Step Solution
3.41 Rating (167 Votes )
There are 3 Steps involved in it
Step: 1
FIFO Goods purchased Cost of goods sold Perpetual Ending Inventory Date No of units Cost per units N...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