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 S6.10SE
Computing the rate of inventory turnover and days’ sales in inventory
Learning Objective 6
Broadway Communications reported the following figures in its annual financial statements:
| Cost of Goods Sold | $ 18,400 |
| Beginning Merchandise Inventory | 560 |
| Ending Merchandise Inventory | 450 |
Compute the rate of inventory turnover and days sales in inentory for Broadway Communications. (Round to two decimal places.)
Use the following information to answer Short Exercises S6A-11 
through S6A-13.
The periodic inventory records of Flexon Prosthetics indicate the following for the month of July:
| Jul. 1 | Beginning merchandise inventory | 6 units @ $ 60 each |
| 8 | Purchase | 5 units @ $ 67 each |
| 15 | Purchase | 10 units@ $ 70 each |
| 26 | Purchase | 5 units @ $ 85 each |
At July 31, Flexon counts four units of merchandise inventory on hand.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For all problems, assume the perpetual inventory system is used unless stated otherwise.
P6-28A Accounting for inventory using the perpetual inventory system-
FIFO, LIFO, and weighted-average
Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost
a total of $4,290. During the month, Fit Gym purchased and sold merchandise on
Merchandise Inventory 363
Learning Objectives 2, 3
2. Ending Merch. Inv., $990
account as follows:
Jan. 5 Purchase
156 crates @ $ 64 each
13 Sale
180 crates @$ 100 each
18 Purchase
114 crates @ $ 75 each
26 Sale
150 crates @ $ 116 each
Requirements
1 Prepare a perpetual inventory record, using the FIFO inventory costing method,
and determine the company's cost of goods sold, ending merchandise inventory,
and gross profit.
2. Prepare a perpetual inventory record, using the LIFO inventory costing method,
and determine the company's cost of goods sold, ending merchandise inventory,
and gross profit.
3. Prepare a perpetual inventory record,…
Questions are on image
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
- The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Instructions 1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 3. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the dollar. 4. Compare the gross profit and June 30 inventories using the following column headings:arrow_forwardI IBM Learning = Copy of Jacqueline. Periodic 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 4 units at $4,200 $16,800 Aug. 7 Purchase 15 units at $4,300 64,500 Dec. 11 Purchase 13 units at $4,400 57,200 32 units $138,500 There are 18 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). a. First-in, first-out (FIFO) $ 78,700 V b. Last-in, first-out (LIFO) 77,000 V Weighted average cost C. Feedback Check My Work a. When the FIFO method is used, costs are included in cost of merchandise sold in the order in which they were purchased. b. When the LIFO method is used, the cost of the units…arrow_forwardP5-5B. Journalizing inventory purchases, sales, returns, and freight transactions using the perpetual inventory system; calculating gross profit (Learning Objectives 3, 4, 5, & 6) 25-30 min. The following transactions for Westcoast Tire Co. occurred during July: Jul Purchased $5,500 of merchandise on account from Meridian Tire Supply. Terms, 1/15, n/45, 4 FOB shipping point. Meridian Tire Supply prepaid the $475 shipping cost and added the amount to the invoice. 7 9 11 13 15 16 18 20 22 23 Purchased $300 of supplies on account from Office Express. Terms, 3/10, n/30, FOB destination. Sold $5,100 (cost, $2,800) of merchandise on account to P. Larson. Terms, 2/15, n/45, FOB destination. Paid $50 freight charges to deliver goods to P. Larson. Returned $500 of the merchandise purchased on July 4 and received a credit. Sold $900 (cost, $545) of merchandise to cash customers. Paid for the supplies purchased on July 7. Paid Meridian Tire Supply the amount due from the July 4 purchase in full.…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_forwardPlease answer attached questionarrow_forwardQuestion Content Area Based on the following data for the current year, what is the number of days' sales in inventory? Assume 365 days a year. Sales on account during year $463,358 Cost of merchandise sold during year 205,692 Accounts receivable, beginning of year 46,704 Accounts receivable, end of year 51,670 Merchandise inventory, beginning of year 33,192 Merchandise inventory, end of year 39,686 Round your intermediate calculations to the nearest dollar. When required, round your answer to the whole number. a.59 days b.65 days c.129 days d.70 daysarrow_forward
- Using data from 6-4A do part 1 assuming Gale Company uses a periodic inventory costing system. 1. A) FIFO B) Moving weighted averagearrow_forwardI need this question completed in 10 minutesarrow_forwardyears ended June 30, 2019 and 2018: Cost of Goods Available for Sale Nature Foods Grocery reported the following comparative income statements for the Beginning Merchandise Inventory Less: Ending Merchandise Inventory During 2019, Nature Foods Grocery discovered that ending 2018 merchandise inven- inventory error-two years an Merchandise Inventory 361 Learning Objective 5 1.2019, NI $36,500 NATURE FOODS GROCERY Income Statements Years Ended June 30, 2019 and 2018 2019 Net Sales Revenue Cost of Goods Sold: 2018 $ 134,000 $ 119,000 $ 17,000 78,000 $ 14,000 67,000 81,000 Net Cost of Purchases 95,000 18,000 17,000 Cost of Goods Sold 77,000 64,000 57,000 Gross Profit 55,000 Operating Expenses 26,000 21,000 $ 31,000 Net Income $ 34,000 tory was overstated by $5,500. Requirements 1. Prepare corrected income statements for the two years. 2. 2 State whether each year's net income-before your corrections-is understated or overstated, and indicate the amount of the understatement or…arrow_forward
- LIFO perpetual inventory The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 6-1B. Instructions 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. 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. 3. Determine the ending inventory cost on June 30.arrow_forwardFIFO perpetual inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. 2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. 3. Determine the gross profit from sales for the period. 4. Determine the ending inventory cost on June 30. 5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?arrow_forwardBeginning inventory, purchases, and sales for Item Widget are as follows: Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on March 25 and (b) the inventory on March 31.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
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