Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
26th Edition
ISBN: 9781305392373
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
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
The level of inventory a company maintains has important economic consequences, and it involves conflicting goals. The ability to control inventory levels is a critical skill in managing a business.
Three retailing giants, Best Buy Co., Inc. (NYSE: BBY), Amazon.com, Inc., (NASDAQ: AMZN), and Target Corporation (NYSE: TGT) each use a different inventory costing method. Best Buy uses weighted-average cost, Amazon uses FIFO, and Target uses LIFO.
Below is a hypothetical example that highlights the potential differences in income statements and balance sheets that could arise simply because of the use of a different inventory costing method.
Assume that all three retailers sell a popular shirt that retails for $32. To compare the impact of inventory costing method, we will also assume that all three retailers have the following inventory and sales data for the same period. To keep the calculations simple, a “unit” represents one million shirts.
Beginning inventory: 3 units @ $10.00…
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…
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…
Chapter 17 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
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
- 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 $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 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. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…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 Elppa Sales $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 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. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…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_forward
- WalMart 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_forwardInventory 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_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_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_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 andforwards the total to the 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_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 andforwards the total to the 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_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
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
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
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,