FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
The beginning inventory and the purchases and sales of inventory for April for the Concord Company | |||||||||
are as presented below. Complete the inventory schedule assuming the Weighted Average (WAVG) | |||||||||
Date | Transaction | Number of Units | Per Unit | Total | |||||
Apr 1 | Inventory | 10,500 | $1.50000 | $15,750 | |||||
Apr 8 | Purchase | 12,000 | $1.59375 | $19,125 | |||||
Apr 11 | Sold | 11,000 | $2.50000 | $27,500 | |||||
Apr 12 | Sold | 9,500 | $2.50000 | $23,750 | |||||
Apr 14 | Purchase | 8,000 | $1.65000 | $13,200 | |||||
Apr 15 | Sold | 5,000 | $2.60000 | $13,000 | |||||
Apr 19 | Sold | 4,000 | $2.60000 | $10,400 | |||||
Apr 22 | Purchase | 6,000 | $1.70000 | $10,200 | |||||
Apr 24 | Sold | 3,000 | $2.60000 | $7,800 | |||||
Apr 25 | Sold | 3,000 | $2.60000 | $7,800 | |||||
Apr 26 | Purchase | 9,000 | $1.72000 | $15,480 | |||||
Apr 28 | Sold | 5,000 | $2.60000 | $13,000 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- The following units of a particular item were availlable for sale during the calendar year: Jan. 1 Inventory 4,100 units at $39 Apr. 19 Sale 2,300 units June 30 Purchase 4,500 units at $43 Sept. 2 Sale 5,200 units Nav. 15 Purchase 2,100 units at $46 The firm maintains a perpetual inventory system. Determine the cost of goods ssold for each sale and the inventory balance after each sale, assuming the last-in, first-out method. Present the illustrated in Exhibit 4. Under LIFO, if units are in inventory at two or more different costs, enter the units with the LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods Sold LIFO Method Cost of Goods Sold Inventory Purchases Quantity Total Cos Quantity Unit Cost Total Cost Unit Cost Unit Cost Total Cost Quantity Date Jan. 1 Apr. 19 June 30 Sept. 2 Nov. 15 Dec. 31 Balancesarrow_forwardInventory Turnover and Days' Sales in Inventory Financial statement data for years ending December 31 for Amsterdam Company follow: 20Y4 20Y3 Cost of merchandise sold $3,598,900 $3,015,630 Inventories: Beginning of year 593,000 589,600 End of year 648,000 593,000 a. Determine the inventory turnover for 20Y4 and 20Y3. Round to decimal K) place. Inventory Turnover 20Y4 20Υ3 b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and final answers to one decimal place. Days' Sales in Inventory 20Υ4 days 20Υ3 days c. Does the change in the inventory turnover and the days' sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend? Favorable v Feedback V Check My Work The average inventory must be computed first. Consider the components involved in these ratios. Generally, the larger the inventory turnover the more efficiently and effectively the company is managing inventory.arrow_forwardAlternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 500 17 Purchase 200 $5.30 25 Sale 150 28 Purchase 100 5.80 May 5 Purchase 250 5.30 18 Sale 300 22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Instructions: 1. Compute the inventories at the end of each month and the cost of goods sold for each month for the following alternatives: FIFO periodic Cost of Goods Sold Ending Inventory April $ fill in the blank 1 $ fill in the blank 2 May $ fill in the blank 3 $ fill in the blank 4 FIFO perpetual Cost of Goods Sold Ending Inventory April $ fill in the blank 5 $ fill in the blank 6 May $ fill in the blank 7 $ fill in the blank 8 LIFO periodic Cost of Goods Sold Ending Inventory…arrow_forward
- ojo Industries 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 accounting period, January 31. The inventory’s selling price is $12 per unit. Transactions Unit Cost Units Total Cost Inventory, January 1 $ 4.00 190 $ 760 Sale, January 10 (170 ) Purchase, January 12 4.50 240 1,080 Sale, January 17 (110 ) Purchase, January 26 5.50 70 385 Assume that for Specific identification method the January 10 sale was from the beginning inventory and the January 17 sale was from the January 12 purchase. Required: Compute the amount of goods available for sale, ending inventory, and cost of goods sold at January 31 under each of the following inventory costing methods: (Round your intermediate…arrow_forwardPeriodic 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 5 units at $31 $155 Aug. 13 Purchase 12 units at $34 408 Nov. 30 Purchase 11 units at $35 385 Available for sale 28 units $948 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 the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3arrow_forwardusing perpetual inventoryarrow_forward
- The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 60 $525 $31,500 8 Purchase 120 630 75,600 11 Sale 80 1,750 140,000 30 Sale 50 1,750 87,500 May 8 Purchase 100 700 70,000 10 Sale 60 1,750 105,000 19 Sale 30 1,750 52,500 28 Purchase 100 770 77,000 June 5 Sale 60 1,840 110,400 16 Sale 80 1,840 147,200 21 Purchase 180 840 151,200 28 Sale 90 1,840 165,600 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.arrow_forwardPeriodic 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 $4,100 $61,500 Aug. 7 Purchase 20 units at $4,300 86,000 Dec. 11 Purchase 11 units at $4,400 48,400 46 units $195,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).arrow_forwardPeriodic 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 9 units at $48 $432 Aug. 13 Purchase 8 units at $50 400 Nov. 30 Purchase 11 units at $52 572 Available for sale 28 units $1,404 There are 11 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) 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) 2$ b. Last-in, first-out (LIFO) c. Weighted average costarrow_forward
- The accounting records of Sheridan Company show the following data. Beginning inventory 2,710 units at $5 Purchases 7,470 units at $7 Sales 9,376 units at $10 Calculate average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Average unit cost ______ Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost Cost of goods sold: FIFO, LIFO, Average costarrow_forwardThe following inventory transactions took place for Wildhorse Ltd. for the year ended December 31, 2023: Cost/ Selling Date Event Quantity Price Jan 1 beginning inventory 19,900 $42.85 Jan 5 sale 5,840 73.00 Feb 15 purchase 34,800 40.25 Mar 10 purchase 10,200 49.00 May 20 sale 42,100 73.00 Aug 22 purchase 15,100 44.80 Sep 12 sale 20,200 73.00 Nov 24 purchase 9,000 47.00 Dec 5 sale 16,200 73.00 Calculate the ending inventory balance for Wildhorse Ltd., assuming the company uses a perpetual inventory system and the moving- average cost formula. Also calculate the per-unit cost of the last item sold. (Round unit costs to 2 decimal places, e.g. 52.75 and ending inventory to O decimal places, e.g. 5,275.) Ending inventory Unit cost of the last item sold $ eTextbook and Media Suarrow_forwardPeriodic 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 16 units at $48 $768 Aug. 13 Purchase 13 units at $51 663 Nov. 30 Purchase 20 units at $52 1,040 Available for sale 49 units $2,471 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
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