Question
In: Accounting
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 2 years agoRelated 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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
ADVERTISEMENT