Inventory Turnover Calculator
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.
Inputs
Results
Turnover Ratio
5.0
times per year
Days in Inventory
73
days to sell
Average Inventory
$100,000
Gross Margin
33.3%
$250,000
Revenue Breakdown
Formula
How to use this calculator
- Enter annual COGS (cost of goods sold for the year — from your income statement).
- Enter beginning inventory value (start of year).
- Enter ending inventory value (end of year).
- Enter annual revenue for context (inventory as % of revenue calculation).
- Review inventory turnover ratio, days in inventory, and average inventory.
- Compare to industry benchmark for your specific business type.
- Track quarterly trend — improvement signals good operations; deterioration warrants investigation.
- For improvement opportunities: identify slow-moving SKUs (perform ABC analysis — typically top 20% of SKUs generate 80% of sales; bottom 20% may be candidates for elimination).
- For seasonal businesses: calculate turnover by season for accurate analysis. Annual numbers can mask seasonal patterns.
- Calculate by category if your business sells diverse products. Different categories have different normal turnover rates.
- Don't pursue maximum turnover blindly. Some inventory is needed for customer service and stock-out prevention.
Worked examples
Grocery store benchmark
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 retail with room to improve
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.
Jewelry — slow turnover by design
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.
When to use this calculator
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.
Common mistakes to avoid
- Comparing inventory turnover across industries. Grocery 20x and jewelry 1x are both appropriate; industry context matters.
- Calculating only aggregate, not by category. Diverse business turnover patterns vary enormously by product category.
- Pursuing maximum turnover at expense of customer service. Stock-outs cost lost sales; balance efficiency with availability.
- Ignoring trend in favor of point-in-time number. Quarterly trend reveals operational direction; single number provides limited insight.
- Forgetting working capital impact. Inventory ties up cash that could fund other purposes; efficiency matters financially.
- Not addressing slow-moving SKUs. Bottom 20% often candidates for elimination, freeing capital and shelf space.
Frequently Asked Questions
Sources & further reading
- Inventory Management Resources — U.S. Small Business Administration
- Retail Industry Benchmarks — U.S. Census Bureau Retail Trade
- Inventory Management Standards — AICPA-CIMA