**Inventory Costing Methods: Calculating Goods Available, Ending Inventory, and Cost of Goods Sold**To effectively manage inventory and financial statements, businesses utilize various inventory costing methods. These methods determine the amount of goods available for sale, the ending inventory, and the cost of goods sold as of December 31. The calculations should be precise (rounded to two decimal places) with final answers rounded to the nearest whole dollar. The primary methods include:1. **Last-in, First-out (LIFO)**2. **Weighted Average Cost**3. **First-in, First-out (FIFO)**4. **Specific Identification****Data Table:**| Inventory Costing Method | Amount of Goods Available for Sale | Ending Inventory | Cost of Goods Sold ||------------------------------|------------------------------------|------------------|--------------------|| a. Last-in, First-out | | | || b. Weighted average cost | | | || c. First-in, First-out | | | || d. Specific identification | | | |When using these methods, it is crucial to accurately compute and record each category for informed and effective financial analyses and decisions. Each method impacts financial outcomes differently, which must be considered when choosing an appropriate inventory strategy. Gladstone Company 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 ||------------------------------------|-------|-----------|| Beginning inventory, January 1 | 1,700 | $50 || Transactions during the year: | | || a. Purchase, January 30 | 3,200 | 63 || b. Sale, March 14 ($100 each) | (1,350)| || c. Purchase, May 1 | 1,900 | 80 || d. Sale, August 31 ($100 each) | (1,800)| |Assuming that for the Specific identification method (item 1d) the March 14 sale was selected two-fifths from the beginning inventory and three-fifths from the purchase of January 30.**Required:**1. Compute the amount of goods available for sale, ending inventory, and cost of goods sold at December 31 under each of the following inventory costing methods: a. Last-in, first-out. b. Weighted average cost. c. First-in, first-out. d. Specific identification, assuming that the March 14 sale was selected two-fifths from the beginning inventory and three-fifths from the purchase of January 30. Assume that the sale of August 31 was selected from the remainder of the beginning inventory, with the balance from the purchase of May 1.2-a. Of the four methods, which will result in the highest gross profit?2-b. Of the four methods, which will result in the lowest income taxes?

A) Last in First out: Date Purchases Cost of Goods Sold Closing Inventory Qty.…

