Myaccountinglab With Pearson Etext -- Access Card -- For Horngren's Accounting, The Managerial Chapters
12th Edition
ISBN: 9780134490663
Author: MILLER-NOBLES, Tracie L., Mattison, Brenda L., Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 6, Problem 4QC
Suppose Nile.com used the weighted-average inventory costing method and the perpetual inventory system. Use the nile.com data in Question 3 to compute the weighted-average unit cost of the company’s inventory on hand at April 8. Round weighted-average unit cost to the nearest cent.
Learning Objective 2
- $21.00
- $19.75
- $19.50
- Cannot be determined from the data given
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Cost of goods sold at:FIFO Cost ...............LIFO Cost...............Sales revenue ...............$ 87,63097,980138,000Company managers need to know the company’s gross profit percentage and rate of inventoryturnover for 2018 under1. FIFO.2. LIFO.Which method produces a higher gross profit percentage? A higher inventory turnover?
(Learning Objective 2: Apply various inventory costing methods) A Gold MedalSports outlet store began August 2018 with 42 pairs of running shoes that cost the store $31each. The sales price of these shoes was $63. During August, the store completed these inventory transactions:Units Unit CostSale ............. 16 $319 Purchase...... 81 33$6313 Sale ............. 26 31 63Sale ............. 33 6422 Sale ............. 36 33 6429 Purchase...... 18 35Aug 218 13Unit Sales PriceRequirements1. The preceding data are taken from the store’s perpetual inventory records. Which costmethod does the store use? Explain how you arrived at your answer.2. Determine the store’s cost of goods sold for August. Also compute gross profit for August.3. What is the cost of the store’s August 31 inventory of running shoes?
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
Myaccountinglab With Pearson Etext -- Access Card -- For Horngren's Accounting, The Managerial Chapters
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
- (Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Spear Corporation’s inventory records for its retail division show thefollowing at May 31:May 1 Beginning inventory ............... 10 units @ $160 = $1,60015 Purchase................................. 5 units @ 161 = 80526 Purchase................................. 14 units @ 170 = 2,380At May 31, 11 of these units are on hand. Journalize the following for Spear Corporation underthe perpetual system:1. Total May purchases in one summary entry. All purchases were on credit.2. Total May sales and cost of goods sold in two summary entries. The selling price was $560per unit, and all sales were on credit. Assume that Spear uses the FIFO inventory method.3. Under FIFO, how much gross profit would Spear earn for the month ending May 31? Whatis the FIFO cost of Spear Corporation’s ending inventory?arrow_forward(Learning Objective 2: Compare inventory by three methods) SWAT Surplus beganMarch 2018 with 100 tents that cost $10 each. During the month, the company made the following purchases at cost:1826Mar 6 110 tents @ $20120 tents @ $2540 tents @ $30= $2,200= 3,000= 1,200The company sold 318 tents, and at March 31, the ending inventory consisted of 52 tents. Thesales price of each tent was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for March under theaverage-cost, FIFO, and LIFO costing methods. Round the average cost per unit to twodecimal places, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the SWAT Surplus income statement for March. Report gross profit. Operatingexpenses totaled $3,250. The company uses average costing for inventory. The income taxrate is 36%.arrow_forward(Learning Objective 2: Calculate purchases by analyzing inventory account activity)On Willow Grove Department Stores’ most recent balance sheet, the balance of its inventory at the beginning of the year was $12,000. At the end of the year, the inventory balancewas $14,500. During that year, its cost of goods sold was $55,000. All purchases of inventorythroughout the year were on account. What was the total of Willow Grove’s purchases duringthe year?arrow_forward
- (Learning Objective 2: Compare inventory by three methods) Navy Surplus beganJuly 2018 with 80 stoves that cost $10 each. During the month, the company made the following purchases at cost:1826July 6 90 stoves @ $20100 stoves @ $2530 stoves @ $30= $1,800= 2,500= 900The company sold 250 stoves, and at July 31, the ending inventory consisted of 50 stoves. Thesales price of each stove was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for July under the averagecost, FIFO, and LIFO costing methods. Round the average cost per unit to two decimalplaces, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the Navy Surplus income statement for July. Report gross profit. Operating expensestotaled $3,250. The company uses average costing for inventory. The income tax rate is 40%.arrow_forward(Learning Objectives 4, 5: Compute gross profit; estimate inventory using the grossprofit method) Cleveland Company, a camera store, lost some inventory in a fire on October15. To file an insurance claim, the company must estimate its October 15 inventory using thegross profit method. For the past two years, Cleveland Company’s gross profit has averaged41% of net sales. Its inventory records reveal the following data:Inventory, October 1................ $ 57,700Transactions October 1–15:Purchases ................................. 490,800Purchase discounts................... 17,000Purchase returns....................... 70,900Sales......................................... 660,000Requirements1. Estimate the cost of the lost inventory using the gross profit method.2. Prepare the income statement for October 1 to October 15 for this product through grossprofit. Show the detailed computations of cost of goods sold in a separate schedule.arrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Griffin Company’s inventory records for its retail division show thefollowing at December 31:Dec 1 Beginning inventory ............... 9 units @ $165 = $1,48515 Purchase................................. 5 units @ 166 = $ 83026 Purchase................................. 13 units @ 175 = $2,275At December 31, 11 of these units are on hand. Journalize the following for Griffin Companyunder the perpetual system:1. Total December purchases in one summary entry. All purchases were on credit.2. Total December sales and cost of goods sold in two summary entries. The selling price was$500 per unit, and all sales were on credit. Assume that Griffin uses the FIFO inventorymethod.3. Under FIFO, how much gross profit would Griffin earn for the month ending December 31?What is the FIFO cost of Griffin Company’s ending inventory?arrow_forward
- Learning Objectives 1, 2: Show how to account for inventory in a perpetual systemusing the average-costing method) Western Trading Company purchases inventory in cratesof merchandise; each crate of inventory is a unit. The fiscal year of Western Trading ends eachJanuary 31. Assume you are dealing with a single Western Trading store in Nashville, Tennessee. The Nashville store began the year with an inventory of 20,000 units that cost a total of$1,060,000. During the year, the store purchased merchandise on account as follows:July (29,000 units at $59) ..................................... $1,711,000November (49,000 units at $63) ........................... 3,087,000December (59,000 units at $69)............................ 4,071,000Total purchases..................................................... $8,869,000Cash payments on account totaled $8,541,000. During fiscal year 2018, the store sold 155,000units of merchandise for $15,887,500, of which $4,900,000 was for cash and the balance…arrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Allegheny Corporation yield the followingdata for the year ended June 30, 2018:Inventory, June 30, 2017.......................................................................... $ 13,000Purchases of inventory (on account)......................................................... 53,000Sales of inventory—82% on account; 18% for cash (cost $46,000).........Inventory at FIFO, June 30, 2018 ............................................................73,00020,000Requirements1. Journalize Allegheny’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statementarrow_forward(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Jubilee Corporation yield the following datafor the year ended June 30, 2018 (assume sales returns are non-existent):Inventory, June 30, 2017.......................................................................... $ 7,000Purchases of inventory (on account)......................................................... 61,000Sales of inventory—77% on account; 23% for cash (cost $49,000).........Inventory at FIFO, June 30, 2018 ............................................................100,00019,000Requirements1. Journalize Jubilee’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statement.arrow_forward
- Learning Objective 2: Compare ending inventory and cost of goods sold—FIFOvs. LIFO) Paulson’s specializes in sound equipment. Company records indicate the followingdata for a line of speakers:Unit Cost$4964JunDate12713ItemBalance...................Purchase.................Sale ........................Sale ........................Quantity18376Sale Price$115103Requirements1. Determine the amounts that Paulson’s should report for cost of goods sold and endinginventory two ways:a. FIFOb. LIFO2. Paulson’s uses the FIFO method. Prepare the company’s income statement for the monthended June 30, 2018, reporting gross profit. Operating expenses totaled $340, and theincome tax rate was 35%.arrow_forward(Learning Objective 2: Compare gross profit—FIFO vs. LIFO—falling prices)Suppose a Target store in Chicago, Illinois, ended November 2018 with 500,000 units of merchandise that cost $8.00 each. Suppose the store then sold 110,000 units for $960,000 duringDecember. Further, assume the store made two large purchases during December as follows:Dec 8 35,000 units @ $6.10 = $213,50028 50,000 units @ $5.20 = $260,000Requirements1. Calculate the store’s gross profit under FIFO and LIFO at December 31.2. What caused the FIFO and LIFO gross profit figures to differ?arrow_forwardAn evaluation of Bryces Bookstores inventory was performed in Year 2. It produced the following results: Sample of ending inventory at current-year costs = 75,000 Sample of ending inventory at previous-year costs = 69,000 The cost index in Year 1 was 105. Using the link-chain method, compute Bryces cost index for Year 2.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
INVENTORY & COST OF GOODS SOLD; Author: Accounting Stuff;https://www.youtube.com/watch?v=OB6RDzqvNbk;License: Standard Youtube License