Question

In: Accounting

Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2018, its...

Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2018, its fiscal-year end, based on a physical count, was determined to be $338,000. Capwell's unadjusted trial balance also showed the following account balances: Purchases, $740,000; Accounts payable; $270,000; Accounts receivable, $285,000; Sales revenue, $920,000.

The internal audit department discovered the following items:

Goods valued at $44,000 held on consignment from Dix Company were included in the physical count but not recorded as a purchase.

Purchases from Xavier Corporation were incorrectly recorded at $64,000 instead of the correct amount of $46,000. The correct amount was included in the ending inventory.

Goods that cost $37,000 were shipped from a vendor on December 28, 2018, terms f.o.b. destination. The merchandise arrived on January 3, 2019. The purchase and related accounts payable were recorded in 2018.

One inventory item was incorrectly included in ending inventory as 220 units, instead of the correct amount of 1,600 units. This item cost $50 per unit.

The 2017 balance sheet reported inventory of $472,000. The internal auditors discovered that a mathematical error caused this inventory to be understated by $74,000. This amount is considered to be material. Comparative financial statements will be issued.

Goods shipped to a customer f.o.b. destination on December 25, 2018, were received by the customer on January 4, 2019. The sales price was $52,000 and the merchandise cost $28,000. The sale and corresponding accounts receivable were recorded in 2018.

Goods shipped from a vendor f.o.b. shipping point on December 27, 2018, were received on January 3, 2019. The merchandise cost $30,000. The purchase was not recorded until 2019.


Required:
1. Determine the correct amounts for 2018 ending inventory, purchases, accounts payable, accounts receivable, and sales revenue.
2. Calculate cost of goods sold for 2018.
3. What was the effect of the error in ending inventory on 2017 before-tax income

Determine the correct amounts for 2018 ending inventory, purchases, accounts payable, accounts receivable, sales revenue, and cost of goods sold.

Ending inventory
Purchases
Accounts payable
Accounts receivable
Sales revenue
Cost of goods sold
            

What was the effect of the error in ending inventory on 2017 before-tax income?

2017 before-tax income was          by
         

Solutions

Expert Solution

Part 1)

The correct values are calculated as below:

Inventory Purchases Accounts Payable Accounts Receivable Sales Revenue
Unadjusted Balance 338,000 740,000 270,000 285,000 920,000
1 -42,000
2 -18,000 (64,000 - 46,000) -18,000 (64,000 - 46,000)
3 -37,000 -37,000
4 69,000 [(1,600 - 220)*50]
5 No Adjustment Needed.
6 28,000 -52,000 -52,000
7 30,000 30,000 30,000
Adjusted Balance $423,000 $715,000 2,45,000 $233,000 $868,000

_____

Tabular Representation (As Required in Question)

Ending Inventory $423,000
Purchases $715,000
Accounts Payable $245,000
Accounts Receivable $233,000
Sales Revenue $868,000

_____

Part 2)

The value of cost of goods sold is determined as below:

Opening Inventory (472,000 + 74,000) 546,000
Add Purchases 715,000
Less Closing Inventory 423,000
Cost of Goods Sold $838,000

_____

Part 3)

The 2017 before-tax income was understated by $74,000

____

Explanation:

The understatement of inventory at the end of 2017, would have resulted in an overstatement of the cost of goods sold. Ovestated cost of goods sold will result in a decrease in before-tax income by the amount of such understatement (which is $74,000 in the given case).


Related Solutions

Adams Corporation uses a periodic inventory system and the retail inventory method to estimate ending inventory...
Adams Corporation uses a periodic inventory system and the retail inventory method to estimate ending inventory and cost of goods sold. The following data are available for the month of September 2021: Cost Retail Beginning inventory $ 20,200 $ 39,800 Net purchases 10,100 ? Net markups 4,800 Net markdowns 1,800 Net sales ? The company used the average cost flow method and estimated inventory at the end of September to be $15,200.50. If the company had used the LIFO cost...
Adams Corporation uses a periodic inventory system and the retail inventory method to estimate ending inventory...
Adams Corporation uses a periodic inventory system and the retail inventory method to estimate ending inventory and cost of goods sold. The following data are available for the month of September 2021:                                                                  Cost                          Retail Beginning inventory                             23000                       37000 Net purchases                                     11500                         ? Net markups                                                                        4200 Net markdowns                                                                    1200 Net sales                                                                               ? The company used the average cost flow method and estimated inventory at the end of September to be $19,607.50. If the company had used the LIFO cost...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 36 Units @ $15 = $540 Inventory, December 31, using LIFO → 36 Units @ $11 = $396 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 48 16 $ 768 Purchase, January 20 98 17 1,666 Sale, January 11 (at $39 per unit) 78 Sale, January 27 (at $40 per unit) 54 Required: Compute the number...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 58 Units @ $24 = $1,392 Inventory, December 31, using LIFO → 58 Units @ $20 = $1,160 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 70 25 $ 1,750 Purchase, January 20 120 26 3,120 Sale, January 11 (at $48 per unit) 100 Sale, January 27 (at $49 per unit) 76 Required: Compute the number...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 50 Units @ $20 = $1,000 Inventory, December 31, using LIFO → 50 Units @ $16 = $800 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 62 21 $ 1,302 Purchase, January 20 112 22 2,464 Sale, January 11 (at $44 per unit) 92 Sale, January 27 (at $45 per unit) 68 Required: Compute the number...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO ? 38 Units @ $14 = $532 Inventory, December 31, using LIFO ? 38 Units @ $10 = $380      Transactions in the Following Year    Units Unit Cost   Total Cost   Purchase, January 9 50 $ 15 750   Purchase, January 20 100 16 1,600   Sale, January 11 (at $38 per unit) 80   Sale, January 27 (at $39 per unit) 56 1. Compute the...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 44 Units @ $19 = $836 Inventory, December 31, using LIFO → 44 Units @ $15 = $660   Transactions in the Following Year    Units Unit Cost   Total Cost   Purchase, January 9 56 $ 20 1,120   Purchase, January 20 106 21 2,226   Sale, January 11, (at $43 per unit) 86   Sale, January 27 (at $44 per unit) 62 Required: 1. Compute the...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 44 Units @ $17 = $748 Inventory, December 31, using LIFO → 44 Units @ $13 = $572 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 56 18 $ 1,008 Purchase, January 20 106 19 2,014 Sale, January 11 (at $41 per unit) 86 Sale, January 27 (at $42 per unit) 62 Required: Compute the number...
Capwell Corporation uses a periodic inventory system
Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2011, its fiscal-year end, based on a physical count, was determined to be $326,000. Capwell's unadjusted trial balance also showed the following account balances: Purchases, $620,000; Accounts payable; $210,000; Accounts receivable, $225,000; Sales revenue, $840,000. The internal audit department discovered the following items:1. Goods valued at $32,000 held on consignment from Dix Company were included in the physical count but not recorded as a purchase.2. Purchases...
ABC uses a periodic inventory system, and the ending inventory for each year is determined by...
ABC uses a periodic inventory system, and the ending inventory for each year is determined by taking a complete physical inventory at year-end. A physical count was taken on December 31, 2016, and the inventory on-hand at that time totaled $70,000, which reflects historical cost. Record the adjusting entry for properly recognizing 2016 Cost of Goods Sold. Hint: This was the first year of operations, so beginning inventory balance is zero. Additionally, ABC adheres to GAAP by recording ending inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT