Question
ATV Co. began operations on March 1 and uses a periodic inventory system. It entered into purchases and sales for March as shown in the
ATV Co. began operations on March 1 and uses a periodic inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard.
MARCH 1 :
PURCHASE 100 UNITS
$50 EACH
MARCH 5:
PURCHASE 400 UNITS
$55 EACH
MARCH 9:
SALE 420 UNITS
$85 EACH
MARCH 18
PURCHASE 120 UNITS
$60 EACH
MARCH 25
PURCHASE 200 UNITS
62 EACH
MARCH 29
SALE 160 UNITS
$95 EACH
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.
Answer is not complete. 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. Periodic FIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Cost per Cost per Date # of units Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Ending Inventory unit unit March 1 100 $ 50.00 5,000 0 x $ 0 100 X $ 50.00 $ 5,000 March 5 400 $ 55.00 22,000 0 $ 0.00 0 March 18 120 $ 60.00 0 0 7,200 12,400 March 25 200 $ 62.00 0 0 $ Total 820 $ 46,600 0 100 5,000 X Answer is not complete. 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 LIFO. Periodic LIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Cost per Cost per unit Cost per Date # of units Cost of Goods Available for Sale # of units sold Cost of Goods Sold # of units in ending inventory Ending Inventory unit unit March 1 100 $ 50.00 $ 0 100 $ 50.00 $ 5,000 March 5 400 $ 55.00 5,000 22,000 7,200 420 X $ 55.00 23,100 80 x $ 55.00 4,400 March 18 120 $ 60.00 March 25 200 $ 62.00 12,400 0 x 240 X $ 62.00 14,880 Total 820 $ 46,600 420 $ 23,100 420 $ 24,280 Answer is not complete. 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 Weighted Average. (Round average cost per unit to 2 decimal places.) Average Cost Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Average Date # of units Cost per Cost of Goods Available for Sale # of units sold Average Cost per Unit Cost of Goods Sold # of units in ending inventory Average Cost per unit Ending Inventory unit March 1 100 March 5 400 March 18 120 $ 5,000.00 $ 22,000.00 $ 7,200.00 $ 12,400.00 $ 46,600.00 March 25 200 Total 820 580 $ 0 240 $ 0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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