Question

In: Accounting

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 place. 20Y7 20Y6 Number of days’ sales in inventory days days

c. Are the changes in inventory turnover and the number of days’ sales in inventory from 20Y6 to 20Y7 favorable or unfavorable?

Solutions

Expert Solution

Ans:

a)Calculation of Inventory turnover:

inventory turnover= cost of goods sold/ Average account inventory

2017

Average inventory= (766500+846800)/2= 806650

inventory turnover= 3791255/806650=4.7

Inventory turnover is 4.7 times

2016

Average inventory= (766500+730000)/2=748250

inventory turnover= 4040550/748250= 5.4 times

Inventory turnover is 5.4 times

Calculation of days sale in in inventory:

days sale in in inventory= 365/inventory turnover

2017

days sale in in inventory=365/4.7= 77.7days

2016

days sale in in inventory=365/5.4= 67.6 days

Changes will be favourable since the higher the inventory turnover ratio the better it is

for the company


Related Solutions

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...
Determine (a) the inventory turnover and (b) the number of days’ sales in inventory. Round to one decimal place.
A company reports the following: Cost of goods sold $560,000Average inventory 112,000Determine (a) the inventory turnover and (b) the number of days’ sales in inventory. Round to one decimal place
Financial statement data for years ending December 31for Depuy company follow
Financial statement data for years ending December 31for Depuy company followParticularsYear 2Year 1Sales $5,510,000$4,880,000Fixed assets :  Beginning of year16,00,00014,50,000End of year2,200,00016,00,000(a) Determine the fixed asset turnover ratio for year 1 and year 2(b)Does the change in the fixed asset turnover from year 1 to year 2 indicate a favorable or an unfavourable change?  
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
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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
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.
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 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
ADVERTISEMENT