The general merchandise retail industry has a number of segments represented by the following companies:
For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports (in millions) for these three companies:
- a. Determine the inventory turnover ratio for all three companies. Round all calculations to one decimal place.
- b. Determine the number of days’ sales in inventory for all three companies. Use 365 days and round all calculations to one decimal place.
- c. Interpret these results based on each company’s merchandising concept.
(a)
Determine the inventory turnover for Company C, Company W and Company N.
Explanation of Solution
Inventory turnover ratio: Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period. The formula to calculate the inventory turnover ratio is as follows:
The inventory turnover ratio for Company C is calculated is calculated as follows:
The inventory turnover ratio for Company W is calculated is calculated as follows:
The inventory turnover ratio for Company N is calculated is calculated as follows:
Working note (1):
The average inventory of Company C is calculated as follows:
Working note (2):
The average inventory of Company W is calculated as follows:
Working note (3):
The average inventory of Company N is calculated as follows:
The inventory turnover of Company C is 11.5 Times, the inventory turnover of Company W is 8.1 Times & the inventory turnover of Company N is 5.0 Times.
b.
Compute the number of days’ sales in inventory for Company C, Company W and Company N.
Explanation of Solution
Compute the number of days’ sales in inventory for Company C:
Thus, the number of days’ sales in inventory for Company C is 31.7 days.
Compute the number of days’ sales in inventory for Company W:
Thus, the number of days’ sales in inventory for Company W is 45.3 days.
Compute the number of days’ sales in inventory for Company N:
Thus, the number of days’ sales in inventory for Company N is 73.3 days.
The Days’ sales in inventory of Company C is 31.7 days, the Days’ sales in inventory of Company W is 45.3 days, & the Days’ sales in inventory of Company N is 73.3 days.
(c)
Interpret the above calculated ratios.
Explanation of Solution
The inventory turnover ratio and number of days’ sales in inventory of all the three companies reflect the merchandising approaches of all companies. Company C is a club warehouse and it has approach of holding only items which are quickly sold. Most of the items are sold in bulk at very attractive prices.
In case of company W, it has a traditional discounter approach. Even though it has attractive pricing, the inventory movement is slower than in the case of company C.
In the case of company N, it is a high-end fashioner retailer. It offers a wide collection of specialty and unique goods that are specifically designed for fashion market rather than for general mass market. Therefore, the movement is slower than other two companies yet it has highest margin.
Want to see more full solutions like this?
Chapter 6 Solutions
FIN.+MAN.ACCTNG.-CUSTOM CNOW V.2-W/MIND
- The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardLast year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forwardMonster Beverage Corporation (MNST) develops, markets, and sells energy and other alternative beverage brands. Brown-Forman Corporation (BF.B) manufactures and sells a wide variety of spirit and wine beverages, such as Jack Daniels. The cost of goods sold and inventory were obtained from a recent annual report for both companies as follows (in millions): a. Determine the inventory turnover for both companies. Round all calculations to one decimal place. b. Determine the number of days sales in inventory for both companies. Use 365 days and round all calculations to one decimal place. c. Interpret the difference in inventory efficiency based on the companies respective product types.arrow_forward
- Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.arrow_forwardFinancial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?arrow_forwardFinancial statement data for years ending December 31 for Tango Company follow: a. Determine the inventory turnover for 20Y7 and 20Y6. b. Determine the days sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y6 to 20Y7 indicate a favorable or an unfavorable trend?arrow_forward
- Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?arrow_forwardAnalyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?arrow_forwardCost of goods sold and related items The following data were extracted from the accounting records of Harkins Company for the year ended April 30, 20Y8: Estimated returns of current year sales 11,600 Inventory, May 1, 20Y7 380,000 Inventory, April 30, 20Y8 415,000 Purchases 3,800,000 Purchases returns and allowances 150,000 Purchases discounts 80,000 Sales 5,850,000 Freight in 16,600 a. Prepare the Cost of goods sold section of the income statement for the year ended April 30, 20Y8, using the periodic inventory system. b. Determine the gross profit to be reported on the income statement for the year ended April 30, 20Y8. c. Would gross profit be different if the perpetual inventory system was used instead of the periodic inventory system?arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub