Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method.Consider the following inventory data for the first two months of the year for CompX International:Total Units Unit Cost Total CostBeginning inventory on handJanuary 160,000$2.10$126,000Purchases during monthJanuary 5103,6002.10217,560January 20293,9002.20646,580457,500$990,140Sales of inventoryJanuary 25383,900Beginning inventory atFebruary 173,600Purchases during monthFebruary 8282,2002.30$649,060February 23153,5002.70414,450509,300Sales of inventoryFebruary 27407,600Ending Inventory101,700 Required1. Calculate the cost of goods sold and ending inventory for January and February under each of the following methods, assuming use of a perpetual inventory management system. Roundall answers to the nearest whole number.JanuaryFebruaryCost ofEndingCost ofEndingGoods SoldInventoryGoods SoldInventorya. FIFO2$20 $20 $20 $20b. LIFO2$20 $20 $20 $20c. Weighted-average.* $20 $20 $20 $20*Do not round until your final answers.2. Assume that the net realizable value of CompX International's ending inventory is $2.15 per unit on January 30 and $2.45 per unit on February 28. Calculate the value of the endinginventory for January and February under each of the following methods. Round all answers to the nearest whole number.JanuaryFebruarya. FIFO20 $220b. LIFO2$20 $20c. Weighted-average $20 $20

Perpetual Inventory Method Perpetual inventory method is a method in which estimation of inventory…

Answered: Calculating the Value of Ending…

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

