Question
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. Mar 01: Purchase, 100 units, 50 each. Mar 05: Purchase, 400 units, 55 each. Mar 09: Sales, 420 units, 85 each. Mar 18: Purchase, 120 units, 60 each. Mar 25: Purchase, 200 units, 62 each. Mar 29: Sales, 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.
Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO: Goods Purchased # of Cost per units unit 100 @ $ 50.00 Date # of units sold Cost of Goods Sold Cost per cost of Goods Sold unit March 1 March 5 400 @ $ 55.00 Inventory Balance # of units Cost per unit Inventory Balance 100 @ $ 50.00 = $ 5,000.00 100 @ $ 50.00 = $ 5,000.00 400 @ $ 55.00 = 22,000.00 $ 27,000.00 0 @ $ 50.00 80 @ $ 55.00 = 4,400.00 $ 4,400.00 March 9 = 100 @ 320 @ $ 50.00 $ 55.00 $ 5,000.00 17,600.00 $ 22,600.00 March 18 120 @ $ 60.00 0 @ $ 50.00 80 @ $ 55.00 = $ 60.00 4,400.00 $ 4,400.00 March 25 200 @ $ 62.00 @ $ 50.00 55.00 @ $ $ @ 60.00 62.00 March 29 Totals $ 22,600.00 $ 0.00 (Required 1 Required 2 > Required 1 Required 2 Required 3 Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Goods Purchased # of units Cost per unit 100 @ $ 50.00 Date Cost of Goods Sold Cost per unit Cost of Goods Sold # of units sold # 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 29 Totals $ 0.00 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 400 @ $ 55.00 $ 50.00 $ 55.00 Average March 9 120 @ = March 18 Average March 25 March 29 Totals $ 0.00
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