### Inventory Record Information for CNB Company - September#### Starting Inventory and Purchases:- **Beginning Inventory (9/1/2021):** 8,000 units at $10.00 each- **Purchases:** - 9/7: 6,000 units at $10.70 each - 9/25: 9,000 units at $12.60 each#### Sales:- **9/10:** 8,000 units- **9/29:** 9,000 units6,000 units were on hand at the end of September.### Requirements:1. Using a periodic inventory system with the average cost method, calculate the cost of goods sold (COGS) and ending inventory for September.2. Using a perpetual inventory system with the average cost method, calculate the COGS and ending inventory for September.### Average Cost Method - Periodic System**Cost of Goods Available for Sale:**| Description | # of Units | Unit Cost | Cost of Goods Available for Sale ||--------------------|------------|-----------|----------------------------------|| Beginning Inventory| 8,000 | $10.00 | $80,000 || 9/7 Purchases | 6,000 | $10.70 | $64,200 || 9/25 Purchases | 9,000 | $12.60 | $113,400 || **Total** | 23,000 | | $257,600 |**Cost of Goods Sold - Average Cost:**The table has placeholders for # of units sold, average cost per unit, and cost of goods sold.**Ending Inventory - Average Cost:**The table also includes placeholders for # of units in ending inventory, average cost per unit, and ending inventory value.Ensure that any calculations needed for determining these values are based on the summation of available units and their respective costs and that the cost per unit is rounded to two decimal places as stated. **Title: Calculating Cost of Goods Sold Using the Perpetual Inventory System****Assumption:**CNB uses a perpetual inventory system with the average cost method. The task is to determine the cost of goods sold for September and the ending inventory for the same month. Note: Inventory reductions for sales should be entered with a minus sign, and cost per unit should be rounded to two decimal places.**Perpetual Average Inventory Table:**| Date | Inventory on Hand | Cost of Goods Sold ||------------------------|-------------------------|-----------------------------|| | # of Units | Cost per Unit | Inventory Value | # of Units Sold | Average Cost per Unit | Cost of Goods Sold || Beginning Inventory | | | | | | || Purchase - September 7 | | | | | | || Subtotal Average Cost | 0 | | $ | 0 | | || Sale - September 10 | | | | | | || Subtotal Average Cost | 0 | | $ | 0 | | || Purchase - September 25| | | | | | || Subtotal Average Cost | 0 | | $ | 0 | | || Sale - September 29 | | | | | | || Total | 0 | | $0 | 0 | | $0 |- **Description:** This table helps track inventory and compute the cost of goods sold using the average cost method within a perpetual inventory system. - **Columns Breakdown:** - **Inventory on hand:** Tracks the number of units, cost per unit, and total inventory value. - **Cost of Goods Sold:** Shows the number of units sold, average cost per unit, and total cost of goods sold.**Buttons:**- **Required 1**- **Required 2** (grayed out, indicating the next section or step is inactive or complete).This instructional table provides a clear structure for calculating inventory costs, assisting students in understanding and applying inventory accounting methods effectively.

Name: ### Inventory Record Information for CNB Company - September#### Star
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: ### Inventory Record Information for CNB Company - September#### Starting Inventory and Purchases:- **Beginning Inventory (9/1/2021):** 8,000 units at $10.00 each- **Purchases:** - 9/7: 6,000 units at $10.70 each - 9/25: 9,000 units at $12.60 each

Business

Accounting

The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 Purchases: 9/7 9/25 Sales: 9/10 9/29 6,000 units were on hand at the end of September 8,000 units @ $10.00 6,000 units @ $10.70 9,000 units @ $12.60 8,000 units 9,000 units Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. 2. Assuming that CNB uses a perpetual inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory.

The following information is taken from the inventory records of the CNB Company for the month of September: Beginning inventory, 9/1/2021 Purchases: 9/7 9/25 Sales: 9/10 9/29 6,000 units were on hand at the end of September 8,000 units @ $10.00 6,000 units @ $10.70 9,000 units @ $12.60 8,000 units 9,000 units Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. 2. Assuming that CNB uses a perpetual inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory.

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

The Stilton Company has the following inventory and credit purchases during the fiscal year ended December 31, 2023. Beginning Feb. 10 Aug. 21 640 units @ $75/unit 350 units @ $72/unit 230 units @ $85/unit Stilton Company has two credit sales during the period. The units have a selling price of $135 per unit. Sales Mar. 15 430 units Sept. 10 335 units Stilton Company uses a perpetual inventory system. Required: 1. Calculate the dollar value of cost of goods sold and ending inventory using: (Do not round intermediate calculations. Round "Average cost per unit" to 2 decimal places. Round the final answers to 2 decimal places.) Ending Inventory Cost of Goods Sold a FIFO b. Moving weighted average
The inventory records for Radford Company reflected the following Beginning inventory on May 1 First purchase on May 7 second purchase on May 17 Third purchase on May 23 1,800 units @ $5.20 1,900 units @ $5.40 2,100 units @ $5.50 1,700 units @ $5.60 Sales on May 31 5,700 units @ $7.10 What is the weighted average cost per unit for May? Multiple Choice $5.37 $5.43
s
Suppose that Target Corporation uses the periodic inventory system to account for inventories and has the following information at October 31. October 1 Beginning inventory 400 units $12.00 = $4,800 8 Purchase 800 units @ $12.40 = 9,920 16 Purchase 600 units @ $12.80 = 7,680 24 Purchase 200 units @ $13.60 = 2,720 Total units and cost 2,000 units $25,120 (a) Determine the ending inventory using the FIFO cost assumption if 500 units remain on hand at October 31. Ending inventory $
Using a perpetual inventory system. This company's beginning inventory of a product and its purchases during the month of January were as follows. Quantity Unit Cost Total Cost Beginning inventory(Jan 1) 180 $50 $9,000 Purchase(Jan. 9) 90 $55 $4,950 Purchase(Jan. 22) 90 $56 $5,040 Total 360 $18,990 On Jan 24. the company sold 200 units of this product. The other 160 units remain in inventory at Jan. 31. Determine the Cost of Goods Sold using LIFO, FIFO, and Average Cost.
! Required information [The following information applies to the questions displayed below.] A company began January with 8,000 units of its principal product. The cost of each unit is $9. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Total Date of Sale January 5 January 12 January 20 Total Includes purchase price and cost of freight. Perpetual FIFO: Sales Beginning Inventory Purchases: January 10 January 18 Units 5,000 8,000 13,000 11,000 units were on hand at the end of the month. Units 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. 3,000 3,000 4,000 10,000 5,000 8,000 21,000 Purchases Unit Cost* $ 10 11 Cost of Goods Available for Sale Cost of Number Unit Goods of units Cost Available for Sale 8,000 $9.00 $ 72,000 10.00 11.00 Total Cost $ 50,000 88,000 $ 138,000 50,000 88,000 $ 210,000 Cost of Goods Sold - January 5 Number of units sold 0 0 0 Cost per unit $…
ces Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales transactions. Date Activities January 1 Beginning inventory February 10 Purchase March 13 Purchase March 15 Sales August 21 Purchase September 5 Purchase September 10 Sales Totals Units Acquired at Cost Units Sold at Retail 685 units @$45.00 per unit 570 units @ $42.00 per unit 285 units @ $27.00 per unit 1,140 units @ $75.00 per unit 185 units 585 units @ $50.00 per unit @ $46.00 per unit 2,310 units 770 units @ $75.00 per unit 1,910 units Required: 1. Compute cost of goods available for sale and the number of units available for sale. Cost of goods available for sale Number of units available for sale 2. Compute the number of units in ending inventory. Ending inventory units units
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 Inventory 24 units @ $32 $768 June 16 Purchase 30 units @ $35 1,050 Nov. 28 Purchase 38 units @ $39 1,482 92 units $3,300 There are 15 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. b. Determine the inventory cost by the LIFO method. c. Determine the inventory cost by the average cost methods. Round answer to two decimal places. %24 %24 %24
The inventory records of TC show the following purchases:Month Units CostJanuary 15,000 190,500February 20,000 240,000March 12,500 165,00A physical count on March 31 shows 22,500 units on hand. What amount of inventory should be reported as of March 31, using FIFO method of costing?a. 120,000 b. 225,000 c. 280,500 d. 285,000
The following information applies to the questions displayed below; Hemming Company reported the following current-year purchases and sales for its only product. Date Activities January 1 Beginning inventory January 10 Sales March 14 Purchase March 15 Sales- July 30 Purchase October S October 26 Sales Purchase Totals 275 units 450 units 475 units Units Acquired at Cost $13.00- $18.00 $23.00- Units Sold at Retail $3,575 230 units $43.00 8,100 10,925 408 units 455 units $43.00 $43.00 175 units 1,375 units @$28.90 4,900 $ 27,500 1,885 units Hemming uses a periodic inventory system. (a) Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. (b) Determine the costs assigned to ending inventory and to cost of goods sold using LIFO. (c) Compute the gross profit for each method. a) Periodic FIFO Beginning inventory Purchases March 14 July 30 October 28 Total b) Periodio LIFO Beginning inventory Purchases: Cost of Goods Available for Sale Cost of Goods Sold…
[The following information applies to the questions displayed below.] Hemming Co. reported the following current-year purchases and sales for its only product. Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 195 units @ $13.80 = $ 2,691 Jan. 10 Sales 185 units @ $43.80 Mar. 14 Purchase 345 units @ $18.80 = 6,486 Mar. 15 Sales 235 units @ $43.80 July 30 Purchase 495 units @ $23.80 = 11,781 Oct. 5 Sales 205 units @ $43.80 Oct. 26 Purchase 695 units @ $28.80 = 20,016 Totals 1,730 units $ 40,974 625 units Required: Hemming uses a perpetual inventory system. Compute the gross margin for FIFO method. Sales revenue Less: cost of goods sold Gross Margin…
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