Answered: Unit Transactions Units Cost $ 50…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Specific Identification, FIFO, LIFO, and Weighted-Average Boyce Company's beginning inventory and purchases during the fiscal year ended September 30, 20-2, are shown. Units Unit Price Total Cost October 1, 20-1 Beginning inventory 400 $15.00 $6,000 October 18 1st purchase 300 16.50 4,950 November 25 2nd purchase 600 17.00 10,200 January 12, 20-2 3rd purchase 700 17.25 12,075 March 17 4th purchase 800 18.00 14,400 June 2 5th purchase 400 19.00 7,600 August 21 6th purchase 300 21.00 6,300 September 27 7th purchase 500 21.75 10,875 4,000 $72,400 Use the following information for the specific identification method. There are 900 units of inventory on hand on September 30, 20-2. Of these 900 units: 50 are from October 18, 20-1 1st purchase 300 are from January 12, 20-2 3rd purchase 100 are from March 17 4th purchase 200 are from June 2 5th purchase 50 are from August 21 6th purchase 200 are from September 27 7th purchase
Gladstone Company 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 Beginning inventory, January 1 3,200 $ 45 Transactions during the year: a. Purchase, January 30 4,550 55 b. Sale, March 14 ($100 each) (2,850 ) c. Purchase, May 1 3,250 75 d. Sale, August 31 ($100 each) (3,300 ) Assuming that for the Specific identification method (item 1d) the March 14 sale was selected two-fifths from the beginning inventory and three-fifths from the purchase of January 30. Assume that the sale of August 31 was selected from the remainder of the beginning inventory, with the balance from the purchase of May 1.
Periodic inventory by three methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory Jan. 10 Purchase Jan. 28 Sale Jan. 30 Sale Feb. 5 Sale Feb. 10 Purchase Feb. 16 Sale Feb. 28 Sale Mar. 5 Purchase Mar. 14 Sale Mar. 25 Purchase Mar. 30 Sale 9,000 $60.00 $540,000 21,000 70.00 1,470,000 10,250 140.00 1,435,000 5,750 140.00 805,000 3,500 140.00 490,000 39,500 75.00 2,962,500 15,000 150.00 2,250,000 10,000 150.00 1,500,000 25,000 82.00 2,050,000 30,000 150.00 4,500,000 10,000 88.40 884,000 19,000 150.00 2,850,000 1. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the first-in, first-out method and the periodic inventory system. Inventory, March 31 $ 966,000 ✓ Cost of goods sold $ 6,940,500 2. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the…
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $5,000 $75,000 Aug. 7 Purchase 16 units at $5,100 81,600 Dec. 11 Purchase 11 units at $5,300 58,300 42 units $214,900 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (Round per unit cost to two decimal places and your final answer to the nearest whole dollar). а. First-in, first-out (FIFO) $4 b. Last-in, first-out (LIFO) С. Weighted average cost
9. Sylvia's Designs Co. had the following inventory activity during April: Unit Units 100 Cost $10 Beginning inventory Purchase (April 3) Sale (April 10) Purchase (April 18) Purchase (April 23) Sale (April 28) 50 12 80 40 14 60 15 120 Assuming Sylvia's uses a periodic LIFO cost flow assumption, ending inventory for April would be a. $2,560 b. $ 750 c. $2,310 d. $ 500
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 1,045 units @ $130 Feb. 17 Purchase 1,380 units @ $132 July 21 Purchase 1,660 units @ $135 Nov. 23 Purchase 1,130 units @ $137 There are 1,205 units of the item in the physical inventory at December 31. The periodic inventory system is used. a. Determine the inventory cost by the first-in, first-out method. b. Determine the inventory cost by the last-in, first-out method. C. Determine the inventory cost by the weighted average cost method. Do not round intermediate calculation and round final answer to the nearest whole dollar. 11:52 PM 5/20/2021 DI %24 %24 %24
Periodic Inventory by Three Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 1,080 units @ $120 Feb. 17 Purchase 1,380 units @ $122 Jul. 21 Purchase 1,525 units @ $125 Nov. 23 Purchase 1,145 units @ $125 There are 1,220 units of the item in the physical inventory at December 31. The periodic inventory system is used. Do not round intermediate calculation and round final answer to nearest whole value. a. Determine the inventory cost by the first-in, first-out method.$fill in the blank 1 b. Determine the inventory cost by the last-in, first-out method.$fill in the blank 2 c. Determine the inventory cost by the weighted average cost method.$fill in the blank 3
Use the following information for questions 17-19 Maxwell Inc. uses the periodic inventory system. During its first year of operations, Maxwell made the following purchases, listed in chronological order of acquisition: 40 units at $100 per unit 70 units at $80 per unit 170 units at $60 per unit Sales for the year totaled 270 units. 17. Ending inventory using the average cost method (rounded) is: A. $650 B. $1,000 C. $707 D. $600
Case D Tompkins Company reports the following Inventory record for November. Date November 1 November 4 November 7 November 13 November 22 INVENTORY Activity Beginning balance Purchase Sale (@ $53 per unit) Purchase Sale (@ $53 per unit) # of Units 135 320 Cost/Unit $ 18 19 245 525 21 520 Selling, administrative, and depreciation expenses for the month were $15,500. Tompkins's effective tax rate is 40 percent. Required: 1. Calculate the cost of ending Inventory and the cost of goods sold under each of the following methods using periodic Inventory system: 2-a. What is the gross profit percentage under the FIFO method? 2-b. What is net income under the LIFO method? 3. Tompkins applied the lower of cost or market method to value its Inventory for reporting purposes at the end of the month. Assuming Tompkins used the FIFO method and that Inventory had a market replacement value of $17.70 per unit, what would Tompkins report on the balance sheet for Inventory? Complete this question by…

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS