Calcady™
Home / Financial / Inventory Turnover Calculator

Inventory Turnover Calculator

Calculate your Inventory Turnover Ratio and Days Sales of Inventory (DSI) to measure how efficiently your business converts physical stock into revenue.

Sales & Inventory Data

$

Inventory Balance

$
$

Average Turnover (Moderate)

Turnover Ratio

5x
Times inventory was sold and replaced

Days Sales of Inventory

73 Days
Average time to sell inventory (DSI)

Average Inventory

$100,000
(Beginning + Ending) / 2
Email LinkText/SMSWhatsApp

What is Inventory Velocity & Supply Chain Efficiency?

The Inventory Turnover Ratio measures how many times a company's entire inventory is sold and replaced over a fiscal year. A high ratio indicates efficient sales operations and lean inventory management. A low ratio suggests capital trapped in unsold goods — warehousing costs, obsolescence risk, and opportunity cost. The companion metric, Days Sales of Inventory (DSI), converts the ratio into the average number of days an item sits on the shelf before being sold.

Mathematical Foundation

Inventory Turnover=Cost of Goods Sold (COGS)Average Inventory\text{Inventory Turnover} = \frac{\text{Cost of Goods Sold (COGS)}}{\text{Average Inventory}}
COGS\text{COGS}= The direct cost of producing or purchasing the goods actually sold during the period.
Average Inventory\text{Average Inventory}= Calculated as (Beginning Inventory + Ending Inventory) / 2.
DSI=365Inventory Turnover\text{DSI} = \frac{365}{\text{Inventory Turnover}}
DSI\text{DSI}= Days Sales of Inventory — the average number of days to sell through the entire stock.

Laws & Principles

  • Industry Context Is Everything: A grocery chain turning inventory 20× per year is normal — perishable goods must move fast. An aerospace manufacturer at 2× is also normal — building satellites takes months. Never compare turnover ratios across different industries.
  • The Margin Trade-Off: High turnover typically requires thin margins (Walmart model). Low turnover demands fat margins (Ferrari model). The business model dictates the acceptable range, not a universal benchmark.
  • LIFO vs FIFO Distortion: Under LIFO accounting during inflationary periods, the newest (most expensive) inventory flows to COGS first, inflating COGS while leaving cheap legacy inventory on the balance sheet. This artificially inflates the turnover ratio on paper.

Step-by-Step Example Walkthrough

" A regional hardware chain started the year with $1,000,000 in inventory and ended with $1,400,000. Their annual COGS was $7,200,000. "

  1. Calculate Average Inventory: ($1,000,000 + $1,400,000) / 2 = $1,200,000.
  2. Apply the formula: $7,200,000 / $1,200,000 = 6.0× turnover.
  3. Convert to DSI: 365 / 6.0 = 60.8 days.
Final Result: The hardware chain turns its inventory 6 times per year. On average, a product sits on the shelf for about 61 days before a customer buys it — reasonable for a hardware retailer, though a grocery competitor would consider 61 days catastrophic.

Quick Answer: What does Inventory Turnover measure?

The Inventory Turnover Ratio divides your annual Cost of Goods Sold by your Average Inventory to calculate how many times per year you completely sell and restock your products. The higher the number, the faster your cash cycles through inventory and back into your bank account.

Stock Efficiency Formula

Velocity Equation

Turnover = COGS / Average Inventory  •  DSI = 365 / Turnover

⚠ COGS, Not Revenue

Always use Cost of Goods Sold in the numerator, not total revenue. Because inventory is recorded on the balance sheet at cost, using revenue would inflate the ratio by your markup percentage. A retailer with a 50% markup would appear to have double the turnover they actually achieve.

Supply Chain Archetypes

✓ The Grocery Velocity Machine

Razor-Thin Margins | Maximum Velocity

  1. Model: A mega-grocery chain earns $0.02 profit per dollar of bananas sold — 2% net margin.
  2. Data: Annual COGS of $40 billion against average inventory of $2.5 billion.
  3. Calculation: Turnover = $40B / $2.5B = 16.0×. DSI = 365 / 16 = 22.8 days.

→ The entire warehouse restocks every 23 days. The company compensates for paper-thin margins with extreme velocity — cash comes back fast enough to fund the next purchase cycle without external financing.

✗ The Obsolescence Trap

Technology Inventory | Rapid Depreciation

  1. Model: A consumer electronics distributor stocks smartphone accessories in bulk.
  2. Data: COGS of $8M against average inventory of $4M.
  3. Calculation: Turnover = $8M / $4M = 2.0×. DSI = 365 / 2 = 182 days.

→ Products sit for 6 months before selling. In consumer electronics, half a year means the next phone model has launched. The remaining inventory must be liquidated at steep discounts, destroying margins.

Industry Turnover Benchmarks

Industry Typical Turnover
Grocery / Perishables14× – 20×
Apparel / Fashion4× – 8×
Heavy Equipment2× – 4×
Luxury Goods1× – 3×

Inventory Optimization Tactics

Do This

  • ✓Target negative working capital. If you can sell a product and collect customer payment before your supplier invoice is due (net-60 terms), your vendors are financing your growth. Amazon perfected this model with 8–10× turnover and 30-day supplier terms.
  • ✓Segment by SKU velocity. Your aggregate turnover hides that 20% of SKUs generate 80% of sales. Run turnover at the SKU level to identify dead stock that should be liquidated or discontinued immediately.

Avoid This

  • ✗Over-optimizing into stockouts. Pushing turnover too high by holding zero buffer stock means any supply chain disruption (shipping delay, factory shutdown) causes empty shelves. Customers buy from competitors, and the lost revenue far exceeds the warehousing cost you saved.
  • ✗Ignoring channel stuffing. A company can inflate revenue by pushing excess inventory onto distributors near quarter-end. The balance sheet shows "sold" goods, but the products are sitting in distributor warehouses. Check if turnover improvements are real or just accounting maneuvers.

Frequently Asked Questions

Why use COGS instead of revenue in the numerator?

Inventory is recorded on the balance sheet at cost, not at retail price. Using revenue in the numerator would contaminate the ratio with your markup, making turnover appear higher than it actually is. COGS-to-inventory keeps both sides of the fraction on the same cost basis for an accurate comparison.

What is considered a good turnover ratio?

There is no universal benchmark — it depends entirely on the industry. A fresh food supplier under 12× may be in trouble (products spoil). A clothing boutique at 4–6× is healthy. A heavy equipment manufacturer at 2–3× is normal. Always compare against direct competitors in the same sector, not cross-industry averages.

How does inflation distort inventory turnover?

Under LIFO accounting during inflationary periods, the most recently purchased (expensive) inventory flows to COGS first, inflating the numerator. Meanwhile, older (cheaper) inventory remains on the balance sheet, deflating the denominator. This combination artificially inflates the turnover ratio without any real operational improvement.

Can inventory turnover be too high?

Yes. An extremely high turnover with near-zero buffer stock means any supply chain disruption — a shipping delay, a factory shutdown, or a raw material shortage — immediately causes stockouts. Lost sales and damaged customer relationships can cost far more than the warehousing expenses you saved by keeping inventory lean.

Related Operations & Liquidity Tools