How to Calculate Inventory Turnover and Days in Inventory
Inventory turnover shows how many times you sell and replace your stock in a year. Divide the cost of goods sold for the year by your average inventory, both at cost. If you sold 300,000 of goods at cost and held 50,000 of stock on average, your inventory turned over 6 times.
The formula
Inventory turnover = cost of goods sold ÷ average inventory
Average inventory is usually (stock at the start + stock at the end) ÷ 2. The inventory turnover calculator gives 6 times for the example.
Days in inventory
Turn the ratio into days to see how long stock sits before it sells:
Days in inventory = 365 ÷ inventory turnover
365 ÷ 6 = about 61 days. The days in inventory calculator gives 60.8 days.
Is higher better?
Usually, up to a point. Higher turnover means less money tied up in stock and less risk of it going out of date. Too high can mean you run out often and lose sales. Compare with similar businesses and with your own history, because normal levels vary a lot: fresh food turns over far faster than furniture.
Two day-to-day measures
Sell-through rate shows how much of a delivery has sold:
Sell-through = units sold ÷ units received × 100
650 sold from 1,000 received is 65%. The sell-through rate calculator does this; it is useful for seasonal and fashion stock.
Days of inventory on hand shows how long current stock will last:
Days on hand = units in stock ÷ average daily sales
600 units selling 25 a day last 24 days, according to the days of inventory on hand calculator.
Improving turnover
- Order smaller amounts more often, if supplier terms allow.
- Clear slow sellers with bundles or discounts.
- Set reorder points so you restock just in time. The inventory reorder point calculator shows when to order.
- Review which items sell and stop ordering the ones that do not.
Use cost, not price
Calculate turnover with cost of goods sold and inventory at cost. Mixing selling prices and costs inflates the ratio.
Questions and answers
What is a good inventory turnover ratio?
It depends on the industry. Fast-moving goods turn over many times a year; durable goods turn over fewer times. Compare with similar businesses.
How do I convert inventory turnover to days?
Divide 365 by the turnover ratio.