How to Calculate Inventory Turnover

Inventory turnover is the ratio that tells you whether you are selling what you buy. Low turns mean capital is tied up in slow-moving goods that risk obsolescence. High turns mean either excellent demand or inventory so thin that stockouts are hurting revenue. The number is only interpretable against sector-specific benchmarks.

1. Two formulas, one concept

Two equivalent ways to express inventory efficiency:

Inventory Turnover = COGS / Average Inventory

Where Average Inventory = (Beginning Inventory + Ending Inventory) / 2. The result is "turns per year."

Days Sales of Inventory (DSI) = 365 / Inventory Turnover

Or equivalently: (Average Inventory / COGS) × 365. The result is "average days inventory sits before selling."

Worked example. An ecommerce business with $1.2M COGS and average inventory of $200k: Turnover = 6x. DSI = 365 / 6 = ~61 days. Inventory sits, on average, 61 days from receipt to sale. For most fast-moving categories, 61 days is acceptable; for perishables or fashion, it's a warning signal.

Note: use COGS, not revenue. A common mistake is Revenue / Inventory — this overstates turnover because it compares top-line to a cost-basis asset. Stick with COGS for accurate comparison^[3].

2. Sector benchmarks from public data

US Census Bureau data on retail inventory-to-sales ratios provides the honest market benchmark^[1]. Rough 2024 turnover equivalents by sector:

• Grocery / food retail: 14–20 turns (DSI 18–26 days). Perishability forces high turns.
• General retailers: 8–11 turns (DSI 33–45 days).
• Apparel: 4–6 turns (DSI 60–90 days). Seasonal collections and fashion risk.
• Furniture / home goods: 3–5 turns (DSI 73–120 days). Larger SKUs, longer consideration cycles.
• Jewelry / luxury goods: 1–2 turns (DSI 180+ days). Unique-item inventory.
• Manufacturing: 5–8 turns typical, highly variable by industry^[2].
• Consumer electronics: 6–10 turns. Rapid obsolescence forces discipline.

For small ecommerce, target varies by category but: DSI under 60 days for most general goods is healthy; DSI over 120 days suggests dead stock or overordering.

3. What moves turnover up

Turnover improvements come from one of three levers:

• Reducing average inventory. Smaller reorder quantities, more frequent orders, tighter safety stock. Requires reliable supplier lead times to avoid stockouts.
• Increasing COGS / sales velocity. Better forecasting, sharper promotional planning, elimination of slow-movers from the catalog.
• SKU rationalisation. Cut SKUs that sell below a minimum velocity threshold. In most catalogs, the bottom 30% of SKUs by velocity account for under 5% of revenue but carry proportional inventory burden.

Practical diagnostics:

• ABC analysis. Classify SKUs as A (top 70% of revenue), B (next 20%), C (last 10%). Apply different turnover targets to each — A items should turn 2–3x faster than C items.
• Obsolescence reserve. Inventory older than 90 days in non-perishable categories should be evaluated for markdown or liquidation. Holding obsolete inventory at book value distorts turnover calculations and postpones a loss that's already been incurred.
• Reorder point discipline. Reorder point = (Average Daily Usage × Lead Time) + Safety Stock. Under-reordering causes stockouts; over-reordering is where most bloat accumulates quietly.

4. Pitfalls to avoid

Four common mistakes:

• Using point-in-time inventory instead of average. Especially in seasonal businesses, end-of-period inventory can be materially lower than average, inflating reported turnover. Use average — ideally a 12-month rolling average for cyclical businesses.
• Ignoring consignment and vendor-managed inventory. If you don't own the inventory but it's in your warehouse, it's not on your balance sheet — but it may still tie up operational capacity. Track both separately.
• Chasing maximum turnover. The math says higher turnover = better capital efficiency; reality says stockouts lose customers. The right target is matched to your category's demand volatility and lead times, not a theoretical maximum.
• Single-metric focus. Turnover without gross margin context is misleading. A business turning inventory 20x at 5% margin is worse than one turning 6x at 40% margin on the same capital base^[4].

GMROI (Gross Margin Return on Inventory Investment) combines these: GMROI = Gross Margin × Turnover. For every dollar of average inventory, how many dollars of gross margin does it generate annually? Target varies, but GMROI above $2.00 is typically healthy for most retail categories; below $1.00 suggests either margin or turnover needs attention.

Inventory management done well is boring. Consistent ABC discipline, disciplined reorder points, regular obsolescence reviews. That routine — rather than any sophisticated demand-forecasting system — is what produces the turnover numbers that top-quartile operators report.

5. Tie inventory decisions to cash flow

Inventory is working capital. Every dollar of inventory is a dollar not in your bank account, not earning interest, not available for operations, and at risk of obsolescence. The cash-flow implication of turnover decisions is usually larger than the direct profit impact.

Worked example. An ecommerce business does $1.2M COGS at 6x turnover, so $200k average inventory. Improve turnover to 8x through SKU rationalisation and tighter reorder points — average inventory drops to $150k. That is $50k of cash freed up, roughly one month of operating expenses for a typical small business. The direct margin impact of the turnover improvement itself might be 1–2% on COGS; the cash liberation is the bigger story.

Two operational disciplines that connect turnover to cash:

• Link purchase orders to cash forecast. Large inventory commitments should appear on the 13-week cash forecast. The PO approval process should involve someone who sees the cash position, not just the demand forecast.
• Categorise inventory by liquidation friction. Some inventory moves at full margin; some at discount; some requires liquidation channels at 10–30¢ on the dollar. In a cash crunch, knowing which is which determines realistic emergency liquidity.

The connection between turnover and cash is where inventory decisions affect whether the business runs out of money in a downturn. Retailers that carried too much inventory into 2024's cost-of-capital normalisation routinely reported margin erosion of 400–800 basis points through markdown cycles to clear stock^[1]. Discipline on the upside shows up as cash in the downturn.

As of 2026-Q2, Census retail inventory data continues to track above pre-2020 levels in several categories, suggesting ongoing overstock conditions in some sectors^[2]. Operators who manage to category-appropriate turnover levels rather than category averages are consistently the ones with working-capital flexibility when market conditions tighten.

6. Numeric worked example — SKU rationalisation decision

A small ecommerce catalog carries 400 SKUs. Pareto pattern holds roughly: the top 80 SKUs (20%) drive $960k of $1.2M COGS; the remaining 320 SKUs split $240k. Average inventory per SKU on the long tail runs $300 — so the bottom 320 SKUs tie up $96k of the $200k balance sheet (48%) to produce 20% of velocity.

Run the numbers on cutting the bottom 160 SKUs (the weakest half of the tail):

Before:  COGS $1.2M / Avg inventory $200k = 6.0x turns, DSI 61 days
Cut:     Lose ~$60k COGS from eliminated tail, free ~$48k inventory
After:   COGS $1.14M / Avg inventory $152k = 7.5x turns, DSI 49 days
Cash:    $48k freed (≈4 weeks of opex for a typical $600k-opex ecom)
Margin:  If cut SKUs carried 35% GM vs catalog avg 42%, GM$ drops
         by ~$21k but GM% rises from 42.0% to 42.5%

The trade-off is modest revenue loss for meaningful capital freed and higher margin quality. Decision criterion: if the freed capital can be redeployed into top-decile SKUs at the catalog-average turn rate, the math almost always favours the cut. If redeployment is uncertain, keep a subset of the tail as category-completeness SKUs and accept the lower turn.

7. Failure modes worth naming

• Turnover spike from a stockout, read as a win. A supplier delay empties a category, pushing turnover from 6x to 10x for a quarter. Reported as "inventory efficiency improvement" when it was lost revenue. Always cross-check turnover moves against fill-rate and back-order metrics before celebrating.
• Obsolescence hidden in accounting periods. Carrying three-year-old inventory at book value mechanically suppresses turnover (inflates the denominator) and defers a loss that's already economic fact. FASB ASC 330 requires writedowns to net realisable value^[3]; internally, an aging policy that flags >180-day inventory for review keeps the number honest.
• Seasonal averaging mistakes. A Christmas-heavy retailer with December inventory of $800k and May inventory of $100k has an annual average of roughly $300k — using the simple (Beg + End)/2 on a calendar year, which captures only two points, can easily be 30–50% off. Use monthly averages for cyclical businesses.

As of 2026-Q2, the operational reality for most sub-$5M-revenue ecom operators is that disciplined reorder-point math plus quarterly obsolescence review drives 80%+ of the available turnover improvement. The remaining 20% usually comes from demand-sensing investments that only start to pay back above $10M COGS.