Inventory turnover ratio calculator
Enter your cost of goods sold and inventory value. You'll get your turnover ratio and how many days it takes to sell through your stock.
4.8 turns a year
You sell through your average inventory about every 76 days.
- Average inventory
- $20,000
- Days to sell through
- 76 days
- Inventory turnover
- 4.8
$96,000 ÷ (($18,000 + $22,000) ÷ 2) = 4.8
Inventory turnover = cost of goods sold ÷ average inventory. With $96,000 of goods sold in a year and $20,000 of stock on average, turnover is 4.8: you sell through your inventory about every 76 days.
How the calculator works
Average inventory
(Inventory at the start + inventory at the end) ÷ 2, both valued at cost.
Turnover ratio
Cost of goods sold ÷ average inventory.
Days to sell through
Days in the period ÷ turnover. This is the same as days sales in inventory.
Questions
What is the inventory turnover ratio?
How many times you sell through your average inventory in a period: cost of goods sold ÷ average inventory. A turnover of 4.8 in a year means your stock is replaced about every 76 days.
Is a higher turnover always better?
Higher usually means less cash tied up in stock, but past a point it means you're running out. Look at turnover next to stockouts: if both are rising, you're ordering too little, not selling better.
Can I work it out in units instead of dollars?
Yes. Units sold ÷ average units in stock gives the same ratio for a single product, which is often more useful than a store-wide dollar figure.
What's the link with days sales in inventory?
They're the same measure turned around: days in the period ÷ turnover = days sales in inventory. Days sales in inventory calculator
How do I raise turnover without running out?
Order closer to what each product actually sells: smaller, more frequent orders for steady sellers, and stop reordering what has stopped selling. Find products that haven't sold in 90 days