Date

Transaction

# of units

Per unit

Total

Jan 1	Inventory	7,500	75.00	526,500
10	purchase	22,500	85.00	1,912,500
28	sale	11,250	150.00	1,687,500
30	sale	3,750	150.00	562,500
Feb 5	sale	1,500	150.00	225,000
10	purchase	54,000	87.50	4,725,000
16	sale	27,000	160.00	4,320,000
28	sale	25,500	160.00	4,080,000
mar 5	purchase	45,000	89.50	4,027,500
14	sale	30,000	160.00	4,800,000
25	purchase	7,500	90.00	675,000
30	sale	26,250	160.00	4,200,000

Instructions

1. Determine the inventory on March 31 and the cost of goods sold for the three month period, using the FIFO and periodic inventory system

2. Determine the inventory on March 31 and the cost of goods sold for 3 month period, using LIFO and periodic system.

3.Determine the inventory on March 31, and the cost of good sold for the 3 month period, using weighted average cost method and the periodic inventory system. (round the weighted average unit cost to nearest cent)

4. compare the gross profit and march 31 inventories, using the following column head

fifo

lifo

weighted avg

sales
cost of goods sold
gross profit
inventory, march 31