Question

In: Accounting

I want to know the relationship between inventory turnover ratio and allowance for obsolescence in inventory....

I want to know the relationship between inventory turnover ratio and allowance for obsolescence in inventory.

Basically, I am analyzing a company's financial statement, and this company is in bad position, high leverage (borrowed 1B last year), one of the sector filled chapter 11, and there are many other bad signs. Therefore, I thought the inventory turnover ratio in 2016 would be better than 2017's, however, it came out to be 2017's inventory turnover ratio was little bit higher than 2016's.

In this company's 10-k report, it says that "allowance for obsolescence in inventory from 2016 to 2017, which was 221.70%." is this the reason for higher inventory turnover ratio in 2016 than 2017? Or is it just irrelevant to the inventory turnover ratio? Can someone explain this?

Solutions

Expert Solution

Yes there is a relationship between inventory turnover ratio and allowance for obsolescence in inventory

Inventory turnover is used for measurement over a period. This is useful to know the business has an excess investment in stock than what is actually required for sales, which leads to unexpected poor inventory planning.

Inventory turnover ratio = Cost of goods sold / Inventory

The impact of inventory turnover will be based on the following items:

1. If the inventory is maintained as per seasonal requirement

2. If the inventory become obsolete i.e out of date

3. obtaining the bulk of goods for obtaining huge discounts which leads to high investment in inventory

The inventory turnover ratio gets effected with increase in obsolescence of stock if the obsolete stock was written off the ratio will change rspectively

The same was happened even in your company report also due to increase in obsolescence of stock, inventory turnover ratio is also high


Related Solutions

What is the relationship between the inventory turnover ratio and the "days of inventory"? For a...
What is the relationship between the inventory turnover ratio and the "days of inventory"? For a given amount of cost of goods sold, as inventory turnover ratio increases, the "days of inventory" cannot be predicted to increase or decrease increases initially increases, then decreases decreases
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 .
Scenario: The researhers want to know if there is a relationship between the number of cars...
Scenario: The researhers want to know if there is a relationship between the number of cars sold and revenues in hopes of developing a predictive model in the near future. Below is the number of cars sold and revenue generated for 6 automotive dealerships. You're expected to create a SCATTERPLOT diagram, then insert a line of best fit and the regression equation. Company Cars (in ten thousands) Revenue (in billions) A 63 7 B 29 3.9 C 20.8 2.1 D...
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
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
What insights can be gained from inventory ratio analysis, such as inventory turnover ratio and number...
What insights can be gained from inventory ratio analysis, such as inventory turnover ratio and number of days’ sales in inventory ratio?
Researchers working for Kaiser want to know if there is a relationship between smoking and diabetes....
Researchers working for Kaiser want to know if there is a relationship between smoking and diabetes. They sample 900 patients at random from the population of patients who are 18 and older. In the sample, there are 145 smokers. Of these, 54 have no diabetes, 72 have pre-diabetes, and 19 have diabetes. Among the nonsmokers, 527 have no diabetes, 160 have pre-diabetes, and 68 have diabetes. (a) What is the null hypothesis the researchers might want to test, and what...
The simple rule for inventory turnover is that a low ratio is preferable.
The simple rule for inventory turnover is that a low ratio is preferable.
For this post, I want to know which T-ratio is the appropriate result and why?
For this post, I want to know which T-ratio is the appropriate result and why?
You want to know if there is a relationship between surgeons’ surgical experience and surgical site...
You want to know if there is a relationship between surgeons’ surgical experience and surgical site infection (SSI) rates. Since SSI’s are relatively rare (infections develop in roughly 1-3 of every 100 patients who have surgery), you decide to do a case control study in which you select hospital patients who experienced a SSI and hospital patients who did not, and compare patients’ exposures to surgeons with <10 years of experience, and >10 years of experience. Assume you have access...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT