Inventory Turnover Calculator

What inventory turnover really measures

Inventory turnover is the number of times you sell through and replace your entire inventory in a year. The formula is Annual COGS / Average Inventory at cost. A turnover of 4x means your full warehouse moves four times a year — every 91 days. A turnover of 12x (food brands) means monthly flush. A turnover of 1.5x (furniture) means you're sitting on cash for 243 days before it recycles.

Most DTC operators don't actively track this number until it bites them — usually in the form of a Q1 cash crunch because Q4 over-buys didn't sell through. Turnover is the early warning system for three specific problems: overstocked aged inventory, working capital trapped in slow SKUs, and a cash conversion cycle quietly stretching past your credit line.

The real math (with a worked example)

Turnover = COGS / Avg Inventory (at cost)

Days on hand = 365 / Turnover

Worked example: a DTC coffee brand does $680,000 in annual COGS with $142,000 average inventory. Turnover = 680,000 / 142,000 = 4.8x. Days on hand = 365 / 4.8 = 76 days. Is that good? For coffee (category benchmark 10-14x) that's terrible. For furniture (benchmark 2-3x), that's excellent. Context matters.

Same brand, after operational fixes — SKU rationalization, tighter reorder points, smaller PO cadence — gets turnover to 9x. New days on hand = 41. Cash freed up: inventory drops from $142K to $75K, releasing $67,000 of working capital. That's 6 months of Shopify Plus, an entire marketing FTE, or a Q4 inventory buffer — all without raising capital.

Category benchmarks (annual turns, 2025 DTC operator data)

• Apparel / fashion: 4-6x. Seasonal drags the average; basics brands hit 6-8x.
• Beauty / personal care: 6-8x. Consumable replenishment keeps velocity up.
• Supplements: 6-9x. Subscription glide paths drive predictable sell-through.
• Food / beverage: 10-14x. Expiration dates force velocity; below 10x usually means waste.
• Consumer electronics: 6-10x. Price-drop exposure forces fast turns.
• Furniture / home goods: 2-3x. High-ticket, low-frequency. Wayfair's reported inventory turn is ~3x.
• Toys / seasonal: 3-5x. Q4-heavy; annual average obscures the seasonal peak.
• Footwear: 4-6x. Nike's global turn is famously ~4x.

The hidden cost of slow inventory (why 22% is the number that matters)

Most operators under-estimate holding cost because the biggest components don't hit a single GL line. The Council of Supply Chain Management Professionals benchmark and our own merchant data put total holding cost at 20-30% of inventory value per year, composed of:

• Warehousing: 8-12% (3PL fees, rack space, handling). ShipBob and ShipMonk typically charge $25-$45/mo per pallet; pro-rate to unit level.
• Cost of capital: 4-8%. What that dollar would earn in working capital or ad spend. With SMB loans at 9-14% APR in 2026, many brands should use a higher number.
• Shrinkage and damage: 2-4%. Retail benchmark is closer to 1.6%, DTC a bit better, but returns damage adds back.
• Obsolescence / markdown: 3-6%. The real killer for fashion and seasonal. A sweater that didn't sell by February is usually worth 50% of cost by April.
• Insurance & tax: 1-3%.

On $150K of average inventory, that's $30,000-$45,000 per year burning invisibly. It doesn't hit a single P&L line — it's hidden across 3PL bills, interest expense, and annual write-offs. The calculator above pins this number for you.

Too-fast turnover is also a problem

If your turnover is 2x your category benchmark, you're probably out of stock more than you think. Measure fill rate (orders fulfilled within promised time / total orders) and in-stock rate (SKUs available / total active SKUs). Below 95% fill rate, you're leaving 3-8% of revenue on the shelf — and worse, training customers to go to competitors.

Pair turnover with the reorder point calculator to make sure fast turns don't become lost sales.

How to improve turnover (in order of ROI)

1. SKU rationalization: The Pareto rule holds — 20% of SKUs drive 80% of revenue. Cut the long tail. A typical DTC brand with 300 SKUs can drop to 120 and see turnover jump 40-60%.
2. Smaller, more frequent POs: Move from quarterly to monthly or 6-week cadence. More frequent shipments = less average inventory. Trade-off: higher freight per unit. Run the math.
3. Demand forecasting (even a basic one): Weighted moving average on trailing 90 days, with seasonality overlay. Most brands over-buy 15-30% vs. actual demand.
4. Bundle slow SKUs: A $14 slow mover becomes a $9 upsell attached to a $42 hero. See bundle pricing calculator.
5. Markdown discipline: Aging inventory past 180 days should be systematically marked down. The pain compounds the longer you wait.
6. Pre-order / drop model: Used by Fashion Nova, Gymshark, many Shopify-native brands. Collect payment before you carry inventory. Turnover becomes effectively infinite.

Turnover and the cash conversion cycle

Cash conversion cycle (CCC) = Days Inventory Outstanding + Days Sales Outstanding - Days Payable Outstanding. For DTC brands, DSO is near zero (cards settle in 2 days); so CCC mostly depends on inventory days and your vendor payment terms.

Illustrative: 90-day inventory, 2-day DSO, 30-day DPO → CCC = 62 days. Meaning you finance 62 days of operations before cash comes back. Cutting inventory days to 50 drops CCC to 22 — the difference between a debt line and a healthy float.

Common mistakes

• Using ending inventory instead of average: Ending snapshot distorts seasonal businesses. Use monthly averages.
• Using sales instead of COGS: Dividing sales by inventory inflates the ratio by your margin. Always use COGS at cost.
• Tracking company-wide without SKU-level splits: A 5x average can hide a 15x hero SKU and a 1.5x dud.
• Ignoring in-transit inventory: If 30% of POs are in ocean freight, your "inventory" is under-stated.
• Treating turnover as the only metric: Pair with fill rate, forecast accuracy, and gross margin return on inventory investment (GMROII).

Three brand waterfalls — what turnover actually costs

The holding-cost math only hits when you build it against a specific balance sheet. Three realistic cases:

Brand A — Beauty, $2.4M annual revenue, 62% gross margin. Annual COGS $912K. Average inventory at cost: $165K. Turnover = 912/165 = 5.5x. Days-on-hand = 66. Category benchmark is 6-8x; this brand is slightly slow. Holding cost at 24%: $165K × 24% = $39,600/yr. Getting turnover to 7.5x (category median) drops average inventory to $122K — frees $43K of cash and saves $10K/yr in holding cost.

Brand B — Apparel, $6M annual revenue, 52% gross margin, seasonal. Annual COGS $2.88M. Average inventory $720K (large because of Q4 ramp + Q1 carry-over). Turnover = 4.0x. Days-on-hand = 91. Category benchmark is 4-6x so this is borderline. But break it out by season: Q1 ending inventory $560K of which $180K is aged fall/winter past its prime. Obsolescence alone on that aged $180K at 35% markdown exposure is $63K/yr. Specific fix: mark down aged stock aggressively in Q1, move to a smaller pre-fall PO.

Brand C — Food / snacks, $4.8M revenue, 48% margin, 90-day shelf life. Annual COGS $2.5M. Average inventory $195K. Turnover = 12.8x. Days-on-hand = 28.5. Within category norm (10-14x). But fill rate is only 92% — losing 6-8% of demand to stock-outs. Fix: safety stock on top 20 SKUs needs to go up 20%, which drops turnover to 11.2x but captures the 6% revenue leak (worth ~$290K/yr vs the incremental holding cost of ~$8K/yr). See reorder point calculator.

Holding cost waterfall by component (on $200K average inventory)

When you quote "24% holding cost," here's what it actually is for a typical DTC operation, broken line-by-line:

• 3PL storage fees: $200K inventory at 30-day turn = ~8,000 units in 3PL. At $0.95/unit/mo = $7,600/mo = $91,200/yr. As % of inventory = 9%. (ShipBob, ShipMonk, Flowspace April 2026 rates.)
• 3PL inbound receiving: $25-$50 per pallet received. 120 pallets/yr = $4,200/yr. 2.1%.
• Cost of capital: 8% blended — SMB lines at 10-14%, retained earnings at 6-8% opportunity cost. On $200K = $16,000/yr. 8%.
• Shrinkage: 2.2% of inventory value = $4,400/yr.
• Obsolescence / markdown: 4% average (higher in apparel, lower in staples) = $8,000/yr.
• Insurance: 0.6% = $1,200/yr.
• Personal property tax (warehouse states): 1.2% = $2,400/yr.
• IT systems / tracking: 0.4% = $800/yr.

Total: ~$40,400/yr or 20.2% of inventory value. And this number goes up, not down, during inflationary periods. If you're using a lazy "15% holding cost" assumption, add 8-10 points.

GMROII — the metric more operators should use

Gross Margin Return on Inventory Investment = Gross Margin $ / Average Inventory Cost. It answers: for every dollar of inventory investment, how many dollars of gross margin do I make?

• GMROII > 3.0: Excellent. You're running tight inventory relative to margin output.
• GMROII 2.0-3.0: Healthy DTC range.
• GMROII 1.5-2.0: Watch. Either margins or turnover need to lift.
• GMROII < 1.5: Inventory is eating the business.

