Inventory Turnover Calculator
Calculate how many times per year your business sells through its average inventory by dividing cost of goods sold by average inventory value. Use it to measure inventory efficiency, spot overstocking or slow movers, and benchmark against ecommerce or retail industry norms.
Last updated: May 2026
Compare with similar
About this calculator
The formula is: inventory turnover = COGS ÷ average inventory. The numerator is the cost of goods sold for the period (annual COGS for an annual turnover ratio); the denominator is the average inventory at cost over the same period, typically computed as (beginning inventory + ending inventory) ÷ 2. The result is unitless and tells you how many times the average inventory was sold and replaced during the period. Higher turnover indicates efficient inventory management — products move quickly, capital isn't tied up on shelves, and obsolescence risk is low. The metric pairs naturally with days inventory outstanding (DIO): DIO = 365 ÷ turnover, so turnover of 12 means inventory turns monthly (30 DIO), turnover of 4 means quarterly (91 DIO). Some calculations use sales instead of COGS in the numerator; this is technically wrong because sales include markup, inflating the apparent turnover. Edge cases: zero or near-zero inventory produces extreme turnover values; service businesses with no physical inventory have undefined ratios. Industry norms vary enormously: grocery 12–25, fast-fashion 4–8, big-box retail 6–12, specialty retail 2–5, jewelry 0.5–1.5, automotive dealers 3–8, ecommerce general 4–10. Within ecommerce, the dynamics differ by model: dropshippers have effectively infinite turnover (no held inventory); Amazon FBA sellers and most DTC brands operate in the 4–10 range; subscription boxes and luxury 1–3. Trending matters more than absolute number: turnover declining over consecutive quarters signals accumulating slow-movers; rising turnover suggests leaner operations.
How to use
Example 1 — Mid-sized DTC apparel brand. Annual COGS $4,800,000 (the cost of products sold during the year, not retail sales). Beginning inventory $850,000 and ending inventory $950,000, so average inventory = (850K + 950K) / 2 = $900,000. Enter 4800000 for COGS and 900000 for Avg Inventory. Result: 5.33 turns per year. Verify: 4,800,000 / 900,000 ≈ 5.33. ✓ A turnover of 5.33 means inventory turns roughly every 68 days (365 / 5.33), reasonable for DTC apparel with seasonal collections. Below 4 would suggest overstocking; above 8 might mean stockouts losing potential sales. Example 2 — High-velocity ecommerce reseller. Annual COGS $1,200,000 (consumer electronics resold via marketplaces). Average inventory $120,000 (tight inventory management with quick replenishment cycles). Enter 1200000 and 120000. Result: 10.0 turns per year. Verify: 1,200,000 / 120,000 = 10.0. ✓ A 10× turnover (DIO = 36.5 days) is excellent for ecommerce — inventory turns monthly, meaning working capital tied up in inventory is minimized. The flip side: any supply-chain hiccup, port congestion, or supplier delay quickly leads to stockouts because there's little buffer. The optimum balances capital efficiency against stockout risk.
Frequently asked questions
What is a good inventory turnover for ecommerce?
For ecommerce specifically, the typical range is 4–10 annual turns, equivalent to 36–91 days of inventory outstanding. Subcategory norms: DTC apparel and accessories 4–8 (seasonally constrained); consumer electronics 6–12 (fast lifecycle, depreciating value); food and beverage 8–15 (perishable, fast-moving); home goods and furniture 2–5 (slow-moving, large items); beauty and personal care 6–10; toys 4–8 (highly seasonal). The right turnover balances capital efficiency (higher turns = less working capital tied up) against stockout risk (too high turns = frequent stockouts losing sales). Best-in-class ecommerce operators typically target 8–12 turns through tight demand forecasting, ABC inventory analysis (focus precision on top-selling SKUs), and just-in-time replenishment. Below industry norms suggests slow-moving inventory; above norms suggests stockouts that you can verify by checking unfulfillable orders or out-of-stock backorder data.
How do I convert turnover to days inventory outstanding (DIO)?
DIO = 365 ÷ inventory turnover. So a turnover of 6 means 61 days (365/6); turnover of 10 means 36.5 days; turnover of 4 means 91 days. DIO is often more intuitive than the ratio for operational discussions — it directly answers "how many days of sales worth of inventory do I hold on average?" Compare DIO to your reorder lead time: if you reorder weekly and DIO is 90, you have 13× too much on hand; if DIO is 5, you're running on fumes and may face frequent stockouts. DIO is also a key component of the cash conversion cycle: CCC = DIO + DSO − DPO, which measures how long cash is tied up in working capital before being recovered from customer payments minus supplier credit. Ecommerce businesses with negative CCC (collecting from customers before paying suppliers) effectively operate on supplier credit — Amazon famously runs this way.
Can inventory turnover be too high?
Yes. Very high turnover often signals understocking — you're missing sales when customers can't find what they want, and accepting lost revenue in exchange for low working-capital investment. Stockout costs are often invisible (customer browses, doesn't find item, walks away, may not return) and can dwarf the inventory-holding cost they avoid. A turnover well above industry peers also raises questions about product breadth: are you stocking only the fastest-moving SKUs and losing the long-tail customer who wants something specific? The optimum is high enough to avoid bloat and obsolescence but low enough to maintain 95–98% in-stock rates for top-selling SKUs. Track unfulfillable orders and out-of-stock searches; if those are high while turnover is also high, you're leaving revenue on the table. Best-in-class ecommerce uses dynamic inventory levels by SKU based on demand velocity rather than a single target turnover number.
What are the most common mistakes people make with inventory turnover?
The biggest is using sales instead of COGS in the numerator — sales includes markup, inflating turnover and overstating efficiency. The second is using ending inventory instead of average; this distorts the ratio whenever the business is growing or seasonal. The third is computing a single aggregate turnover that hides huge SKU-level variation — a healthy overall turnover can mask 30% of SKUs that haven't moved in 6+ months and will need to be marked down or written off. The fourth is comparing across businesses with different fiscal year-ends — a retailer measured at January 31 (post-holiday) will look very different from one measured at June 30 (mid-summer doldrums). The fifth is interpreting turnover in isolation rather than alongside gross margin: a strategy of low margin + high turnover (Costco, grocery) and high margin + low turnover (luxury, specialty) can both be profitable. Finally, ecommerce businesses often forget to include in-transit inventory in their balance — items purchased but not yet received still tie up capital and should count toward the average.
When should I not use this calculator?
Skip it for service businesses or pure-digital products with no physical inventory — the metric doesn't apply. For dropshipping businesses, turnover is effectively infinite (no held inventory), so the formula breaks down; use other operational metrics like supplier fulfillment time, gross profit per order, and customer satisfaction instead. Skip it for businesses with extreme seasonality (holiday-focused stores, swimwear, ski gear) using a snapshot ratio — the seasonal pattern matters more than any single point in time; use seasonal averages or peak-period analysis. Do not use it for businesses with high-value low-volume products where one large transaction can swing the ratio (luxury, custom manufacturing). It is also a poor fit for marketplaces (Amazon, eBay sellers) where inventory turnover at the SKU level matters more than aggregate; SKU-level ABC analysis or specific dead-stock metrics are more actionable. For comprehensive working-capital analysis, pair inventory turnover with accounts receivable turnover and cash conversion cycle — the three together tell a richer story than any single metric.