The beginning inventory of merchandise at Dunne Co and data

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

Solution

CLOSING INVENTORY

				CLOSING UNITS BIFURCATION
DATE		NO OF UNITS	CLOSING UNITS	DATE	UNITS
Apr-03	INVENTORY	25	25	Apr-03	25
8	PURCHASE	75	100	Apr-03	25
				Apr-08	75
11	SALE	40	60	Apr-03	25
				Apr-08	35
30	SALE	30	30	Apr-03	25
				Apr-08	5
May-08	PURCHASE	60	90	Apr-03	25
				Apr-08	5
				May-08	60
10	SALE	50	40	Apr-03	25
				Apr-08	5
				May-08	10
19	SALE	20	20	Apr-03	20
28	PURCHASE	80	100	Apr-03	20
				May-28	80
JUNE 5	SALE	40	60	Apr-03	20
				May-28	40
16	SALE	25	35	Apr-03	20
				May-28	15
21	PURCHASE	35	70	Apr-03	20
				May-28	15
				Jun-21	35
28	SALE	44	26	Apr-03	20
				May-28	6