CP7-1 Analyzing the Effects of Four Alternative Inventory Costing Methods [LO 7-
ID: 2545330 • Letter: C
Question
CP7-1 Analyzing the Effects of Four Alternative Inventory Costing Methods [LO 7-3] Scrappers Supplies tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31 Transactions Units Unit Cost 230 523 Beginning inventory, January 1 Transactions during the year a. Purchase on account, March 2 b. Cash sale, April 1 ($39 each) c. Purchase on account, June 30 d. Cash sale, August 1 (539 each) 370 25 (380) 280 29 (80) TIP: Although the purchases and sales are listed in chronological order, Scrappers determines the cost of goods sold after all of the purchases have occurred Requirec 1. Compute the cost of goods available for sale, cost of ending inventory, and cost of goods sold at December 31 under each of the following inventory costing methods: (Round "Cost per Unit to 2 decimal places.) a. Last-in, first-out (Periodic) Cost per Units Total Unit Beginning Inventory 2301 $ 23.00 $ 5.290 Purchases March 2 June 30 370 S 25.00 280 S 29.00 850 880 Total Purchases 17.370 Goods Available for Sale 22.680 Cost of Goods Sold Units from Beginning Inventory Units from March 2 Purchase Units from June 30 Purchase Total Cost of Goods Sold S 25.00 280 S 29.00 280 420 8.120 Ending Inventory b. Weighted average cost. Weighted Average Cost (Periodic) Cost per Unit Units Total Beginning Inventory Purchases March 2 June 30 Total Purchases Goods Available for Sale Cost of Goods Sold Ending InventoryExplanation / Answer
Answer
LIFO
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
Units from Mar 2 Purchase
180
$ 25.00
$ 4,500.00
Units from June 30 purchase
280
$ 29.00
$ 8,120.00
Total cost of goods sold
460
$ 12,620.00
Ending inventory
420
$ 10,040.00
FIFO
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
230
$ 23.00
$ 5,290.00
Units from Mar 2 Purchase
230
$ 25.00
$ 5,750.00
Units from June 30 purchase
Total cost of goods sold
460
$ 11,040.00
Ending inventory
420
$ 11,620.00
Specific Identification
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
76
$ 23.00
$ 1,748.00
Units from Mar 2 Purchase
304
$ 25.00
$ 7,600.00
Units from June 30 purchase
80
$ 29.00
$ 2,320.00
Total cost of goods sold
460
$ 11,668.00
Ending inventory
420
$ 10,992.00
Weighted Average Method
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 25.75
$ 22,660.00
Cost of goods sold
460
$ 25.75
$ 11,845.00
Ending inventory
420
$ 25.75
$ 10,815.00
FIRST IN, FIRST OUT will result in highest gross profit, as it has the lowest Cost of Goods Sold
Hence, answer is Option – C
LAST IN, FIRST OUT, will have lowest income taxes. This is because, cost of goods sold is highest under this method. As a result, the gross profits will be lower, and so will be net income before taxes. Lower income will lead to lower taxes.
Hence, correct answer is Option - A
LIFO
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
Units from Mar 2 Purchase
180
$ 25.00
$ 4,500.00
Units from June 30 purchase
280
$ 29.00
$ 8,120.00
Total cost of goods sold
460
$ 12,620.00
Ending inventory
420
$ 10,040.00
FIFO
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
230
$ 23.00
$ 5,290.00
Units from Mar 2 Purchase
230
$ 25.00
$ 5,750.00
Units from June 30 purchase
Total cost of goods sold
460
$ 11,040.00
Ending inventory
420
$ 11,620.00
Specific Identification
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 22,660.00
Cost of Goods Sold:
Units from Beginning inventory
76
$ 23.00
$ 1,748.00
Units from Mar 2 Purchase
304
$ 25.00
$ 7,600.00
Units from June 30 purchase
80
$ 29.00
$ 2,320.00
Total cost of goods sold
460
$ 11,668.00
Ending inventory
420
$ 10,992.00
Weighted Average Method
Units
Cost per unit
Total
Beginning Inventory
230
$ 23.00
$ 5,290.00
Purchases:
Mar-02
370
$ 25.00
$ 9,250.00
Jun-30
280
$ 29.00
$ 8,120.00
Total purchases
650
$ 17,370.00
Goods available for sale
880
$ 25.75
$ 22,660.00
Cost of goods sold
460
$ 25.75
$ 11,845.00
Ending inventory
420
$ 25.75
$ 10,815.00