Question

Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system.

Date			Transactions	Units				Unit Cost				Total Cost
March	1		Beginning inventory		20			$	190				$	3,800
March	5		Sale ($280 each)		15
March	9		Purchase		10				210					2,100
March	17		Sale ($330 each)		8
March	22		Purchase		10				220					2,200
March	27		Sale ($355 each)		12
March	30		Purchase		8				240					1,920
													$	10,020

  rev: 02_28_2017_QC_CS-80932

Required:

1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. The March 5 sale consists of bikes from beginning inventory, the March 17 sale consists of bikes from the March 9 purchase, and the March 27 sale consists of four bikes from beginning inventory and eight bikes from the March 22 purchase.

2. Using FIFO, calculate ending inventory and cost of goods sold at March 31.

3. Using LIFO, calculate ending inventory and cost of goods sold at March 31.

4. Using weighted-average cost, calculate ending inventory and cost of goods sold at March 31. (Round your intermediate and final answers to 2 decimal places.)

5. Calculate sales revenue and gross profit under each of the four methods. (Round weighted-average cost amounts to 2 decimal places.)

6. If Greg’s Bicycle Shop chooses to report inventory using LIFO instead of FIFO, record the LIFO adjustment. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.)

Answer 1

Answer 1.

Answer 2.

Answer 3.

Answer 4.

Answer 5.

Answer 6.