Question

LIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date		Transaction	Number of Units		Per Unit		Total
Apr. 3		Inventory	84		$375		$31,500
8		Purchase	168		450		75,600
11		Sale	113		1,250		141,250
30		Sale	71		1,250		88,750
May 8		Purchase	140		500		70,000
10		Sale	84		1,250		105,000
19		Sale	42		1,250		52,500
28		Purchase	140		550		77,000
June 5		Sale	84		1,315		110,460
16		Sale	112		1,315		147,280
21		Purchase	252		600		151,200
28		Sale	126		1,315		165,690

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Dunne Co. Schedule of Cost of Merchandise Sold LIFO Method For the three months ended June 30
	Purchases			Cost of Merchandise Sold			Inventory
Date	Quantity	Unit Cost	Total Cost	Quantity	Unit Cost	Total Cost	Quantity	Unit Cost	Total Cost
Apr. 3								$	$
Apr. 8		$	$
Apr. 11					$	$
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30	Balances					$			$

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

Total sales	$
Total cost of merchandise sold	$
Gross profit from sales	$

3. Determine the ending inventory cost on June 30.
$

Answer 1

Solution 1:

Computation of ending inventory COGS under LIFO
Date	Beginning Inventory			Purchase			Cost of Goods Sold			Ending Inventory
	Qty	Rate	Amount	Qty	Rate	Amount	Qty	Rate	Amount	Qty	Rate	Amount
3-Apr	84	$375.00	$31,500.00	0	$0.00	$0.00	0	$0.00	$0.00	84	$375.00	$31,500.00
8-Apr	84	$375.00	$31,500.00	168	$450.00	$75,600.00	0	$0.00	$0.00	84	$375.00	$31,500.00
										168	$450.00	$75,600.00
11-Apr	84	$375.00	$31,500.00	0	$0.00	$0.00	113	$450.00	$50,850.00	84	$375.00	$31,500.00
	168	$450.00	$75,600.00							55	$450.00	$24,750.00
30-Apr	84	$375.00	$31,500.00	0	$0.00	$0.00	55	$450.00	$24,750.00	68	$375.00	$25,500.00
	55	$450.00	$24,750.00				16	$375.00	$6,000.00
8-May	68	$375.00	$25,500.00	140	$500.00	$70,000.00	0	$0.00	$0.00	68	$375.00	$25,500.00
										140	$500.00	$70,000.00
10-May	68	$375.00	$25,500.00	0	$0.00	$0.00	84	$500.00	$42,000.00	68	$375.00	$25,500.00
	140	$500.00	$70,000.00							56	$500.00	$28,000.00
19-May	68	$375.00	$25,500.00	0	$0.00	$0.00	42	$500.00	$21,000.00	68	$375.00	$25,500.00
	56	$500.00	$28,000.00							14	$500.00	$7,000.00
28-May	68	$375.00	$25,500.00	140	$550.00	$77,000.00	0	$0.00	$0.00	68	$375.00	$25,500.00
	14	$500.00	$7,000.00							14	$500.00	$7,000.00
										140	$550.00	$77,000.00
5-Jun	68	$375.00	$25,500.00	0	$0.00	$0.00	84	$550.00	$46,200.00	68	$375.00	$25,500.00
	14	$500.00	$7,000.00							14	$500.00	$7,000.00
	140	$550.00	$77,000.00							56	$550.00	$30,800.00
16-Jun	68	$375.00	$25,500.00	0	$0.00	$0.00	56	$550.00	$30,800.00	26	$375.00	$9,750.00
	14	$500.00	$7,000.00				14	$500.00	$7,000.00
	56	$550.00	$30,800.00				42	$375.00	$15,750.00
21-Jun	26	$375.00	$9,750.00	252	$600.00	$151,200.00	0	$0.00	$0.00	26	$375.00	$9,750.00
										252	$600.00	$151,200.00
28-Jun	26	$375.00	$9,750.00	0	$0.00	$0.00	126	$600.00	$75,600.00	26	$375.00	$9,750.00
	252	$600.00	$151,200.00							126	$600.00	$75,600.00
Total							632		$319,950.00	152		$85,350.00

Solution 2:

Computation of Sales
11-Apr	113	$1,250.00	$141,250.00
30-Apr	71	$1,250.00	$88,750.00
10-May	84	$1,250.00	$105,000.00
19-May	42	$1,250.00	$52,500.00
5-Jun	84	$1,315.00	$110,460.00
16-Jun	112	$1,315.00	$147,280.00
28-Jun	126	$1,315.00	$165,690.00
Total	632		$810,930.00

Total cost of merchandise sold = $319,950

Gross profit from sales = $810,930 - $319,950 = $490,980

Solution 3:

Ending inventory cost on june 30 = $85,350