Inventory Turnover Calculator — How Fast Is Your Stock Moving?
Calculate inventory turnover ratio and days inventory outstanding. Find out if you're overstocked or running too lean relative to your sales volume.
Inventory sitting on shelves is cash that isn't moving. Too much inventory and you're tying up working capital, risking obsolescence, and paying storage costs. Too little and you're turning away sales. Inventory turnover ratio tells you how efficiently you're managing this balance. Use the CalcHub Inventory Turnover Calculator to find your ratio and days inventory outstanding (DIO).
The Formulas
Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory Days Inventory Outstanding (DIO) = 365 / Inventory Turnover RatioAverage inventory = (Opening inventory + Closing inventory) / 2
Example: A Clothing Retailer
Annual COGS: ₹90,00,000
Opening inventory: ₹15,00,000
Closing inventory: ₹21,00,000
Average inventory: ₹18,00,000
The company sells and replaces its entire inventory 5 times per year, or holds stock for an average of 73 days. Whether that's good depends on the industry.
Industry Benchmarks
| Sector | Typical Turnover Ratio | Typical DIO |
|---|---|---|
| Grocery / Supermarket | 15–25× | 15–25 days |
| Fast Fashion | 4–8× | 45–90 days |
| Electronics | 4–6× | 60–90 days |
| Automotive Parts | 3–5× | 70–120 days |
| Furniture | 3–4× | 90–120 days |
| Pharmaceuticals | 3–5× | 70–120 days |
| Luxury Goods | 1–2× | 180–365 days |
How to Use the Calculator
- Enter annual or quarterly COGS (not revenue — turnover uses cost basis)
- Enter opening and closing inventory values (at cost)
- Get inventory turnover ratio, DIO, and weekly average sales rate
- Optionally compare against industry benchmark to see if you're above or below average
What High vs Low Turnover Means in Practice
High turnover (good signs):- Efficient supply chain management
- Products are in demand
- Minimal storage and holding costs
- Strong cash conversion
- Stockouts and lost sales if demand spikes
- Pressure on supplier relationships from constant reordering
- Quality control gaps from rushed procurement
- Cash locked in unsold inventory
- Increased risk of obsolescence or spoilage
- Higher storage and insurance costs
- May indicate declining demand or over-purchasing
- Wine, spirits, aged goods (turnover is the product)
- Build-to-stock manufacturers managing buffer
- Luxury or limited-edition product strategy
Improving Inventory Turnover
- ABC analysis: rank SKUs by sales velocity. A-items (top 20% by volume) get priority stock; C-items get cut or put on consignment.
- Demand forecasting: better prediction = less safety stock needed
- Supplier terms: shorter lead times let you hold less buffer inventory
- Clearance pricing: slow-moving stock should be sold below cost rather than held indefinitely — holding cost is real
Should inventory turnover use revenue or COGS?
COGS is the standard for inventory turnover calculation — both COGS and inventory are valued at cost, making the ratio internally consistent. Using revenue (which includes markup) artificially inflates the ratio and makes comparisons across different-margin businesses misleading.
What's a good inventory turnover ratio for D2C e-commerce?
For D2C brands selling physical products, 6–12× per year is a reasonable target. This means 30–60 days of inventory on hand. Below 4× (90+ days) suggests overstocking; above 15× (24 days) risks frequent stockouts. The right number depends on your supplier lead times and demand variability.
How does inventory turnover connect to working capital?
Higher turnover means less cash tied up in inventory at any point. If you can increase turnover from 4× to 6× while holding the same sales volume, your average inventory drops by 33% — freeing significant working capital. Faster-turning inventory is almost always better for cash flow.