Inventory Turnover and Days’ Sales in Inventory – W. Glass & Company reported the following information...

Inventory Turnover and Days’ Sales in Inventory – W. Glass & Company reported the following information in its recent annual report:

	2015	2016
Cost of goods sold	$4,000,000	$4,600,000
Beginning inventory	$900,000	860,000
Ending inventory	860,000	640,000

Calculate the company’s inventory turnover and days’ sales in inventory for both years.

Solutions

Expert Solution

Inventory turnover = Cost of goods sold / Average inventory

Days’ sales in inventory = 365 / Inventory turnover

2015:

Inventory turnover = $4,000,000 / [($900,000 + $860,000) / 2] = 4.55

Days’ sales in inventory = 365 / 4.55 = 80.3 days

2016:

Inventory turnover = $4,600,000 / [($860,000 + $640,000) / 2] = 6.13

Days’ sales in inventory = 365 / 6.13 = 59.5 days

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000...

Average Inventory, Inventory Turnover Ratio, Inventory Turnover in Days Belt Company had net sales of $1,891,675,000 and cost of goods sold of $1,713,635,000. Belt had the following balances: January 1 December 31 Inventories $301,500,000 $385,000,000 Required: Assume 365 days per year. 1. Calculate the average inventory. $ 2. Calculate the inventory turnover ratio. Round to two decimal places. times 3. Calculate the inventory turnover in days. Round to two decimal places. days

Inventory Turnover and Days’ Sales in Inventory The Southern Company installed a new inventory management system...

Inventory Turnover and Days’ Sales in Inventory The Southern Company installed a new inventory management system at the beginning of 2015. Shown below are data from the company’s accounting records as reported out by the new system: 2015 2016 Sales Revenue $8,000,000 $11,000,000 Cost of Goods Sold 4,000,000 4,800,000 Beginning Inventory 510,000 530,000 Ending Inventory 530,000 600,000

17) Which of the following statements is CORRECT? a. The inventory turnover ratio and days sales...

17) Which of the following statements is CORRECT? a. The inventory turnover ratio and days sales outstanding (DSO) are two ratios that are used to assess how effectively a firm is managing its current assets. b. If a firm sold some inventory on credit as opposed to cash, then there is no reason to think that either its current or quick ratio would change. c. If a firm sold some inventory on credit, then its current ratio would probably not...

Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December...

Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December 31 for Holland Company are shown below. 20Y4 20Y3 Cost of merchandise sold $1,778,280 $1,093,905 Inventories: Beginning of year 347,480 243,820 End of year 499,320 347,480 a. Determine the inventory turnover for 20Y4 and 20Y3. Round to one decimal place. Inventory Turnover 20Y4 20Y3 b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and...

Accounts receivable turnover and days’ sales in receivables For two recent years, Robinhood Company reported the...

Accounts receivable turnover and days’ sales in receivables For two recent years, Robinhood Company reported the following: 20Y9 20Y8 Sales $7,357,500 $6,195,000 Accounts receivable: Beginning of year 550,000 500,000 End of year 540,000 550,000 a. Determine the accounts receivable turnover for 20Y9 and 20Y8. Round answers to one decimal place. 20Y8: 20Y9: b. Determine the days’ sales in receivables for 20Y9 and 20Y8. Use 365 days and round all calculations to one decimal place. 20Y8: days 20Y9: days c. Are the changes...

Inventory Turnover and Days’ Sales in Inventory The Southern Corporation installed a new in- ventory management...

Inventory Turnover and Days’ Sales in Inventory The Southern Corporation installed a new in- ventory management system at the beginning of 2018. Shown below are data from the company’s accounting records as reported by the new system: 2018 2019 Sales revenue. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....

Current Ratio: Asset Turnover Ratio: Inventory Turnover Ratio: Days In Sales Inventory Ratio: Gross Margin Ratio:...

Current Ratio: Asset Turnover Ratio: Inventory Turnover Ratio: Days In Sales Inventory Ratio: Gross Margin Ratio: Earning Per Share Ratio: Discuss what each ratio indicates about company performance. What does each ratio “tell” about a company? Interpret the ratios and use the interpretation as a basis to analyze the operational effectiveness .

Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December...

Inventory turnover and number of days’ sales in inventory Financial statement data for years ending December 31 for Tango Company follow: 20Y7 20Y6 Cost of goods sold $3,791,255 $4,040,550 Inventories: Beginning of year 766,500 730,000 End of year 846,800 766,500 Required a. Determine the inventory turnover for 20Y7 and 20Y6. Round to one decimal place. 20Y7 20Y6 Inventory turnover b. Determine the number of days’ sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal...

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kracker Corp. Foodstuff Inc. Winston Stores Cost of merchandise sold $34,310.0 $33,945.0 $35,040.0 Inventory, beginning of year 1,993.7 2,086.9 1,582.1 Inventory, end of year 1,954.3 2,005.1 1,489.9 a. & b. Determine...

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are...

Inventory Turnover and days’ sales in inventory Kracker Corp., Foodstuff, Inc., and Winston Stores, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information: Kracker Corp. Foodstuff Inc. Winston Stores Cost of merchandise sold $34,310.0 $34,675.0 $35,405.0 Inventory, beginning of year 1,993.7 2,131.8 1,498.7 Inventory, end of year 1,954.3 2,048.2 1,411.3 a. & b. Determine...

Subjects