Concept explainers
(a)
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:
Days’ sales in inventory: Days’ sales in inventory are used to determine number of days a particular company takes to make sales of the inventory available with them. The formula to calculate the days’ sales in inventory ratio is as follows:
The inventory turnover and the number of days’ sales in inventory ratio for Company T and Company A.
(b)
To interpret: the above calculated ratios.
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Bundle: Financial & Managerial Accounting, 13th + Working Papers, Volume 1, Chapters 1-15 For Warren/reeve/duchac’s Corporate Financial Accounting, ... 13th + Cengagenow™v2, 2 Terms Access Code
- Calculate the Inventory Turnover and Day Sales in Inventory ratios for Hayden Co. assuming the FIFO method. Discuss what the ratios demonstrate to you. Assume the industry average for Inventory Turnover is 3.4.arrow_forwardUsing Inventory Analysis ToolsAutoZone and O'Reilly are two competitors in the retail automotive parts industry. AutoZone O'Reilly Average 2015 Inventory $3,330,863 $2,642,897 2015 Sales 10,587,339 8,366,673 2015 Cost of goods sold 4,860,309 3,804,031 Average 2014 Inventory $3,050,552 $2,514,913 2014 Sales 9,875,312 7,616,080 2014 Cost of goods sold 4,540,406 3,507,180 Use the information above to compute the companies' gross profit margin and days inventory outstanding for both years.Round answers to one decimal place (ex: 0.2345 = 23.5%). Gross Profit Margin AutoZone O'Reilly 2015 Answer Answer 2014 Answer Answer Round to answers to one decimal place. Days Inventory Outstanding AutoZone O'Reilly 2015 Answer Answer 2014 Answer Answerarrow_forwardsuject:accountingarrow_forward
- Suppose this information (in millions) is available for the Automotive and Other Operations Divisions of General Motors Corporation for a recent year, General Motors uses the LIFO inventory method. Beginning inventory Ending inventory LIFO reserve Current assets Current liabilities Cost of goods sold Sales revenue (a) Calculate the inventory turnover and days in inventory. (Round answers to 1 decimal place, e.g. 5.1) Inventory turnover $12,870 15,760 1,406 62.567 70,300 160,328 181,360 Days in inventory times daysarrow_forwardComputing and Evaluating Inventory and PPE Turnovers Intel Corporation reports the following financial statement amounts in its 10-K reports. Cost of $ millions Sales Goods Sold Inventories 2016 $95,019 $24,501 $5,553 25,096 6,983 29,162 7,253 2017 100,418 2018 113,357 a. Compute the inventory and PPE turnover ratios for both 2017 and 2018. Note: Do not round until your final answer. Note: Round your final answers to one decimal place (for example, enter 6.8 for 6.77555). Inventory turnover PPE turnover 2017 Inventory turnover PPE turnover Plant, Property and Equipment, Net $36,171 41,109 48,976 2018 b. What changes are evident in the turnover rates of Intel for these years? < +arrow_forwardCalculate the average inventory (in $) and inventory turnover ratio for the given company. (Round the inventory turnover ratio to one decimal place.) Company BeginningInventory EndingInventory AverageInventory Cost ofGoods Sold InventoryTurnover a hardware store $317,230 $300,060 $ $4,956,470arrow_forward
- Calculating the CCC from the Financial Statement The following data are taken from the financial statement: Annual Sales ( on Credit ) 1,216,666 Cost of Goods Sold 1,013,889 Average Inventory 250,000 Average Accounts Receivable 300,000 Average Accounts Payable 150,000 COMPUTE FOR THE FOLLOWING and interpret your answer: 1. DIO stands for Days Inventory Outstanding 89.99999014 DIO= (Ave. Inventory/Cost of Goods Sold)*365 =(250,000/1,013,889)*365 =89.99 or 90 days It takes the company approximately 90 days to turn inventory into sales 2. DSO stands for Days Sales Outstanding 90.00004932 DSO=(Ave. Accts. Receivables/Total Credit Sales)*365 =(300,000/1,216,666)*365 =90 days #NAME? 3. DPO stands for Days Payable Outstanding 53.99999408 DPO=(Ave. Accts. Payables/Cost of Goods Sold)*365 =(150,000/1,013,889)*365 =53.99 or 54 days It takes the company approximately 54 days to pay its invoices 4.CASH CONVERSION CYCLE 126.0000454 CCC= DIO + DSO - DPO = 90+90-54 = 126 It takes the company…arrow_forwardHow to calculate the inventory turnover ratio?arrow_forward2GFU Corporation has the following financial data for the years 20XX and 20XY: Sales Cost of goods sold Inventory 20XX $5,221,000 3,632,000 454,000 20XY $6,578,000 4,862,000 572,000 a. Compute inventory turnover based on sales for each year. (Round the final answer to 1 decimal place.) Inventory turnover ratio 20XX 20XY X X b. Compute inventory turnover based on cost of goods sold for each year. (Round the final answers to 1 decimal place.) 20XX 20XY Inventory turnover ratio X X c. This part of the question is not part of your Connect assignment.arrow_forward
- Please answer fastarrow_forwardIntel Corporation reports the following financial statement amounts in its 10-K reports. $ millions Sales Goods Sold Inventories 2016 $95,019 $24,501 2017 100,418 25,096 2018 113,357 29,162 Cost of Inventory turnover PPE turnover a. Compute the inventory and PPE turnover ratios for both 2017 and 2018. Note: Do not round until your final swer. Note: Round your final answers to one decimal place (for example, enter 6.8 for 6.77555). 2017 $5,553 6,983 7,253 0 0 Plant, Property and Equipment, Net 2018 $36,171 41,109 48,976 0 0arrow_forwardPerez Corporation has the following financial data for the years 20X1 and 20X2: Sales Cost of goods sold Inventory 20X1 20X2 20X1 $ 5,221,000 3,632,000 454,000 a. Compute the inventory turnover for each year using the formula Sales/Inventory. Note: Round your answers to 1 decimal place. Inventory Turnover Ratio times times 20X2 $ 6,578,000 4,862,000 572,000 b. Compute inventory turnover based on an alternative calculation that is used by many financial analysts, Cost of goods sold/Inventory, for each year. Note: Round your answers to 1 decimal place.arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning