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.

Frequently asked questions

How do you calculate inventory turnover?

Inventory Turnover equals COGS divided by Average Inventory, where average inventory is (beginning plus ending) divided by 2; the result is turns per year. Days Sales of Inventory is 365 divided by turnover, or equivalently (average inventory divided by COGS) times 365. For example, $1.2M COGS against $200k average inventory is 6 turns and a DSI of about 61 days. Use COGS, not revenue — Revenue divided by Inventory overstates turnover because it compares top-line to a cost-basis asset.

What is a good inventory turnover ratio by sector?

It depends entirely on category. Rough 2024 turnover equivalents from US Census Bureau retail data: grocery and food retail 14 to 20 turns, general retailers 8 to 11, apparel 4 to 6, furniture and home goods 3 to 5, jewelry and luxury 1 to 2, manufacturing 5 to 8, and consumer electronics 6 to 10. For small ecommerce, a DSI under 60 days is healthy for most general goods, while over 120 days suggests dead stock or overordering. The number is only interpretable against sector-specific benchmarks, not a universal target.

Why isn't maximum inventory turnover the goal?

Because stockouts are expensive and lose customers. Very high turnover can mean inventory is so thin that you are missing sales, and a turnover spike often comes from a supplier delay emptying a category — lost revenue read as efficiency. The right target matches turns to your category's demand variability and supplier lead time, not a theoretical maximum. Turnover also needs margin context: GMROI (gross margin times turnover) is the better combined metric — above $2.00 per dollar of average inventory is typically healthy, below $1.00 means margin or turnover needs attention.

How does inventory turnover affect cash flow?

Inventory is working capital — every dollar tied up in stock is a dollar not in the bank, not earning interest, and at risk of obsolescence, so the cash impact of turnover decisions is usually larger than the direct profit impact. Improving turnover from 6x to 8x on $1.2M COGS drops average inventory from $200k to $150k, freeing $50k of cash (roughly a month of operating expenses for a typical small business), while the direct margin gain might be only 1 to 2 percent. Tie large purchase orders to the 13-week cash forecast and categorize inventory by liquidation friction so you know your realistic emergency liquidity.