Suppose that Ralph Lauren Company reports the following for the month of June. Date June 1 12 23 30 Explanation Units Inventory Purchase Purchase Inventory Cost of the ending inventory 360 Cost of goods sold 660 860 390 +A Unit Cost LA $5 6 7 (a) Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption, using a perpetual inventory system. Assume a sale of 730 units occurred on June 15 for a selling price of $8 and a sale of 760 units on June 27 for $9. (Round average cost per unit to 3 decimal places, e.g. 5.254 and final answers to O decimal places, e.g. 2,520.) Total Cost FIFO $1,800 3,960 6,020 LA $ LIFO LA $ Moving Average
Weighted Average Cost Flow Method Under Perpetual Inventory System The following units of a particular item were available for sale during the calendar year: Jan. 1 Inventory 4,000 units at $20 Apr. 19 Sale 2,500 units June 30 Purchase 6,000 units at $24 Sept. 2 Sale 4,500 units Nov. 15 Purchase 1,000 units at $25 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round unit cost to two decimal places, if necessary. Schedule of Cost of Goods SoldWeighted Average Cost Flow Method Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Jan. 1 fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Apr. 19 fill in the blank 4 $fill in the blank 5 $fill in the blank 6 fill in the blank 7…
Suppose that Ralph Lauren Company reports the following for the month of June. Date June 1 12 23 30 Explanation Units Unit Cost Inventory $4 Purchase Purchase Inventory Cost of the ending inventory 240 Cost of goods sold 540 740 270 $ 6 $ 8 (a) Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption, using a perpetual inventory system. Assume a sale of 610 units occurred on June 15 for a selling price of $8 and a sale of 640 units on June 27 for $9. (Round average cost per unit to 3 decimal places, e.g. 5.254 and final answers to O decimal places, e.g. 2,520.) Total Cost FIFO $960 3,240 5,920 $ $ LIFO $ $ Moving Average
The following units of a particular item were available for sale during the calendar year: Jan. 1 Apr. 19 Inventory Sale 4,000 units at $50 2,500 units June 30 Purchase 4,500 units at $54 Sept. 2 Sale 5,000 units Purchase 2,000 units at $56 Nov. 15 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Date Purchases Quantity Purchases Unit Cost Purchases Total Cost Quantity Weighted Average Cost Flow Method Cost of Goods Sold Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Jan. 1 Apr. 19 June 30 Sept. 2 Nov. 15 ☐ ☐ ☐ ☐ ☐ ☐ Dec. 31 Balances
Inventory Costing Methods-Periodic Method The following data are for the Graham Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 1,200 $24 Purchases: February 11 1,500 $25 May 18 1,400 26 October 23 1,100 28 Sales: March 1 1,400 July 1 1,400 October 29 1,000 Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in, first-out, (b) last-in, first-out, and (c) weighted-average cost method.Hint: For weighted-average cost, round the cost per unit to 3 decimal places and round your final answers to the nearest dollar. a. First-in, First-out: Ending Inventory Answer Cost of goods sold Answer b. Last-in, first-out: Ending Inventory Answer Cost of goods sold Answer c. Weighted Average Ending Inventory Answer Cost of goods sold Answer
Calculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO). Number of units Unit cost Sales Beginning inventory 800 $ 50 purchased 600 52 Sold 400 $ 80 Sold 350 90 Ending inventory 650 Use this chart: FIFO (perpetual) Inventory Cost of Goods Purchased Cost of Goods Sold Cost of Inventory Remaining Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Beginning Purchase Sale…
Aircard Corporation 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. The following are the transactions for the month of July. Units Unit Cost July 1 Beginning Inventory 2,000 $ 35 July 5 Sold 1,000 July 13 Purchased 6,000 39 July 17 Sold 3,000 July 25 Purchased 8,000 41 July 27 Sold 5,000 Calculate the cost of goods available for sale, ending inventory, and cost of goods sold if Aircard uses (a) FIFO, (b) LIFO, or (c) weighted average cost. (Round "Cost per Unit" to 2 decimal places.)\
The following lots of Commodity Z were available for sale during the year. Beginning inventory 11 units at $47 First purchase 19 units at $52 Second purchase 50 units at $56 Third purchase 17 units at $60 The firm uses the periodic system, and there are 28 units of the commodity on hand at the end of the year. What is the ending inventory balance at the end of the year according to the LIFO method? a.$5,325 b.$1,316 c.$1,401 d.$1,636
Inventory Costing Methods Oppenheimer Inc. reported the following information for the month of May: Inventory, May 1 58 units @ $18 Purchase: Мay 7 48 units @ $20 May 18 61 units @ $21 May 27 40 units @ $22 During May, Oppenheimer sold 133 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for May under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1. Of the 133 units sold, 49 cost $18, 34 cost $20, 46 cost $21, and 4 cost $22. $ 2. FIFO %$4 3. LIFO 2$ 4. Weighted average method (Round average unit cost to the nearest cent, $ and round all other calculations and your final answers to the nearest dollar.)
A company had the following purchases and sales during its first year of operations: Purchases Sales February: January: 22 units at $180 14 units 32 units at $185 12 units May: 27 units at $190 16 units September: 24 units at $195 15 units November: 22 units at $200 28 units On December 31, there were 42 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales were made on the last day of the month.) Multiple Choice $9,387. $7,815. $9,315.
During the year, TRC Corporation has the following inventory transactions. Date Jan. 1 Beginning inventory Apr. 7 Purchase Jul.16 Purchase Oct. 6 Purchase Weighted Average Cost Total Beginning Inventory Purchases: Apr 07 Jul 16 Oct 06 Transaction Sales revenue Gross profit For the entire year, the company sells 450 units of inventory for $70 each. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 2 decimal places and all other answers to the nearest whole number.) Number of Units 60 140 210 120 530 Cost of Goods Available for Sale # of units 60 140 210 120 530 Average Cost per unit Cost of Goods Available for Sale $ $ Unit Cost 3,120 $ 52 54 57 58 7,560 11,970 6.960 29,610 Total Cost $ 3,120 7,560 11,970 6,960 $29,610 Cost of Goods Sold - Weighted Average Cost of units Sold Average Cost of Cost per Unit Goods Sold Ending Inventory - Weighted Average Cost # of units in Ending Inventory…
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Date Transaction Number of units Per unit ($) Total ($) April 3 Inventory 25 1.200 30.000 8 Purchase 75 1.240 93.000 11 Sale 40 2.000 80.000 30 Sale 30 2.000 60.000 May 8 Purchase 60 1.260 76.500 10 Sale 50 2.000 100.000 19 Sale 20 2.000 40.000 28 Purchase 80 1.260 100.800 June 5 Sale 40 2.250 90.000 16 Sale 25 2.250 56.250 21 Purchase 35 1.264 44.240 28 Sale 44 2.250 99.000 Instructions1. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period, using the first-in, first-out method and the periodic inventory system.2. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period, using the last-in, first-out method and the periodic inventory system.3. Determine the inventory on June 30, 2014, and the cost of goods sold for the threemonth period,…

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