Question

Perpetual Inventory Using FIFO

Beginning inventory, purchases, and sales data for portable DVD players are as follows:

June 1		Inventory	74 units @ $78
6		Sale	55 units
14		Purchase	30 units @ $81
19		Sale	27 units
25		Sale	14 units
30		Purchase	25 units @ $86

The business maintains a perpetual inventory system, costing by the first-in, first-out method.

Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4.

a. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Date	Quantity Purchased	Purchases Unit Cost	Purchases total cost	Quantity sold	Cost of merchandise sold unit cost	Cost of merchandise sold total cost	Inventory quantity	Inventory unit cost	Inventory total cost
June 1
June 6
June 14
June 19
June 25
June 30

Answer 1

Date	Quantity Purchased	Purchases Unit Cost	Purchases total cost	Quantity sold	Cost of merchandise sold unit cost	Cost of merchandise sold total cost	Inventory quantity	Inventory unit cost	Inventory total cost
June 1							74	78	5772
June 6				55	78	4290	19	78	1482
June 14	30	81	2430				19	78	1482
							30	81	2430
June 19				19	78	1482	30	81	2430
				8	81	648	22	81	1782
June 25				14	81	1134	8	81	648
June 30	25	86	2150				8	81	648
							25	86	2150
						7554			2798