156k views
2 votes
Concord Company sells many products. Gizmo is one of its popular items. Below is an analysis of the inventory purchases and sales of Gizmo for the month of March. Concord Company uses the periodic inventory system.

1 Answer

4 votes

Answer:

the numbers are missing, so I looked for a similar question:

Purchases Sales Units Unit Cost Units Selling Price/Unit

3/1 Beginning inventory 100 $40

3/3 Purchase 60 $50

3/4 Sales 60 $80

3/10 Purchase 200 $55

3/16 Sales 70 $90

3/19 Sales 90 $90

3/25 Sales 60 $90

3/30 Purchase 40 $60

the requirements are:

calculate COGS and ending inventory under FIFO, LIFO and weighted average.

since this company uses the periodic inventory level we must first determine the total cost of goods available for sale:

3/1 Beginning inventory 100 $40

3/3 Purchase 60 $50

3/10 Purchase 200 $55

3/30 Purchase 40 $60

total goods available for sale = 400 units, at a total cost of $20,400

total units sold = 60 + 70 + 90 + 60 = 280 units

ending inventory = 120 units

under FIFO:

ending inventory = (40 x $60) + (80 x $55) = $6,800

COGS = $20,400 - $6,800 = $13,600

under LIFO:

ending inventory = (100 x $40) + (20 x $50) = $5,000

COGS = $20,400 - $5,000 = $15,400

under weighted average:

ending inventory = ($20,400 / 400) x 120 = $6,120

COGS = $20,400 - $6,120 = $14,280

User BlueJapan
by
5.8k points