Calculate your inventory turnover ratio and average days to sell inventory. Enter your cost of goods sold and average inventory value to evaluate how efficiently your business manages inventory and converts stock into sales.
Inventory turnover measures how many times a business sells and replaces its inventory during a period. It's one of the most important efficiency metrics for product-based businesses (retailers, wholesalers, manufacturers) because slow inventory ties up cash, increases storage costs, exposes products to obsolescence, and signals demand mismatch. A fast inventory turnover indicates strong product-market fit and efficient operations; slow turnover suggests overstocking, poor demand forecasting, or product mix problems.
The math is straightforward: Annual COGS divided by Average Inventory value equals turnover ratio. A grocery store turning over inventory 20 times per year is replacing its stock every 18 days. A furniture store turning over 5 times per year takes ~73 days to cycle through inventory. The complementary metric — Days Sales of Inventory (DSI) — converts turnover to days: 365 / Turnover Ratio. Industry context dominates these benchmarks; grocery stores need fast turnover (perishable products), while jewelry stores acceptably have slow turnover (long-lasting products with high margins).
This calculator computes inventory turnover ratio, days in inventory, and tracks inventory as % of revenue. Use it for: efficiency monitoring (quarterly trend analysis), industry benchmarking, identifying slow-moving inventory categories, and planning working capital requirements (inventory ties up cash that could be invested elsewhere). Important context: improvement in turnover often comes from product mix changes (cut slow-moving SKUs), forecasting improvements (don't overorder seasonal items), supplier relationships (just-in-time inventory), and pricing decisions (markdowns clear dead stock). Modern retail (Amazon, Walmart) achieves remarkable turnover through data-driven demand forecasting and supplier integration — small businesses can borrow similar approaches at smaller scale.
Grocery store: $5M annual COGS, average inventory $250K, $7M revenue. Turnover: $5M / $250K = 20x annually Days in Inventory: 365 / 20 = 18 days Inventory % of Revenue: 3.6% Excellent grocery turnover. 18 days reflects mostly perishable items with fast replenishment cycles. Industry benchmark 14-20x — at the top of range, suggesting strong demand and efficient operations. Inventory only 3.6% of revenue: very efficient working capital management. Compare to specialty retail (10-20%) or jewelry (50%+). Grocery model works through volume, not margin.
Specialty boutique: $800K COGS, average inventory $200K, $1.5M revenue. Turnover: $800K / $200K = 4.0x annually Days in Inventory: 365 / 4.0 = 91 days Inventory % of Revenue: 13.3% Below industry benchmark (specialty retail typically 5-7x). 91 days inventory days too long — products risk becoming dated or going out of season. Improvement opportunities: 1. Aggressive markdown of slow movers (recover cash, clear shelf) 2. Reduce SKU count (focus on best sellers) 3. Better demand forecasting 4. Smaller initial orders with faster reorders 5. Negotiate vendor return policies for unsold items Reducing inventory to $130K (improving turnover to 6.2x = 59 days) would free $70K of working capital while maintaining sales volume. That cash could fund growth, debt reduction, or owner distributions.
Independent jewelry store: $400K COGS, average inventory $600K, $1M revenue. Turnover: $400K / $600K = 0.67x annually Days in Inventory: 365 / 0.67 = 545 days (1.5 years average) Inventory % of Revenue: 60% Slow turnover by industry norm (jewelry typically 1-3x). 1.5 year inventory days could be acceptable for jewelry given: high margins (typically 40-50% gross margin), long-lasting products (no obsolescence), display importance (broader selection attracts customers). But: working capital tied up in inventory is enormous (60% of revenue). For independent jewelers, this is the largest single financial commitment. Strategies to improve without sacrificing selection: - Memo arrangements (carry but don't own — manufacturer owns until sold) - Consignment from suppliers - Reduce backstock; rely on rapid reorder - Highlight existing inventory through marketing rather than constantly adding new - Trade-in programs (provide raw material for inventory turnover) Even modest improvement (1x → 1.5x turnover) frees substantial capital while preserving customer experience.
Use this calculator for inventory efficiency monitoring, comparison to industry benchmarks, working capital planning, identifying improvement opportunities in supply chain or merchandising, or analyzing operational efficiency trends.
Pair with cogs-calculator (COGS source data), working-capital (cash tied up in inventory), and cash-flow (operational cash impact).
Important inventory turnover considerations:
1. **Industry context dominates.** Grocery 14-20x and jewelry 1-3x both represent appropriate norms for their categories. Don't apply universal benchmarks.
2. **Calculate by category for diverse businesses.** Aggregate turnover hides category-level patterns. Hardware store might have 8x turnover overall but 20x for nails and 2x for power tools.
3. **Track trend over time.** Quarterly trend reveals improvement vs. deterioration. Industry benchmark provides absolute reference; your trend provides operational signal.
4. **Higher isn't always better.** Excessive turnover can mean understocking and lost sales. Balance turnover with customer service (in-stock rates).
5. **Inventory ties up cash.** Every dollar of inventory is a dollar not available for other uses (debt payment, growth investment, owner distributions). Working capital efficiency matters.
6. **Obsolescence risk varies by category.** Fashion, technology, perishables: high obsolescence risk demands fast turnover. Durable goods (furniture, building materials): slower turnover acceptable.
7. **Seasonal businesses need seasonal analysis.** Annual averages mask seasonal patterns. Calculate per-season for accurate insight.
8. **ABC analysis identifies improvement targets.** Top 20% of SKUs (A items) — focus on availability. Middle 30% (B items) — standard management. Bottom 50% (C items) — minimize inventory or eliminate.
9. **Just-in-time requires reliable supply chain.** Reducing inventory through JIT works only with reliable suppliers, predictable demand, and acceptable customer wait times. Failed JIT produces frequent stock-outs.
10. **Cash conversion cycle metric.** Inventory days + receivables days − payables days. Lower = more efficient working capital cycle. Inventory turnover is one component.
11. **Demand forecasting investment pays back.** Better forecasts → less safety stock needed → higher turnover and lower carrying cost. Forecasting tools/data investment often has high ROI.
12. **Dead inventory write-offs.** Inventory unsalable at any price needs to be written off (reduces COGS or inventory balance). Reflects past forecasting errors; improving forecasting reduces future write-offs.
Calculate COGS and gross profit to understand your product profitability.
Calculate working capital and current ratio for your business.
Calculate key financial ratios for liquidity, profitability, and leverage.
Calculate total labor cost per employee including benefits and taxes.
Compare buying vs leasing business equipment.
Calculate commercial loan payments with balloon option.
Turnover Ratio
5.0
times per year
Days in Inventory
73
days to sell
Average Inventory
$100,000
Gross Margin
33.3%
$250,000