Calculate inventory turnover ratio (COGS ÷ average inventory), days sales of inventory (DSI), and sell-through rate — the core metrics for inventory health.
Inventory turnover measures how efficiently a business converts inventory into sales.
A high turnover means goods move quickly — less cash tied up in stock and lower
carrying costs. Too high can signal stockouts; too low signals excess inventory
and capital inefficiency.
With $1.2M COGS and $200k average inventory:
Turnover = $1.2M / $200k = 6.0×
DSI = 365 / 6.0 = 60.8 days of inventory on hand
Use the same inventory valuation method consistently when comparing periods — FIFO
(First In, First Out) values inventory using the cost of the oldest stock first, while
LIFO (Last In, First Out) uses the cost of the most recently purchased stock first.
Switching methods between periods distorts the turnover trend.
Benchmarks by industry
Industry
Typical turnover
Typical DSI
Grocery / Supermarket
20–30×
12–18 days
Fast fashion / Apparel
6–12×
30–60 days
Electronics
6–10×
36–60 days
Automotive parts
4–8×
45–90 days
Furniture / Home
3–6×
60–120 days
Industrial/B2B
2–5×
73–180 days
Why turnover matters
Cash flow: Inventory is tied-up cash. $500k in stock at 3× turnover represents
4 months of working capital locked up. At 6× turnover, it's 2 months. The difference
can fund a major marketing campaign or buffer a slow season.
Carrying costs: Warehousing, insurance, shrinkage, and obsolescence typically
run 20–30% of inventory value annually. Reducing average inventory by $100k saves
$20–30k/year in carrying costs.
Stockouts vs overstock: Very high turnover (above industry benchmark) may signal
you're selling out too quickly. Very low turnover means excess stock that may
become obsolete.
Improving inventory turnover
Better demand forecasting: Use historical sales data and seasonality patterns
to order closer to actual demand.
Tighter reorder points: Set reorder triggers based on lead time + safety stock,
not gut feel.
ABC analysis: Rank SKUs (Stock Keeping Units) by revenue contribution. A-items (top 20% of SKUs,
80% of revenue) need tight management; C-items can carry lighter stock.
Faster supplier lead times: Shorter lead times allow lower safety stock.
Liquidate dead inventory: Run promotions on slow movers before they become
write-offs.
Sell-through rate
Sell-through = Units Sold / Units Received × 100%
Sell-through measures how much of what you bought you actually sold in a period.
80%+ is generally healthy. Below 60% suggests over-buying or poor category selection.
Frequently asked questions
What does this calculator do?
Calculate inventory turnover ratio, days sales of inventory (DSI), and sell-through
rate from COGS and inventory values.
What Is Inventory Turnover? Formula, Benchmarks, and How to Improve It
Inventory turnover measures how efficiently you convert stock into sales. Learn the formula, industry benchmarks, and the highest-ROI ways to improve your ratio.
Inventory turnover tells you how many times you completely sold through your
entire inventory in a year. A grocery store might turn inventory 25 times; a
furniture retailer might turn it 4 times. Both are healthy for their respective
industries.
Inventory Turnover = COGS / Average Inventory
With $1.2M in annual COGS and $200k average inventory: 6.0× turnover.
That means you sell and replace your entire inventory every 61 days.
Why inventory turnover matters
It's a cash efficiency metric: Every dollar in inventory is a dollar not
available for payroll, marketing, or growth. A retailer carrying $500k in
inventory at 3× turnover has 4 months of sales tied up in stock. At 6×, it's
2 months. The difference is $250k in freed-up working capital.
It exposes operational issues: Declining turnover often signals:
- Demand forecasting errors (buying too much)
- Supplier minimum order quantities forcing overbuy
- Poor category decisions (stocking items customers don't want)
- Seasonality not accounted for in ordering
- Pricing too high relative to competition
Calculating average inventory correctly
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
This basic average smooths out point-in-time fluctuations. For seasonal businesses,
consider calculating monthly averages across 12 months for a more accurate picture.
Using year-end inventory alone (without averaging) can distort the ratio for
seasonal businesses — a retailer with low post-holiday inventory will show
artificially high turnover.
Industry benchmarks
Industry
Typical turnover
DSI
Grocery
20–30×
12–18 days
Fast fashion
6–12×
30–60 days
Electronics
6–10×
37–61 days
Automotive
4–8×
46–91 days
Furniture
3–6×
61–122 days
Industrial B2B
2–5×
73–183 days
Compare your ratio to your industry, not to a generic "good turnover" number.
Days Sales of Inventory (DSI)
DSI = 365 / Inventory Turnover
DSI is the inverse of turnover — it tells you how many days of inventory you're
carrying. Lower is usually better: it means you're selling product quickly and
not tying up excessive cash in stock.
How to Reduce Days Sales of Inventory (DSI): 5 Proven Tactics
Days Sales of Inventory (DSI) = 365 / inventory turnover. Lower DSI means less cash tied up in stock. Here are the five highest-leverage ways to reduce it.
Days Sales of Inventory (DSI) measures how long it takes to sell through your
current inventory. Reducing DSI frees up working capital without reducing sales.
A DSI of 90 means you're carrying 3 months of inventory on average. Reducing to 60
days on $500k average inventory frees up $167k in cash — capital available for
growth, marketing, or debt reduction.
Tactic 1: Improve demand forecasting accuracy
Most excess inventory stems from forecasting errors. If you forecast 1,000 units
and sell 700, you have 300 units of dead stock consuming capital and storage.
Start with your historical sell-through by SKU and month. Identify seasonal patterns.
Use a simple weighted average of the last 3–6 months, with higher weight on recent
periods. For SKUs with high variability, reduce order quantities and reorder more
frequently.
Tactic 2: Tighten reorder points
Many businesses use gut feel for reorder timing. A data-driven reorder point is:
Reorder Point = (Average Daily Sales × Lead Time in Days) + Safety StockSafety Stock = Z-score × Daily Sales StdDev × √Lead Time
For a SKU selling 10 units/day with 14-day lead time and moderate variability:
Reorder Point ≈ (10 × 14) + (1.65 × 3 × √14) = 140 + 18.5 ≈ 159 units
Getting this right for your top 20 SKUs (which drive 80% of revenue) has the
most impact.
Tactic 3: ABC analysis — stop managing all SKUs the same way
Rank your SKUs by revenue contribution:
- A items (top 10–20% of SKUs, 70–80% of revenue): Tight management, frequent counts
- B items (middle 30%): Standard reorder logic
- C items (bottom 50%, 5–10% of revenue): Minimal reorder, consider discontinuing
Focus your forecasting and inventory optimization effort on A items. You can reduce
C-item inventory dramatically with minimal sales impact.
Tactic 4: Negotiate shorter supplier lead times
If lead time is 30 days, you must hold 30 days of safety stock. If you can reduce
to 14 days, safety stock requirements halve. Shorter lead times also reduce forecasting
error impact — you're predicting 14 days of demand instead of 30.
Tactics: diversify suppliers to create competition on lead times; build direct
relationships with manufacturers; consolidate orders to qualify for priority treatment.
Tactic 5: Liquidate slow-moving inventory before it becomes dead stock
Every 90 days, review your bottom 20% of SKUs by sell-through rate. For SKUs with
<30% sell-through in 90 days:
- Mark down 20–30% immediately
- Bundle with fast-moving items
- Return to supplier if return policy allows
- Liquidate through clearance channels if necessary
A 50% recovery on $100k of stale inventory is $50k in cash — better than $0 on
a write-off and negative storage costs.
Inventory Turnover Benchmarks by Industry: What's a Good Ratio?
Inventory turnover benchmarks vary widely by industry — from 25× for grocery to 3× for furniture. Learn what a healthy ratio looks like for your business type.
There is no universal "good" inventory turnover ratio. A jewelry store operating
at 2× turnover might be perfectly healthy; a grocery store at 2× would be in serious
trouble. The benchmark depends entirely on your industry's economics.
How to read inventory benchmarks
Higher turnover is not always better. Very high turnover can signal:
- Stockouts: selling out before restocking, losing sales
- Understocking: carrying too little buffer for demand spikes
- Under-investment in inventory leading to missed revenue
Optimal turnover balances:
- Carrying costs (warehouse, insurance, obsolescence) — minimized by higher turnover
- Stockout costs (lost sales, lost customers) — minimized by lower turnover
- Cash flow requirements — improved by higher turnover
Benchmarks by industry
Grocery and food/beverage: 20–30× turnover, 12–18 days DSI
Perishables must move fast. Grocery chains optimize store-level inventory daily.
Dead stock is often donated or disposed of; waste is tracked as a KPI.
Fast fashion and apparel: 6–12× turnover, 30–60 days DSI
Trend-driven demand makes forecasting hard. Fast fashion brands like Zara have
redesigned supply chains to achieve 12×+ by manufacturing closer to season.
Consumer electronics: 6–10× turnover, 37–61 days DSI
High obsolescence risk (new model releases, price erosion) creates pressure
to turn inventory quickly. Distributor and retailer margins are thin.
Automotive parts: 4–8× turnover, 46–91 days DSI
Wide SKU counts and long-tail demand make this complex. Auto parts retailers
typically carry 50,000–100,000+ SKUs.
Furniture and home goods: 3–6× turnover, 61–122 days DSI
Large items, high logistics cost, longer purchase cycles. Custom furniture
may have even lower turnover by design (made-to-order).
Industrial and B2B products: 2–5× turnover, 73–183 days DSI
MRO (maintenance, repair, operations) items may be held for years as insurance
against downtime. Business continuity value exceeds carrying cost.
Shopify