Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
26th Edition
ISBN: 9781305714731
Author: Warren/Reeve/Duchac
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 17.12EX
a) (1)
To determine
Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.
To compute: Inventory turnover ratio and number of days’ sales in inventory
Given info: Cost of goods sold and average inventory
(2)
To determine
To compute: Number of days sales in inventory.
Given info: Average inventory and average daily cost of goods sold.
b)
To determine
To conclude: Position of inventory.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
answer in text form please (without image)
QT, Inc. and Elppa Computers, Inc. compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions):
QT
Elppa
Sales
$35,040
$46,400
Cost of goods sold
29,200
43,800
Inventory, beginning of period
932
4,028
Inventory, end of period
1,132
4,828
a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year.
(refer to image)
b. QT has a ______ (higher/lower) inventory turnover ratio than does Elppa Company. Likewise, QT has a _____ (larger/smaller) number…
Inventory management is an important aspect of retail strat-
egy. For example, it is important to know when it is time to
reorder and how much to order at a time, a metric called re-
order point.
As consumers buy a product day after day, the inven-
tory level declines. The question for retailers is how low they
should allow the inventory level to dedine before they place
an order; that is, when is the optimal time to reorder? If you
order too late, you take a chance of losing sales because you
are out of stock. If you order too soon, consumer tastes may
change, and you will be stuck with excess and unsellable mer-
chandise. And generally, retailers do not want more inventory
on hand than is necessary to avoid stock-outs because inven-
tory ties up cash.
Hence, the decision of when to order and how much to
order is critical to a retailer's bottom line. The simplest formula
to determine the reorder point is the following:
Reorder point x Usage rate + Lead time
Usage rate is basically how…
Chapter 17 Solutions
Custom Bundle: Accounting, Loose-leaf Version, 26th + Working Papers, Chapters 1-17, 26th Edition
Ch. 17 - Prob. 1DQCh. 17 - Prob. 2DQCh. 17 - Prob. 3DQCh. 17 - How would the current and quick ratios of a...Ch. 17 - a. Why is it advantageous to have a high inventory...Ch. 17 - What do the following data, taken from a...Ch. 17 - a. How does the rate earned on total assets differ...Ch. 17 - Kroger, a grocery store, recently had a...Ch. 17 - Prob. 9DQCh. 17 - Prob. 10DQ
Ch. 17 - Horizontal analysis The comparative temporary...Ch. 17 - Prob. 17.1BPECh. 17 - Vertical analysis Income statement information for...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 17.3APECh. 17 - Prob. 17.3BPECh. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 17.6APECh. 17 - Prob. 17.6BPECh. 17 - Times interest earned A company reports the...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Prob. 17.11APECh. 17 - Prob. 17.11BPECh. 17 - Prob. 17.1EXCh. 17 - Vertical analysis of income statement The...Ch. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Vertical analysis of balance sheet Balance sheet...Ch. 17 - Prob. 17.5EXCh. 17 - Prob. 17.6EXCh. 17 - Prob. 17.7EXCh. 17 - Prob. 17.8EXCh. 17 - Accounts receivable analysis The following data...Ch. 17 - Accounts receivable analysis Xavier Scores Company...Ch. 17 - Inventory analysis The following data were...Ch. 17 - Prob. 17.12EXCh. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 17.16EXCh. 17 - Profitability ratios The following selected data...Ch. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Prob. 17.21EXCh. 17 - Prob. 17.22EXCh. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 17.24EXCh. 17 - Prob. 17.25EXCh. 17 - Prob. 17.26EXCh. 17 - Horizontal analysis of income statement For 2016,...Ch. 17 - Prob. 17.2APRCh. 17 - Prob. 17.3APRCh. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Prob. 17.5APRCh. 17 - Prob. 17.1BPRCh. 17 - Prob. 17.2BPRCh. 17 - Effect of transactions on current position...Ch. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Solvency and profitability trend analysis Crosby...Ch. 17 - Nike, Inc., Problem Financial Statement Analysis...Ch. 17 - Prob. 17.1CPCh. 17 - Prob. 17.2CPCh. 17 - Vertical analysis The condensed income statements...Ch. 17 - Prob. 17.4CPCh. 17 - Comprehensive profitability and solvency analysis...
Knowledge Booster
Similar questions
- Computerized Business Systems (CBS) transforms manual accounting and inventory systems into computerized, more efficient, systems. Many of their customers describe the transition as an overnight evolution from the dark ages to the 21st century. Manual systems are far too cumbersome with respects to both time and inventory control. CBS's computerized inventory systems, for example, allow every item in inventory, no matter how small, to be tracked at all points throughout the production process. Replenishing stock becomes an automatic process because the CBS system alerts the manager when supplies reach a pre-programmed level. Vicky Pagel has been a financial analyst with CBS for over five years. Although she normally does not get involved with sales, her most recent assignment was to assist Jack Ingram, a new sales representative. Jack is in the process of trying to sell a CBS system to Corbin Mills, a firm that does not know how to determine accurately its weighted average cost of…arrow_forwardQT, Inc. and Elppa Computers, Inc. compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT ElppaSales $56,940 $120,357Cost of goods sold 44,754 92,385Inventory, beginning of period 1,382 6,317Inventory, end of period 1,404 7,490a. Determine for both companies (1) the inventory turnover and (2) the…arrow_forwardWalMart and other retailers have computerized cash registers to ring up sales. How does this feature help these firms manage inventory? Purchase prices change over time. When ordering inventory to replace what has been sold, the purchasing agent might find a price increase. Discuss and explain one of the following: First in First Out Last in First Out Weighted Average Cost Specific Identification Lower of Cost or Marketarrow_forward
- Inventory Costing When Inventory Quantities Are Small A number of companies have adopted a just-in-time procedure for acquiring inventory. These companies have arrangements with their suppliers that require the supplier to deliver inventory just as the company needs the goods. As a result, just-in-time companies keep very little inventory on hand. Required: Once a company has switched to the just-in-time procedure and has little inventory, should the inventory costing method (LIFO or FIFO) affect cost of goods sold?arrow_forwardAmazon.com, Inc. (AMZN) is one of the largest Internet retailers in the world. Target Corporation (TGT) is one of the largest value-priced general merchandisers operating in the L'nited States. Target sells through nearly 1,800 brick-and-mortar stores and through the Internet. Amazon and Target compete for customers across a wide variety of products, including media, general merchandise, apparel, and consumer electronics. Cost of goods sold and inventory information from a recent annual report are provided for both companies as follows (in millions): a. Compute the inventory turnover far both companies. Round all calculations to one decimal place.b. Compute the number of days' sales in inventory for both companies. Use 365 days and round all calculations to one decimal place.c. - Which company has the better inventory efficiency?d. What might explain the difference in inventory efficiency between the two companies?arrow_forwardSilver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forward
- Silver Limited is a manufacturing company that produces furniture. To improve efficiency and usefulness, Silver Limited is constantly incorporating advanced, information technology into its business information systems. When Silver Limited does not have available production capacity, sometimes it purchases furniture from outside suppliers to fulfill customer orders. First, Inventory Control prepares a purchase requisition when inventory approaches the reorder point and sends it to Purchasing and Accounts Payable. Then, Purchasing locates the authorized vendor in the vendor file, prepares a purchase order, and updates the purchase order file. Purchasing then sends the purchase order to Vendor, Receiving, and Accounts Payable. Accounts Payable prepares a summary of all purchase orders issued that day and forwards the total to General Ledger for posting to the GL file. Goods arrive at Receiving with a packing slip. Receiving prepares a receiving report and forwards it with the goods to…arrow_forwardRequired information [The following information applies to the questions displayed below.] BookWeb, Incorporated, sells books and software over the Internet. A recent article in a trade journal has caught the attention of management because the company has experienced soaring inventory handling costs. The article notes that similar firms have purchasing, warehousing, and distribution costs that average 13 percent of sales. Thirteen percent is attractive to BookWeb management when compared to its results for the past year, shown in the following table: Activity (cost) Cost Driver Cost Driver % of Cost Driver % of Cost Driver Quantity Incoming receipts ($300,000) Warehousing ($360,000) Shipments ($225,000) Number of purchase orders Number of inventory moves Number of shipments 2,000 9,000 for Books 70% 80% for Software 30% 20% 15,000 25% 75% Book sales revenue totaled $3,900,000 and software sales revenue totaled $2,600,000. A review of the company's activities found various…arrow_forwardABC Corporation is a mid-sized manufacturing company that has recently decided to switch from a traditional inventory system to a Just-in-Time (JIT) inventory system. The company is concerned about the potential risks and benefits of this switch. They have traditionally kept large amounts of raw materials on hand to ensure smooth production. However, the management believes that JIT can help reduce carrying costs and improve efficiency. What are the key risks ABC Corporation should consider with the JIT system? How can the company mitigate these risks while maximizing the benefits of JIT? On December 31, 2023, Archer Daniels Midland Company (ADM) purchased new manufacturing equipment for $850,000, which had an estimated useful life of 10 years and a salvage value of $50,000. The company uses the straight-line depreciation method for all its equipment. During a review in June 2024, ADM's management discovered that the equipment's useful life should actually be 8 years, with a salvage…arrow_forward
- ST is adistribution company which buys a product in bulk from manufacturers, repackages the product into smaller packs and then sells the packs to retail customers. ST’s customers vary in size and consequently the size and frequency of their orders also varies. Some customers order large quantities from ST each time they place an order. Other customers order only a few packs each time. The current accounting system of ST produces very basic management information that reports only the overall company profit. ST is therefore unaware of the costs of servicing individual customers. However, the company has now decided to investigate the use of Direct Customer Profitability Analysis (DCPA). ST would like to see the results from a small sample of customers before it decides whether to fully introduce DCPA. The information for two customers, and for the whole company, for the previous period was as follows:…arrow_forwardA company like Golf USA that sells golf-related inventory typically will have inventory items such as golf clothing and golf equipment. As technology advances the design and performance of the next generation of drivers, the older models become less marketable and therefore decline in value. Suppose that in the current year, Ping (a manufacturer of golf clubs) introduces the MegaDriver II, the new and improved version of the MegaDriver. Below are yearend amounts related to Golf USA’s inventory.Inventory Quantity Unit Cost Unit NRV Shirts 35 $ 60 $ 70 MegaDriver 15 360 250 MegaDriver II 30 350 420Required: 1. Calculate the total recorded cost of ending inventory before any adjustments. 2. Calculate ending inventory using the lower of cost and net realizable…arrow_forwardConcept Integration. Your appliance manufacturingcompany recently implemented a just-in-time inventory system (see Chapter 9) for all parts used in themanufacturing process. How might you expect thismove to affect the company’s inventory turnover rate,current ratio, and quick ratio?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College