How it works
Inventory turnover measures how many times your entire stock of inventory sells through and is replaced in a given period — typically a year. A ratio of 8 means you sold through your average inventory eight times, which translates to roughly 46 days on the shelf. The formula divides cost of goods sold by average inventory value. The higher the ratio, the faster stock converts to revenue and the less cash sits idle on shelves. But the ratio is only useful in context: a grocery store running at 12x is normal because food perishes, while a luxury jeweler at 3x is healthy because high-value items take longer to move. The calculator also converts the ratio into days-in-inventory, compares your figure against an industry benchmark, and estimates how much excess inventory you are carrying if your turnover lags the norm. Excess inventory is not just idle cash — it costs storage, insurance, depreciation and the risk of obsolescence.
Formula
Turnover ratio = COGS ÷ Average inventory | Days in inventory = 365 ÷ Turnover ratio | Excess inventory = Actual − (COGS ÷ Industry turnover)
Tips
- Calculate average inventory as (beginning + ending inventory) ÷ 2 for accuracy.
- Seasonal businesses should compare the same quarter year-over-year, not back-to-back quarters.
- Over-stocking to chase a high turnover can cause stockouts and lost sales.
- Use the days-in-inventory figure to set reorder points and negotiate supplier terms.
Frequently asked questions
- What is a good inventory turnover ratio?
- A healthy ratio depends on your industry. Retail and grocery stores typically run 8–12x per year, manufacturing 5–8x, wholesale 6–10x, and luxury goods or heavy equipment 2–4x. The best indicator is your own trend — rising turnover over quarters signals improving efficiency.
- How do I calculate inventory turnover?
- Divide your cost of goods sold (COGS) by your average inventory value for the period. Average inventory equals (beginning inventory + ending inventory) ÷ 2. Using COGS rather than revenue gives a more accurate picture because it strips out margin distortion.
- Does high inventory turnover always mean good performance?
- Not always. Extremely high turnover can indicate chronic stockouts, where customers cannot find what they want and leave. The goal is the optimal turnover rate that minimizes carrying costs without sacrificing sales — not the highest possible number.
- How does inventory turnover affect cash flow?
- Higher turnover converts inventory to cash faster, improving working capital. If your turnover ratio is 4x versus an industry average of 8x, you are carrying roughly twice the inventory needed, locking up cash that could fund growth, pay down debt, or earn interest.