This inventory turnover calculator measures how many times a business sells through its stock in a period — COGS ÷ average inventory — and converts it into days of inventory on hand. Turnover is the vital sign of every product business: too low and cash rots on shelves; suspiciously high and the shelves are about to empty into your busiest weekend.

–

How Often the Shelf Empties and Refills

Inventory is cash wearing a costume — money already spent, waiting to become money again. Turnover counts how many times per period the business completes that transformation, and its reciprocal, days sales in inventory (DSI), counts how long each transformation takes. Both use COGS rather than revenue in the numerator deliberately: inventory is carried at cost on the balance sheet, so it must be compared against the cost of what was sold, not the marked-up price — using revenue flatters turnover by exactly the gross margin and ruins comparisons between high-margin and low-margin firms. The average inventory (start + end ÷ 2, more points if you have them) protects the ratio from period-end games and seasonal snapshots; a retailer measured only on January’s post-holiday leanness would look like a logistics genius.

Why it matters beyond tidy shelves: every turn of inventory at a given sales level releases or traps working capital (the Working Capital Calculator’s biggest lever), and inventory carries a holding cost typically estimated at 20–30% of its value per year — storage, insurance, shrinkage, obsolescence, and the capital charge itself. A business carrying $100k average inventory at 6 turns is paying roughly $20–30k a year for the privilege, invisibly. Raising turns from 4 to 6 at the same $600k COGS frees $50k of cash permanently (average inventory $150k → $100k) and cuts that carrying bill proportionally — the closest thing operations has to a free lunch, provided service levels survive it.

Worked Example (Verified)

  • COGS $600k, inventory $90k → $110k (defaults): average $100k → turnover = 6.0×, DSI = 60.8 days. Two months of stock on hand on average: comfortable for apparel or general retail, alarming for fresh food, irrelevant for a business selling aircraft parts.
  • The seasonal mirage: measure the same business with December’s stock ($180k pre-holiday build) as the “ending” figure against January’s $40k start and the average swings the result by whole turns — the defense is more averaging points (monthly balances) for seasonal businesses, which this calculator’s two-point version approximates.
  • Turnover by category beats turnover overall: a store at 6× blended may run 12× on staples and 1.2× on a decorative line that exists in the assortment out of hope. The ratio’s diagnostic power lives at SKU/category level; the company-level number here is the screening tool that tells you where to dig.

Too Low, Too High, and Just Right

Low turnover’s causes form a usual-suspects list: assortment bloat (too many SKUs splitting the same demand), optimistic buying, deteriorating product-market fit, and plain dead stock nobody writes down. High turnover is not automatically virtue: turns achieved by chronic understocking cost fill rate, basket size and eventually customers — the metric to hold beside turnover is the in-stock rate, and the optimum is where the marginal carrying cost of one more unit equals the marginal lost-sale cost of one fewer. Fast-fashion and grocery operate at the high-turn/high-discipline extreme ( Zara-style models turn by design — small batches, scarcity as strategy); spare-parts and jewelry operate low-turn by necessity (the item must be there the one time a year it’s demanded). Benchmark only against your own shelf’s physics.

Improving Turnover Without Starving Sales

  • Cut the tail: the bottom 10–20% of SKUs by velocity usually holds a wildly disproportionate share of inventory dollars; delisting or special-order-only status frees cash immediately.
  • Reorder points from data: lead time × daily demand + safety stock, computed per SKU class — not the buyer’s memory of last year’s panic.
  • Markdown cadence: dead stock’s first markdown is the cheapest; a 20% cut at day 60 beats a 60% cut at day 300 after $X of carrying cost, almost every time the math is honestly run.
  • Supplier terms as a lever: smaller, more frequent deliveries and vendor-managed inventory move the stock to someone else’s balance sheet — the turnover gain is real even when total supply-chain stock is unchanged.
  • Forecast the season, average honestly: build for the peak, but measure annual turnover on monthly averages so the build doesn’t brand the year a failure or a triumph by accident.

Related Tools

Frequently Asked Questions

How do you calculate inventory turnover?

Turnover = COGS ÷ average inventory, with average inventory = (beginning + ending) ÷ 2 when only two balances are known. Defaults: $600,000 ÷ $100,000 = 6.0×. Days sales in inventory inverts it: period days ÷ turnover = 365 ÷ 6 = 60.8 days. COGS (not revenue) is the correct numerator because inventory is carried at cost — dividing revenue by inventory-at-cost mixes a marked-up figure with a cost figure and overstates performance by the markup.

What is a good inventory turnover ratio?

Entirely industry-relative: grocery and fresh food 12–20× (perishability enforces it), consumer electronics 8–12×, apparel and general retail 4–6×, furniture 3–4×, automobiles 6–9× on vehicles (far lower on parts), heavy machinery and jewelry 1–3×. A “good” reading also beats your own history at equal or better in-stock rates: rising turns with a falling fill rate is not improvement, it’s slow-motion stockout. This calculator prints sector context beside your number.

Why use COGS instead of sales in the turnover formula?

Consistency of valuation: the denominator (inventory) sits on the balance sheet at cost, so the numerator must also be at cost — COGS is literally the cost of the inventory that left. Using revenue inflates the ratio by the gross-margin factor and makes a high-margin boutique look artificially “faster” than a discounter moving the same physical stock. Textbooks and auditors use COGS; be suspicious of any internal dashboard using sales (it exists, and it exists to flatter).

What does days sales in inventory (DSI) tell me?

The average number of days a unit (or dollar) of inventory sits before selling: DSI = period days ÷ turnover. 60.8 days in our example means the typical item waits two months for its buyer. DSI is the inventory leg of the cash conversion cycle (DSI + days receivable − days payable), so it translates directly into funding needs: every DSI day on $600k COGS is about $1,644 of inventory cash. Operations teams often prefer DSI because “cut ten days” is an actionable sentence in a way “raise turns by one” isn’t.

Can turnover be too high?

Yes — when it’s bought with empty shelves. Chronic understocking raises turns while quietly taxing revenue through stockouts, substitution and lost customers; and if ending inventory happened to be measured right after a clearance event, a single-period spike may be cosmetics, not capability. Pair turnover with fill rate and gross margin: the healthy frontier is high turns at stable margin and high availability (the fast-fashion achievement), not turns alone.

How does turnover affect cash flow?

Directly through working capital: at fixed COGS, higher turnover means lower average inventory, and the difference is cash released — moving from 4× to 6× on $600k COGS cuts average inventory from $150k to $100k, a one-time $50k cash release plus ~$10–15k/year of avoided carrying cost (at 20–30%). Conversely, falling turnover absorbs cash exactly like an expense nobody approved, which is why lenders watch inventory trends in seasonal businesses so closely.

What is GMROI and how does it relate?

Gross margin return on inventory investment: GMROI = gross margin $ ÷ average inventory $ = (gross margin % × revenue)/avg inventory — equivalently margin % × (revenue/COGS) × turnover. It fuses this page’s ratio with profitability: a low-margin discounter and a high-margin boutique can post identical GMROI by opposite routes. Retail buyers are often targeted on GMROI per category because it punishes both failure modes — stock that doesn’t turn and stock that only turns when marked down to nothing.

Is this inventory turnover calculator free?

Yes — free, instant, no sign-up. Enter COGS and beginning/ending inventory for turnover, days in inventory, and industry context for the reading.