Question

# Periodic Inventory by Three Methods; Cost of Merchandise Sold The units of an item available for...

Periodic Inventory by Three Methods; Cost of Merchandise Sold

The units of an item available for sale during the year were as follows:

 Jan. 1 Inventory 40 units @ \$106 Mar. 10 Purchase 70 units @ \$114 Aug. 30 Purchase 30 units @ \$118 Dec. 12 Purchase 60 units @ \$122

There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used.

Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar.

 Cost of Merchandise Inventory and Cost of Merchandise Sold Inventory Method Merchandise Inventory Merchandise Sold First-in, first-out (FIFO) \$ \$ Last-in, first-out (LIFO) Weighted average cost

Units sold = (40 + 70 + 30 + 60) - 80 = 120

Purchases (\$) = (70 x 114) + (30 x 118) + (60 x 122) = \$18,840

1. FIFO Periodic

Closing stock = (60 units of Dec 12) + (20 units of Aug 30)

= (60 x 122) + (20 x 118)

= \$9,680

Cost of goods sold = Opening stock + purchase - Closing stock

= 4240 + 18840 - 9680

= \$13,400

2. LIFO Periodic

Closing stock = (40 units of Jan 1) + (40 units of Mar 10)

= (40 x 106) + (40 x 114)

= \$8,800

Cost of goods sold = Opening stock + purchase - Closing stock

= 4240 + 18840 - 8800

= \$14,280

3. Weighted average

Per unit cost = (Opening stock + Purchases)/ No. of units

= (4240 + 18840)/ 200

= \$115.40

Closing stock = 80 untis x 115.40

= \$9,232

Cost of goods sold = Opening stock + purchase - Closing stock

= 4240 + 18840 - 9232

= \$13,848

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Need Online Homework Help?

Most questions answered within 1 hours.

##### Active Questions
• Distinguish between the typical roles of geologist and engineers in dealing with groundwater problems. How do...
• 5) A rock is thrown directly southeast (45 degrees to S and E), at an initial...
• If 133.2 kJ of heat are added to 5.80 × 102 g of water at 22.0°C,...
• true/false An unweighted path length measures the number of edges in a graph. Breadth first search...
• Give an example of the effect of interest rate changes on a fixed coupon bond, what...
• Thirty-two small communities in Connecticut (population near 10,000 each) gave an average of x = 138.5...