Worked example: $1.5M annual gross margin, $300K average inventory. GMROII = 5.0. Excellent. Same business with $600K average inventory (operator over-bought on trade shows): GMROII = 2.5. Still okay but you've tied up $300K of cash for no gain. This is why GMROII is a better single-metric than turnover alone — it forces margin into the frame.

SKU-level turnover analysis — the 80/20 cut

Company-wide turnover hides everything. Always do the SKU split. A typical DTC brand with 150 active SKUs will look like this:

• A-items (top 15 SKUs, ~60% of revenue): Turnover 8-14x. These drive the business. Keep safety stock conservative but never run out.
• B-items (next 30 SKUs, ~25% of revenue): Turnover 4-6x. Healthy. Reorder on a cadence, not manually.
• C-items (next 55 SKUs, ~12% of revenue): Turnover 1.5-3x. Candidate for bundling into kits, minimum MOQ, or rationalization.
• D-items (bottom 50 SKUs, ~3% of revenue): Turnover under 1x. Kill. Mark down aggressively and don't reorder. Every D-item ties up 2-3% of your inventory cash for 0.06% of revenue.

The brutal truth: SKU rationalization is usually the single highest-ROI inventory project a growing brand can run. Cutting from 150 to 80 SKUs typically lifts company-wide turnover 40-70% and reduces 3PL storage fees 25%+ — without touching a single A-item.

Decision framework — when to over-stock on purpose

Turnover maximization isn't always the right move. You should plan to hold more inventory than pure turnover economics suggests when:

• Supply chain lead time is >90 days (ocean freight from Asia): Safety stock = daily demand × lead time days × service level factor. For a 120-day lead time at 98% service level on 50 units/day demand, safety stock alone is ~1,200 units.
• MOQs force it: Supplier minimum is 2,000 units and you sell 500/mo. You're carrying 4 months minimum; no way to "fix" turnover without changing supplier.
• Price volatility is material (tariffs, commodity inputs): Locking in inventory at today's cost before a tariff hike can beat the 22% holding cost. See tariff cost impact.
• Seasonal launch cycle (Q4 ramp): Front-load by August to hit October sellthrough. Accept low August-October turnover for Q4 fulfillment confidence.
• Subscription base with predictable demand: If 40% of revenue is subscription, safety stock can be lower on those SKUs specifically.

Frequently asked (operator edition)

Should I use FIFO or weighted-average cost? FIFO is standard for DTC; weighted-average is easier for bulk commodities. Most Shopify-native accounting (QuickBooks, Xero) defaults to FIFO. Your turnover math doesn't change by more than 2-3% between them for most brands.

Does pre-order model actually eliminate turnover risk? Mostly. Pre-order = customer pays upfront, you manufacture to order, turnover is effectively infinite because inventory investment is near-zero. Downside: 3-6 week delivery windows hurt CVR 15-25%. Hybrid works: pre-order for new launches, in-stock for bestsellers.

My 3PL charges a long-term storage fee — is that included in holding cost? Yes, and it's material. Amazon FBA specifically charges aged inventory fees at 181+ days ($0.50/cu ft/mo on top of regular storage) and disposal fees. See FBA fees.

How do I handle inventory that's in transit on my balance sheet? Two choices. Aggressive: count once it ships from supplier (you own the in-transit risk). Conservative: count only at receipt in warehouse. For turnover math, be consistent — if you count in-transit in inventory, subtract it from "available-to-sell" metrics too.

Is dropshipping the best turnover strategy? Mechanically, yes — zero inventory investment. But it's a margin-for-turnover trade: dropship margins typically run 15-30% vs owned-inventory 50-65%. See dropshipping margin calculator.

How does Shopify's inventory report compare to my actual inventory? Usually diverges by 5-15% due to damaged/returned stock, in-transit, and SKU mis-mapping. Reconcile monthly if you care about accurate turnover. Quarterly minimum.

At what revenue should I invest in proper demand forecasting software? Around $2M-$3M annual. Below that, a weighted-moving-average spreadsheet plus gut feel works. Above that, Inventory Planner, Cogsy, or Streamline start paying back via 15-25% reduction in stockouts and overstock.

Does dead stock count in average inventory? Yes in the balance sheet; but for meaningful turnover analysis, break out "active" (selling within 90 days) from "dead" (no sales 90+ days). Active-only turnover is the number that tells you about your operating business.

Disclaimer

Category benchmarks are directional and drawn from public filings, 3PL/operator surveys, and retail industry data. Your actual target depends on AOV, margin, and supply chain lead time. Re-compute quarterly.