Question

1. Windsor Bank and Trust is considering giving Pohl Company a loan. Before doing so, it decides that further discussions with Pohl’s accountant may be desirable. One area of particular concern is the Inventory account, which has a year-end balance of $335,500. Discussions with the accountant reveal the following.

1.		Pohl shipped goods costing $67,100 to Hemlock Company FOB shipping point on December 28. The goods are not expected to reach Hemlock until January 12. The goods were not included in the physical inventory because they were not in the warehouse.
2.		The physical count of the inventory did not include goods costing $95,000 that were shipped to Pohl FOB destination on December 27 and were still in transit at year-end.
3.		Pohl received goods costing $30,500 on January 2. The goods were shipped FOB shipping point on December 26 by Yanice Co. The goods were not included in the physical count.
4.		Pohl shipped goods costing $62,220 to Ehler of Canada FOB destination on December 30. The goods were received in Canada on January 8. They were not included in Pohl’s physical inventory.
5.		Pohl received goods costing $51,240 on January 2 that were shipped FOB destination on December 29. The shipment was a rush order that was supposed to arrive December 31. This purchase was included in the ending inventory of $275,000.

Determine the correct inventory amount on December 31.

Correct inventory on December 31

$enter the correct inventory amount on December 31 in dollars

2. In its first month of operation, Sage Hill Company purchased 110 units of inventory for $6, then 220 units for $7, and finally 142 units for $8. At the end of the month, 204 units remained. The company uses the periodic method.

Compute the amount of phantom profit that would result if the company used FIFO rather than LIFO.

Phantom profit

$enter Phantom profit in dollars

3. Wildhorse Company took a physical inventory on December 31 and determined that goods costing $244,000 were on hand. Not included in the physical count were $30,500 of goods purchased from Pelzer Corporation, FOB, shipping point, and $26,840 of goods sold to Alvarez Company for $36,600, FOB destination. Both the Pelzer purchase and the Alvarez sale were in transit at year-end.

What amount should Wildhorse report as its December 31 inventory?

Ending inventory

$enter the Ending inventory in dollars

4. In its first month of operations, Oriole Company made three purchases of merchandise in the following sequence: (1) 200 units at $3, (2) 300 units at $5, and (3) 500 units at $6. Assuming there are 100 units on hand at the end of the period. Oriole uses a periodic inventory system.

Compute the cost of the ending inventory under the average-cost method. (Round the cost per unit to 3 decimal places, e.g. 8.875 and the final answer to 0 decimal places, e.g. 5,275.)

Cost of the ending inventory

$enter the cost of the ending inventory in dollars

Answer 1

$335,500 1 2 3 Ending Inventory as reported Adjustments: FOB shipped goods FOB destination purchase FOB shipping purchase FOB Destination sale FOB destination purchase Correct Inventory FOB shipping goods belong to customer and not part of inventory FOB Destination goods is not part of inventory till it is received $30,500 FOB shipment goods purchased is part of inventory since ownership is transferred $62,220 FOB Destination goods is part of inventory till it reaches customer -$51,240 FOB Destination goods is not part of inventory till it is received $376,980 4 5 Closing inventory FIFO LIFO Amount of profit $1,570 $1,318 $252 FIFO net income will be higher than LIFO FIFO method Cost of Goods sold #of Unit COGS Units sold Cost #of Units 110 Inventory on Hand #of Unit Inventory Units Cost Balance Date Activity Purchase Purchase Purchase Sales Purchase Unit Cost $6 $7 $8 Total Cost $6601 $1,540 $1,136 220 142 110 158 $6 $7 $660 $1,106 62 142 204 $7 $8 Ending Inventory $434 $1,136 $1,570 Totals 472 $3,336 268 $1,766 LIFO method #of Cost of Goods sold #of Unit COGS Units sold Cost Inventory on Hand #of Unit Inventory Units Cost Balance Date Units Activity Purchase Purchase Purchase Sales Purchase Unit Cost $6 $7 $8 110 220 142 Total Cost $660 $1,540 $1,136 142 126 $1,136 $882) $7 $658 94 110 $7 $6 Ending Inventory $660 $1,318 Totals 472 $3,336 268 $2,018 204 3 $244,000 Ending Inventory as reported Adjustments: FOB shipping purchase FOB Destination sale Correct Inventory to be reported $30,500 FOB shipment goods purchased is part of inventory since ownership is transferred $26,840 FOB Destination goods is part of inventory till it reaches customer $301,340 4 Cost of Ending Inventory $510 Average cost method Cost of Goods sold #of Unit COGS Units sold Cost Inventory on Hand #of Unit Inventory Units Cost Balance Date Activity Purchase Purchase Purchase #of Units 200 300 500 Purchase Unit Cost $3.00 $5.00 $6.00 $5.10 Total Cost $600 $1,500 $3,000 $5,100 1,000 900 $5.10 $4,5901 Sales Ending Inventory 100 100 $5.10 $5.10 $5101 $5101 Totals 900 $4,5901