ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into...

  
 
 
 
 
 
 
 

 
 

Transcribed Image Text:

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 > 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 >

Answer rating: 100% (QA)

FIFO Goods purchased Cost of goods sold Perpetual Ending Inventory Date No of units Cost per units N... View the full answer