Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting The Basis For Business Decisions

Authors: Robert F. Meigs, Walter B Meigs

5th Edition

007041551X, 9780070415515

More Books

Students also viewed these Accounting questions

Question

Determine miller indices of plane X z 2/3 90% a/3

Answered: 1 week ago