Question

1. Farley Bains, an auditor with Nolls CPAs, is performing a review of Tamarisk Company’s Inventory account. Tamariskdid not have a good year, and top management is under pressure to boost reported income. According to its records, the inventory balance at year-end was $710,400. However, the following information was not considered when determining that amount.

1.		Included in the company’s count were goods with a cost of $218,880 that the company is holding on consignment. The goods belong to Nader Corporation.
2.		The physical count did not include goods purchased by Tamarisk with a cost of $38,400 that were shipped FOB shipping point on December 28 and did not arrive at Tamarisk’s warehouse until January 3.
3.		Included in the Inventory account was $16,320 of office supplies that were stored in the warehouse and were to be used by the company’s supervisors and managers during the coming year.
4.		The company received an order on December 29 that was boxed and was sitting on the loading dock awaiting pick-up on December 31. The shipper picked up the goods on January 1 and delivered them on January 6. The shipping terms were FOB shipping point. The goods had a selling price of $38,400 and a cost of $27,840. The goods were not included in the count because they were sitting on the dock.
5.		Included in the count was $48,000 of goods that were parts for a machine that the company no longer made. Given the high-tech nature of Tamarisk’s products, it was unlikely that these obsolete parts had any other use. However, management would prefer to keep them on the books at cost, “since that is what we paid for them, after all.”

Prepare a schedule to determine the correct inventory amount.

	Ending inventory-as reported		$enter a dollar amount
1.	select an option                                                          Add to inventorySubtract from inventory		enter a dollar amount
2.	select an option                                                          Add to inventorySubtract from inventory		enter a dollar amount
3.	select an option                                                          Add to inventorySubtract from inventory		enter a dollar amount
4.	select an option                                                          Add to inventorySubtract from inventory		enter a dollar amount
5.	select an option                                                          Add to inventorySubtract from inventory		enter a dollar amount
	Correct inventory		$enter a total amount

2. Tamarisk sells a snowboard, EZslide, that is popular with snowboard enthusiasts. Below is information relating to Tamarisk’s purchases of EZslide snowboards during September. During the same month, 105 EZslide snowboards were sold. Tamarisk uses a periodic inventory system.

Date			Explanation		Units		Unit Cost		Total Cost
Sept.	1		Inventory		15		$118		$1,770
	12		Purchase		45		120		5,400
	19		Purchase		50		122		6,100
	26		Purchase		20		123		2,460
			Total		130				$15,730

Compute the ending inventory at September 30 using the FIFO, LIFO and average-cost methods.

		FIFO		LIFO		AVERAGE-COST
Ending inventory at September 30		$enter ending inventory using First In First Out at September 30 in dollars		$enter ending inventory using Last In First Out at September 30 in dollars		$enter ending inventory using average-cost at September 30 in dollars

Compute the cost of goods sold at September 30 using the FIFO, LIFO and average-cost methods.

		FIFO		LIFO		AVERAGE-COST
Cost of goods sold		$enter cost of goods sold using First In First Out in dollars		$enter cost of goods sold using Last In First Out in dollars		$enter cost of goods sold using average-cost in dollars

Answer 1

$710,400 Explanation Ending Inventory as reported Adjustments: Inventory on consignments FOB Shipping Office supplies Goods sitting on dock Obsolete Inventory Correct Inventory -$218,880 Not part of Inventory since held as agent and not purchased $38,400 Part of inventory since risk and ownership is transferred -$16,320 Not part of Inventory $27,840 part of inventory at cost -$48,000 should be valued at lower of cost or net realisable value $493,440

FIFO $3,0701 LIFO Average cost $2,970 $3,025 Ending Inventory Sep 30th FIFO $12,660 LIFO Average cost $12,760 $12,705 Cost of goods sold Sep 30th Working notes: FIFO method Total # of Units Cost of Goods sold #of Unit COGS Units sold Cost Inventory on Hand # of Unit Inventory Units Cost Balance Date Sep 1 Sep 12 Sep 19 Sep 26 Beginning inventory Purchase Purchase Purchase Sales 15 45 50 20 Purchase Unit Cost $118 $120 $122 $123 Cost $1,770 $5,400 $6,100 $2,4601 15 45 45 $118 $120 $122 $1,770 $5,400 $5,490 5 $122 $123 Ending Inventory 20 $610 $2,460 $3,070 Totals 130 $15,730.00 105 $12,660 25 LIFO method # of Units 15 Cost of Goods sold # of Unit COGS Units sold Cost Inventory on Hand # of Unit Inventory Units Cost Balance Date Sep 1 Sep 12 Sep 19 Sep 26 Purchase Unit Cost $118 $120 $122 $123 Beginning inventory Purchase Purchase Purchase Sales Total Cost $1,770 $5,4001 $6,100 $2,4601 45 50 20 20 50 $123 $122 $120 $2,460 $6,100 $4,200 35 10 15 $120 $118 Ending Inventory $1,200 $1,770 $2,970 Totals 130 $15,730 105 $12,760 25 Average cost method Purchase Unit # of Units Cost of Goods sold # of Unit COGS Units sold Cost Inventory on Hand # of Unit Inventory Units Cost Balance 15 Sep 1 Beginning inventory Sep 12 Purchase Sep 19 Purchase Sep 26 Purchase 45 50 20 Cost $118 $120 $122 $123 $121 Total Cost $1,770 $5,4001 $6,100 $2,460 $15,7301 130 105 $121 $12.705 Sales Ending Inventory 25 $121 $121 $3,025 $3,025 Totals 105 $12,705 25