Question

In: Accounting

Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are...

Inventory Costing Methods-Periodic Method
Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory:

May 1 Beginning inventory 164 units @ $30 per unit
12 Purchased 140 units @ $35 per unit
16 Sold 220 units @
24 Purchased 300 units @ $36 per unit

Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods.

Do not round until your final answers. Round your final answers to the nearest dollar.

A. First-in, First-out:
Ending Inventory $
Cost of Goods Sold: $
B. Last-in, first-out:
Ending Inventory $
Cost of Goods Sold: $
C. Weighted-average cost:
Ending Inventory $
Cost of Goods Sold $

Solutions

Expert Solution

Part A

Total units available = may 1 beginning inventory + may 12 purchase + may 24 purchase = 164+140+300 = 604 units

Units sold on may = 220

Ending inventory (in units) = total units available – units sold = 604-220 = 384 units

In FIFO, for units sold units will be taken from beginning inventory, then from first purchase and then from second purchase

Ending inventory = (84*35)+(300*36) = $13740

Cost of goods sold = (164*30)+(56*35) = $6880

Part B

In LIFO, for units sold units will be taken from second purchase, then from first purchase and then from beginning inventory.

Ending inventory = (164*30)+(140*35)+(80*36) = $12700

Cost of goods sold = (220*36) = $7920

Part C

Weighted average cost per unit= cost of units available / total units = ((164*30)+(140*35)+(300*36))/(164+140+300) = 34.13907

Ending inventory = 384*34.13907 = $13109

Cost of goods sold = 220*34.13907 = $7511

Therefore

A

First-in, First-out:

Ending Inventory

$13740

Cost of Goods Sold

$6880

B

Last-in, first-out:

Ending Inventory

$12700

Cost of Goods Sold

$7920

C

Weighted-average cost:

Ending Inventory

$13109

Cost of Goods Sold

$7511


Related Solutions

Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 210 units @ $36 per unit 12 Purchased 160 units @ $41 per unit 16 Sold 240 units @ 24 Purchased 220 units @ $42 per unit Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods....
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 310 units @ $30 per unit 12 Purchased 260 units @ $35 per unit 16 Sold 340 units @ 24 Purchased 160 units @ $36 per unit Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods....
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March 1 Beginning inventory 110 units of Product M @ $1,590 total cost 6 Purchased 210 units of Product M @ $3,600 total cost 10 Purchased 160 units of Product M @ $3,000 total cost 15 Sold 190 units of Product M Calculate the March cost of goods sold and the ending inventory at March 31 using (a) first-in, first-out, (b) last-in, first-out, and (c)...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August 1 Beginning Inventory 150 Units of product A @ $1700 total cost 5 Purchased 170 Units of product A @ $2716 total cost purchased 270 Units of product A @ $5716 total cost Sold 230 Units of product A @ Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the...
Inventory Costing Methods—Periodic Method Archer Company is a retailer that uses the periodic inventory system. August...
Inventory Costing Methods—Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 80 units of Product A @ $1,600 total cost 5 Purchased 100 units of Product A @ $2,116 total cost 8 Purchased 200 units of Product A @ $4,416 total cost 11 Sold 165 units of Product A @ $4,800 total sale Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b)...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 190 units of Product A @ $1,600 total cost 5 Purchased 210 units of Product A @ $2,116 total cost 8 Purchased 310 units of Product A @ $4,416 total cost 11 Sold 260 units of Product A Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT