Question

Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.

Date			Transactions	Units				Unit Cost				Total Cost
October	1		Beginning inventory		6			$	850				$	5,100
October	4		Sale		4
October	10		Purchase		5				860					4,300
October	13		Sale		3
October	20		Purchase		4				870					3,480
October	28		Sale		7
October	30		Purchase		8				880					7,040
													$	19,920

1. Calculate ending inventory and cost of goods sold at October 31, using the specific identification method. The October 4 sale consists of purses from beginning inventory, the October 13 sale consists of one purse from beginning inventory and two purses from the October 10 purchase, and the October 28 sale consists of three purses from the October 10 purchase and four purses from the October 20 purchase.

Answer 1

Ending Inventory

Transactions	Units	Corresponding Sales	Balance units	Value of Ending Inventory
Beginning Inventory	6	4+1 = 5	1	$850 [850*1]
Purchases on 10th October	5	2+3 = 5	0	$0
Purchases on 20th October	4	4	0	$0
Purchases on 30th October	8	0	8	$7,040 [880*8]
			Total	$7,890

Cost of Goods Sold:-

Sale Date	Units Sold	Cost per unit	Total Cost of Goods sold
October 4	4	$850	$3,400 [850*4]
October 13	3	$850 for 1 unit & $860 each for 2 units	$2,570 [850+(860*2)]
October 28	7	$860 each for 3 units and $870 each for 4 units	$6,060 [(860*3)+(870*4)]
		Total	$12,030