Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 6, Problem P6.29APGA
Accounting for inventory using the perpetual inventory system—FIFO, LIFO, and weighted-average, and comparing FIFO, LIFO, and weighted-average
Learning Objective 2, 3 5. FIFO GP $5,235
Steel Mill began August with 50 units of iron inventory that cost 535 each. During August, the company completed the following inventory transactions:
| Units | Unit Cost | unit Sales Price | ||
| Aug.3 | Sale | 45 | $85 | |
| 8 | Purchase | 90 | $54 | |
| 21 | Sale | 85 | 88 | |
| 30 | purchase | 15 | 58 |
Requirements
1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method.
2. Prepare a perpetual inventory record for the merchandise inventory using the LIFO inventory costing method.
3. Prepare a perpetual inventory record for the merchandise inventory using the weighted-average inventory costing method.
4. Determine the company’s cost of goods sold for August using FIFO, LIFO, and weighted-average inventory costing methods.
5. Compute gross profit for August using FIFO, LIFO, and weighted-average inventory costing method 6. If the business wanted to maximize gross profit, which method would it select?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
ROGER
UWorld CPA Review
YOUR WORLD OF LEARNING
West Company recorded the following inventory information during the month of February:
Balance on 2/1
Purchased on 2/8
Sold on 2/14
Purchased on 2/17
Sold on 2/23
Purchased on 2/28
Units.
800
1,000
1,500
2,000
1,600
800
Unit Cost
$ 2
$ 3
$ 1
$ 4
Total Cost
$ 1,600
$ 3,000
$ 2,000
$ 3,200
Units on Hand
800
1,800
300
2,300
700
1,500
West uses the LIFO method to cost inventory. What amount should West report as inventory at the end of February using the periodic inventory method?
PROBLEM 2: FOR CLASSROOM DISCUSSION
Gross profit rate
1. The following data relate to the records of Poweli Corp. for the
month of September:
Sales .
P160,000
Beginning inventory
Purchases ..
P 20,000
180,000
P200,000
Goods available for sale
Requirements: Using these data, estimate the cost of ending
inventory for each situation below:
a)
b)
Markup is 50 percent on cost.
Markup is 60 percent on sales.
Markup is 25 percent on cost.
Markup is 40 percent on sales.
c)
d)
Using Excel to Cost Inventory
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this template.Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory.
In its first month of operations, McLanie Company made three purchases. Information concerning these purchases and units on hand are:
Units
Cost per Unit
Compute the cost of the ending inventory under the average-cost method in a periodic inventory system.
300
$ 6.00
400
8.00
500
9.00
Weighted-average unit cost
Units on hand at period end
200
Round unit cost to 3 decimals using the ROUND function
Purchases of merchandise were made in the sequence listed above.
Cost of ending…
Chapter 6 Solutions
Horngren's Accounting (12th Edition)
Ch. 6 - Which principle or concept states that business...Ch. 6 - Which inventory costing method assigns to ending...Ch. 6 - Assume Nile.com began April with 14 units of...Ch. 6 - Suppose Nile.com used the weighted-average...Ch. 6 - Which inventory costing method results in the...Ch. 6 - Which of the following is most closely linked to...Ch. 6 - At December 31, 2018, Stevenson Company overstated...Ch. 6 - Suppose Maestro’s had cost of goods sold during...Ch. 6 - Suppose used the LIFO inventory costing method and...Ch. 6 - Prob. 1RQ
Ch. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - Discuss some measures that should be taken to...Ch. 6 - Under a perpetual inventory system, what are the...Ch. 6 - When using a perpetual inventory system and the...Ch. 6 - During periods of rising costs, which inventory...Ch. 6 - What does the lower-of-cost-or market (LCM) rule...Ch. 6 - What account is debited when recording the...Ch. 6 - What is the effect on cost of goods sold, gross...Ch. 6 - When does an inventory error cancel out, and why?Ch. 6 - How is inventory turnover calculated, and what it...Ch. 6 - How is days’ sales inventory calculated, and what...Ch. 6 - When using the periodic inventory system, which...Ch. 6 - When using periodic inventory system and...Ch. 6 - Determining inventory accounting principles...Ch. 6 - Determining inventory costing methods Learning...Ch. 6 - Preparing a perpetual Inventory record and journal...Ch. 6 - Preparing a perpetual inventor, record and journal...Ch. 6 - Preparing a perpetual inventor record and journal...Ch. 6 - Preparing a perpetual inventory record and journal...Ch. 6 - Comparing Cost of Goods Sold under FIFO, LIFO, and...Ch. 6 - Applying the lower-of-cost-or-market rule Learning...Ch. 6 - Determining the effect of an inventory error...Ch. 6 - Computing the rate of inventory turnover and days’...Ch. 6 - Computing periodic inventory amounts—FIFO Learning...Ch. 6 - Computing periodic inventory amounts—LIFO Learning...Ch. 6 - Computing periodic inventory...Ch. 6 - Using accounting vocabulary Learning Objective 1,...Ch. 6 - Comparing inventory methods Learning Objective 2...Ch. 6 - Measuring and journalizing merchandise inventory...Ch. 6 - Measuring and journalizing merchandise inventory...Ch. 6 - Measuring ending inventory and cost of goods sold...Ch. 6 - Comparing amounts for cost of goods sold, ending...Ch. 6 - Comparing cost of goods sold and gross...Ch. 6 - Applying the lower-of-cost-or-market rule to...Ch. 6 - Applying the lower-of-cost-or-market rule to...Ch. 6 - Measuring the effect of an inventory error...Ch. 6 - Correcting an inventory error-two years Learning...Ch. 6 - Computing inventory turnover and days’ sales in...Ch. 6 - Comparing ending merchandise inventory, cost of...Ch. 6 - Computing periodic inventory amounts Learning...Ch. 6 - Accounting for inventory using the perpetual...Ch. 6 - Accounting for inventory using the perpetual...Ch. 6 - Accounting principles for inventory and applying...Ch. 6 - Prob. P6.31APGACh. 6 - Prob. P6A.32APGACh. 6 - Prob. P6.33BPGBCh. 6 - Prob. P6.34BPGBCh. 6 - Accounting principles for inventory and applying...Ch. 6 - Prob. P6.36BPGBCh. 6 - Prob. P6A.37BPGBCh. 6 - Prob. P6.38CTCh. 6 - Prob. P6.39CPCh. 6 - Prob. P6.40PSCh. 6 - Prob. 1CPCh. 6 - Prob. 2CPCh. 6 - Prob. 3CPCh. 6 - Prob. 4CPCh. 6 - Prob. 5CPCh. 6 - Prob. 6CPCh. 6 - Prob. 7CPCh. 6 - Prob. 8CPCh. 6 - Prob. 9CPCh. 6 - Prob. 10CPCh. 6 - Prob. 11CPCh. 6 - Prob. 6.1TIATCCh. 6 - Prob. 6.1DCCh. 6 - Prob. 6.1FSC
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
- CengageNOWv2 | Online teaching and learning resource from Cengage Learning Close Window eBook Show Me How 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 30,000 units at $30.00 Mar. 18 Sale 24,000 units May 2 Purchase 54,000 units at $31.00 Aug. 9 Sale 45,000 units Oct. 20 Purchase 21,000 units at $32.10 The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of merchandise 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.arrow_forwardll. Subject Accountingarrow_forwardQuestion 21: A company that uses the perpetual inventory system sold goods to a customer cash on September 10 for $20. The company has the following inventory information: January 1 Beginning Inventory, 15 units at $9 each -June 10 Purchase, 17 units at $10 each September 10 Sale, 8 units The company uses the LIFO method of inventory costing. Calculate the cost of goods sold for the sale on September 10. a) $48 b) $160 c) $88 d) $170 e) $80arrow_forward
- Assignment 4: Inventory Valuation 1. Purchase Date Quantities Unit Price Total February 1 February 13 February 22 February 28 175 25 50 90 May 1 May 13 May 12 May 30 The company sold 220 coffee mugs by February 28. Calculate the COGS and the Ending Inventory using FIFO, LIFO and Weighted Average. Assume the inventory was 50 at the beginning of the month @ $2.25 each. Show all your Work. $2.25 $393.75 $3.25 $81.25 $3.50 $175.00 $4.00 $360.00 2. Purchase Date Quantities Unit Price Total 75 125 150 210 $5 $375 $6 $750 $7 $1,050 $8 $1,680 The company sold 110 towels by May 31. Calculate the COGS and the Ending Inventory using FIFO, LIFO and Weighted Average. Assume the inventory was 25 at the beginning of the month @ $5.00 each. Show all your work.arrow_forwardproblem session purchases and sales of a particular product during the year are shown below: may. 1 Beginning Inventory 1,500 units @ $ 10 may. 18 Purchase 1,250 units @ $ 12 may 20 Sold 1,500 units @ $ 20 may. 25 Purchase 1,750 units @ $ 14 may. 27 Sold 1,750 units @ $ 25 may. 29 Purchase 500 units @ $ 15 Assuming that company uses perpetual inventory system, determine the cost of goods sold and compute the ending inventory as of may. 31 and make the journal entry for may. 27 transaction by using inventory subsidiary ledger for LIFO cost flow assumption.arrow_forwardReview Score Review Results by Study Objective Keaton Accessories uses a perpetual inventory system. The company's beginning inventory of a particular product and its purchases during the month of January were as follows: Quantity Unit Cost Total Cost Beginning Inventory (Jan. 1) 180 $40 $7,200 Purchase (Jan. 9) 90 45 4,050 Purchase (Jan. 21) 90 46 4,140 Total 360 $15,390 On January 24, Keaton sold 200 units of this product. The other 160 units remain in inventory at January 31. i.) Determine the cost of goods sold using each of the following flow assumptions: LIFO FIFO Average Cost ii.) Determine the cost of the 160 units in inventory at January 31 using each of the following flow assumptions: LIFO FIFO Average Cost ***** *** x**** ****arrow_forward
- Sd Subject: acountingarrow_forwardConcept Videos i es Required information UNIT 30s $45 May 1 April 5 April 10 April 15 April 201 April 22 # Knowledge Check 01 Assume that we use a perpetual inventory system and that five identical units are purchased at the following four dates and costs: 3 $ 10 $ 12 0:00-0:54 $14 $16 - $17 Cost of the ending inventory $ One unit is sold on April 25. The company uses the weighted average inventory costing method. Identify the cost of the ending inventory on the balance sheet. Note: Round your answer to 2 decimal places. 4 % 5 H 6 Inarrow_forwardPeriod Inventory using FIFO & LIFO There are 15 units of the item in the physical inventory at December 31. Determine the inventory cost uniting the First-in, first-out (FIFO) and the last-in first-out(LIFO) method. (Round per unit cost two decimal places and your final answer to the nearest whole dollar.) Trying to create my spreadsheet to have it all setup. Thank you. Jan 1 Inventory 16 units $49 $784 Jul 7 Purchase 15 units $52 $780 Nov 23 Purchase 19 units $54 $1026 50 total units $2590 (Total) A. FIFO___________ B. LIFO __________arrow_forward
- A company's inventory records report the following: August 1 Beginning balance 24 units @ $14 August 5 Purchase 19 units e $13 August 12 Purchase 23 units @ $14 On August 15, it sold 48 units. Using the FIFO perpetual inventory method, what is the value of the inventory at August 15 after the sale? Multiple Choice $272 $252 $1,188 $774 MacBoarrow_forwardPlease help me with show all Calculation thankuarrow_forwardA Moving to another question will Question 1 National supplies company had the following activity during the current monthly period. June 1 Beginning inventory 70 units at $10 June 5 Purchased 50 units at $40 June 16 Sold 120 units at $65 Using the Weighted average inventory costing method, what is the cost of goods sold for June? O $2,610 O $2,836 O $2,300 O $2,700 Warrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Chapter 6 Merchandise Inventory; Author: Vicki Stewart;https://www.youtube.com/watch?v=DnrcQLD2yKU;License: Standard YouTube License, CC-BY
Accounting for Merchandising Operations Recording Purchases of Merchandise; Author: Socrat Ghadban;https://www.youtube.com/watch?v=iQp5UoYpG20;License: Standard Youtube License