Spotting cash trapped in slow stockA hardware retailer suspects too much money is tied up on the shelves. Cost of goods sold of $500,000 against $100,000 of average inventory gives 5x turnover and 73 days on hand. Cutting that to 60 days would free roughly a fifth of the inventory investment for other uses, which makes the case concrete rather than intuitive.
Comparing this year against last yearA shop owner runs the calculation for two consecutive years using each year figures. A falling ratio with flat sales means inventory is growing faster than demand, which usually shows up as a cash squeeze months before it shows up in the profit and loss statement.
Setting a reorder policy for perishable goodsA bakery with $260,000 of cost of goods sold and $16,000 of average inventory turns over 16.25 times a year, about 22 days on hand. For products with a shelf life measured in days, that number is a direct signal that ordering patterns need to be weekly rather than monthly.
Answering a lender question during a credit reviewWorking capital lines are often sized against inventory. A borrower asked how quickly stock converts to cash can produce the ratio and days figure in under a minute, along with the two inputs behind them, which is a better answer than a general assurance that stock moves quickly.
Input: Cost of goods sold $500,000, average inventory $100,000.Result: Turnover ratio 5.00x and 73 days inventory outstanding. Stock is sold and replaced five times a year, sitting about two and a half months on average.
Input: Cost of goods sold $1,200,000, average inventory $150,000.Result: Turnover ratio 8.00x and 46 days inventory outstanding, because 365 divided by 8 is 45.6 and the display rounds to whole days.
Input: Cost of goods sold $260,000, average inventory $16,000 for a bakery.Result: Turnover ratio 16.25x and 22 days inventory outstanding. Fast turnover is normal for short shelf-life goods and would be alarming for furniture.