1.
Concept introduction:
Inventory Turnover Ratio: Inventory Turnover Ratio is calculated by dividing the Cost of goods sold by Average inventory. The formula of the Inventory Turnover Ratio is as follows:
Note: Average inventory is calculated with the help of following formula:
Day’s sales in inventory: Days sales in inventory represent the number of days the inventory waits for the sale. It is calculated by using the following formula:
To calculate: The inventory turnover and days sales in inventory ratio for the company for two years.
1.
Answer to Problem 9BTN
The inventory turnover and days sales in inventory ratios for the company for two years are as follows:
Current year | One year prior | |
Inventory Turnover Ratio | 7.04 | 7.47 |
Days Sales in inventory | 52 | 49 |
Explanation of Solution
The inventory turnover and days sales in inventory ratios for the company for two years are calculated as follows:
Korean won in millions | Current year | One year prior |
Cost of Goods Sold (A) | 128,278,800 | 137,696,309 |
Beginning Inventory (B) | 19,134,868 | 17,747,413 |
Ending Inventory (C) | 17,317,504 | 19,134,868 |
Average Inventory (D) = (B+C)/2 = | 18,226,186 | 18,441,141 |
Inventory Turnover Ratio (E) = A/D = | 7.04 | 7.47 |
Days Sales in inventory = 365 / E = | 52 | 49 |
2.
Concept introduction:
Inventory Turnover Ratio: Inventory Turnover Ratio is calculated by dividing the Cost of goods sold by average inventory. The formula of the Inventory Turnover Ratio is as follows:
Note: Average inventory is calculated with the help of following formula:
Day’s sales in inventory: Days sales in inventory represent the number of days the inventory waits for the sale. It is calculated using the following formula:
To indicate: The comment on the findings.
2.
Answer to Problem 9BTN
The efficiency of inventory management has decreased.
Explanation of Solution
The inventory turnover and days sales in inventory ratios for the company for two years are calculated as follows:
Korean won in millions | Current year | One year prior |
Cost of Goods Sold (A) | 128,278,800 | 137,696,309 |
Beginning Inventory (B) | 19,134,868 | 17,747,413 |
Ending Inventory (C) | 17,317,504 | 19,134,868 |
Average Inventory (D) = (B+C)/2 = | 18,226,186 | 18,441,141 |
Inventory Turnover Ratio (E) = A/D = | 7.04 | 7.47 |
Days Sales in inventory = 365 / E = | 52 | 49 |
The inventory turnover has decreased and day’s sales in inventory ratio have increased in the current year and compared with the previous year. It indicates that the efficiency of inventory management has decreased.
Want to see more full solutions like this?
Chapter 5 Solutions
Financial Accounting: Information for Decisions
- Last 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_forwardA large manufacturer of truck and car tires recently changed its cost-flow assumption method for inventories at the beginning of 2014. The manufacturer has been in operation for almost 40 years, and for the last decade it has reported moderate growth in revenues. The firm changed from the LIFO method to the FIFO method and reported the following information (amounts in millions): REQUIRED Calculate the inventory turnover ratio for 2014 using the LIFO and FIFO cost-flow assumption methods. Explain why the costs assigned to inventory under LIFO at the end of 2013 and 2014 are so much less than they are under FIFO.arrow_forwardThe 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 companys merchandising concept.arrow_forward
- Inventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?arrow_forwardNorwood Company makes miniature circuit boards that are components of wireless phones and personal organizers. The company has experienced strong growth, and you are especially interested in how well Norwood is managing its inventory balances. You have collected the following information for the current year. Inventory at the beginning of year: $ 1,026,000Inventory at the end of year, before any adjustments: 1,007,000Total cost of goods sold, before any adjustments: 11,776,000 The company values inventory at lower-of-cost (using LIFO cost fl ow assumption)-or-market; use the cost-of-goods-sold method.Instructions(a) Compute Norwood’s inventory turnover before any adjustment.(b) Recompute the inventory turnover after adjusting Norwood’s inventory information for the following items.1. During the year, Norwood recorded sales and costs of goods sold on $22,000 of units shipped to various wholesalers on consignment. At year-end, none of these units have been sold by wholesalers.2.…arrow_forwardThe following data (in millions) were taken from recent annual reports of Tomato Computer, Inc., a manufacturer of personal computers and related products, and Happy Times Corporation, a manufacturer and distributor of greeting cards and related products: Tomato Happy Times Cost of merchandise sold $4,890,100 $941,700 Inventory, end of year 98,000 98,000 Inventory, beginning of the year 60,000 121,000 a. Determine the inventory turnover for Tomato and Happy Times. Round to one decimal place. Tomato Happy Times b. Would you expect Happy Times inventory turnover to be higher or lower than Tomato’s?arrow_forward
- Calculating Gross Profit and Inventory TurnoverThe following table presents, sales, revenue, cost of goods sold, and inventory for 3 companies: Samsung, HP & Apple.a. Compute the gross profit margin (GPM) for each of these companies for all 3 yearsb. Compute the inventory turnover ratio and the average inventory days outstanding for each company for the last two fiscal year using FIFO inventory costingc. What factors might determine the differences among these 3 companies’ ratios? ($millions) Fiscal year endingSamsung (Korean won) 12/31/2014 12//2013 12/31/2012Revenue 206,205,987 228,692,667 201,103,613COGS 128,278,800 137,696,309 126,651,931Inventory 17,317,504 19,134,868 17,747,413 HP (US Dollar) 10/31/2014 10/31/2013 10/31/2012Revenue (products only) 73,726…arrow_forwardPolaris Industries Inc. is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions):2012 2011 2010 2009Net Sales Revenue $3,200 $2,660 $1,990 $1,570Cost of Goods Sold 2,280 1,900 1,460 1,170Average Inventory 320 270 210 200Required:1. Calculate to one decimal place the inventory turnover ratio and average days to sell inventoryfor 2012, 2011, and 2010.2. Comment on any trends, and compare the effectiveness of inventory managers at Polaris toinventory managers at its main competitor, Arctic Cat, where inventory turned over 5.4 timesin 2012 (67.6 days to sell). Both companies use the same inventory costing method (FIFO)arrow_forwardHubble Space Incorporated has the following data which includes inventory conversion period or ICP of the firms against which it benchmarks. The firm's new manager is looking into the company on how he could reduce its inventory enough to reduce its ICP to the benchmarks’ average. If this were done, by how much would inventories decrease? Assume a 365-day year. Cost of goods sold =P85,000; Inventory =P20,000; Inventory conversion period (ICP) =85.88; Benchmark inventory conversion period (ICP) =38.00 *arrow_forward
- Hubble Space Incorporated has the following data which includes inventory conversion period or ICP of the firms against which it benchmarks. The firm's new manager is looking into the company on how he could reduce its inventory enough to reduce its ICP to the benchmarks’ average. If this were done, by how much would inventories decrease? Assume a 365-day year. Cost of goods sold =P85,000; Inventory =P20,000; Inventory conversion period (ICP) =85.88; Benchmark inventory conversion period (ICP) =38.00 * A. P 8,129 B. P 7,316 C. P 9,032 D. P11,151 E. P10,036arrow_forwardThe inventory turnover ratio across companies in the furniture industry is 3.289x. Based on this information, which of the following statements is true for Adams Furniture? Adams Furniture is holding more inventory per dollar of sales compared with the industry average. Adams Furniture is holding less inventory per dollar of sales compared with the industry average.arrow_forwardThe ITM trading company provides you the following data for the year 2016: Inventory turnover ratio: 12 times Opening inventory at cost: $36,000 Closing inventory at cost: $54,000 Calculate cost of goods sold for the year 2016arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning