Question

Periodic Inventory by Three Methods The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40 2,250 90,000 16 Sale 25 2,250 56,250 21 Purchase 35 1,264 44,240 28 Sale 44 2,250 99,000
Required: 1.

Determine the inventory on June 30 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system.

Answer 1

Answer:

Merchandise inventory = $32,864

Cost of merchandise sold = $310,776

Explanation:

As per the data given in the question,

Merchandise inventory = Balance of purchases on 21 April

= 26 units × $1,264 per unit

= $32,864

Calculating the ending inventory :

Details units

Ending inventory = beginning inventory + Purchase - Sale

Beginning inventory = 25 units

Add : Purchase made on

April 8  = 75 units

May 8 = 60 units

may 28 = 80 units

June 21 = 35 units

Total units for sale = 275 units

Less : Units sold on

April 11 = 40 units

April 30 = 30 units

May 10 = 50 units

May 19 = 20  units

June 5 = 40 units

June 16 = 25 units

June 28 = 44 units

Ending Inventory in units = 26 units

Cost of merchandise sold =Merchandise available for sale - (Merchandise inventory, June 30, 2016)

=$343,640 - $32,864

= $310,776