Inventory Turnover Calculator

See how many times your inventory is sold and replaced over a year, and how many days of stock you're holding on average.

Inventory Turnover Ratio

0

Days Inventory Outstanding₹0

What Inventory Turnover Actually Measures

Inventory turnover tells you how many times a business sells through and replaces its entire stock over a given period — typically a year. A turnover ratio of 6 means your average inventory was fully sold and restocked six times over the year, or roughly once every two months. It's one of the clearest signals available for whether money tied up in stock is moving efficiently through the business, or sitting on a shelf quietly costing you in storage, insurance, and the opportunity cost of cash that could be doing something else.

Unlike revenue or profit, which tell you how the business performed, inventory turnover tells you something more specific and operational: how well you're matching what you buy or produce to what customers actually want to buy from you, at the pace they want to buy it. Get this wrong in either direction — too little turnover or, less obviously, turnover that's uncomfortably high — and the effects show up directly in cash flow, storage costs, and lost sales.

Inventory Turnover Formula, With a Worked Example

Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory
Days Inventory Outstanding = 365 ÷ Turnover Ratio

Say a mid-sized apparel retailer had a COGS of ₹1,20,00,000 for the year, and its average inventory value across the year was ₹20,00,000. Turnover comes out to ₹1,20,00,000 ÷ ₹20,00,000 = 6. Convert that into days: 365 ÷ 6 ≈ 61 days. In plain terms, a typical unit of stock sits in the warehouse or on the shelf for roughly 61 days before it sells — a useful, concrete number for judging whether that pace matches the nature of what's being sold.

Why COGS, Not Revenue, Goes in the Formula

It's a common instinct to use sales revenue in the numerator instead of COGS, since revenue is the more familiar number — but this overstates turnover, because revenue includes markup on top of the inventory's actual cost. COGS reflects the value of the inventory itself at cost, matching the basis on which "average inventory" is valued, which keeps the ratio internally consistent and comparable across businesses that carry different markup percentages.

Calculating Average Inventory Correctly

Using a single point-in-time inventory value — say, your stock level on December 31st — can badly distort the ratio if that particular day happened to catch you unusually stocked up or unusually depleted, which is common around major sales events or seasonal restocking. Average inventory smooths this out.

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

For a more accurate picture — especially for businesses with meaningful seasonal swings — many finance teams calculate average inventory from monthly or quarterly snapshots rather than just the two year-end figures, averaging twelve or four data points instead of two. The more evenly spaced data points you use, the less a single unusually high or low month distorts the final ratio.

What Counts as a "Good" Turnover Ratio? It Depends Entirely on What You Sell

There's no universal target number, because the right turnover pace differs enormously by industry, and comparing across categories is close to meaningless.

  • Grocery and fresh food: often 15-20+ turns a year, since perishability forces extremely fast movement — anything slower risks spoilage and direct write-offs.
  • Fashion and apparel: typically 4-8 turns a year, balancing seasonal collections against the risk of markdowns on unsold stock once a season ends.
  • Electronics and consumer tech: commonly 6-12 turns, reflecting both steady demand and the risk of rapid obsolescence as newer models launch.
  • Furniture and large appliances: often as low as 2-4 turns, since these are higher-value, lower-frequency purchases that naturally sit longer between sales.
  • Automotive parts and industrial equipment: can run below 3 turns a year, particularly for specialized parts that need to be kept in stock for occasional but critical demand.

Before judging your own ratio as too high or too low, compare it against businesses genuinely similar to yours in what they sell and how customers buy it — not against a number from a completely different category.

Is Higher Turnover Always Better? Not Quite

A higher ratio is generally a good sign — it means capital isn't sitting idle in unsold stock, storage costs stay lower, and there's less risk of inventory going obsolete, expiring, or falling out of fashion before it sells. But turnover that's too high relative to your industry norm can signal a different problem: understocking, which shows up as frequent stockouts, lost sales to customers who simply buy from a competitor instead of waiting, and rushed, more expensive reordering to keep shelves from sitting empty.

The healthiest position is usually a turnover ratio that sits comfortably within your industry's typical range, rather than the highest number achievable in isolation. A retailer bragging about an unusually high turnover ratio might actually be quietly losing sales every week to stockouts that never show up directly in the turnover number itself, since you can't calculate turnover on inventory you didn't have to sell in the first place.

Days Inventory Outstanding and the Cash Conversion Cycle

Days Inventory Outstanding (DIO) — the 365 ÷ turnover figure — converts an abstract ratio into a genuinely intuitive number: how many days, on average, a unit of stock sits before it sells. This number feeds directly into a broader and equally important measure called the cash conversion cycle, which tracks how long cash stays tied up in the full cycle from buying inventory to collecting payment from a customer.

Cash Conversion Cycle = Days Inventory Outstanding + Days Sales Outstanding − Days Payable Outstanding

A shorter cash conversion cycle means cash returns to the business faster after being spent on inventory — a genuinely important factor for a small business managing tight cash flow, since it directly affects how much working capital is needed to keep operations running smoothly month to month. Reducing DIO, by improving turnover, is often the single biggest lever available for shortening this cycle, since inventory typically sits idle for the longest stretch of the three components.

Practical Ways to Improve Inventory Turnover

Sell through slow-moving stock deliberately, rather than letting it linger. A planned clearance sale or bundle offer on aging inventory converts dead stock into cash and shelf space, even at a reduced margin, which is usually better than the item sitting unsold indefinitely.

Order in smaller, more frequent batches instead of large infrequent ones. This keeps average inventory lower without necessarily reducing total annual sales, directly improving the turnover ratio, though it does require a supplier relationship and logistics setup that can support more frequent, smaller deliveries.

Use sales data to forecast demand more accurately by product line. Overstocking on slow sellers while understocking fast movers is one of the most common root causes of a poor blended turnover ratio — better forecasting, even using simple historical sales patterns, often improves turnover more than any single operational change.

Reconsider your supplier lead times. Suppliers with shorter, more reliable lead times let you safely hold less buffer stock, since you can reorder and restock faster if demand picks up — directly lowering average inventory without increasing stockout risk.

Tracking Turnover by Product Category, Not Just as One Blended Number

A single overall turnover ratio can hide a lot. A retailer with a healthy blended turnover of 8 might have one product category turning over 20 times a year while another sits at 2, quietly tying up disproportionate cash and shelf space without anyone noticing in the blended number. Breaking turnover down by category, or even by individual SKU for a smaller catalog, surfaces exactly where inventory is moving efficiently and where it's stagnating — information a single company-wide ratio simply can't provide on its own.

Inventory Turnover and Seasonal Businesses

For a business with pronounced seasonal demand — festive-season retail, back-to-school supplies, winter clothing — a single annual turnover ratio can be misleading if it flattens sharp seasonal spikes into one smooth-looking average. A business might legitimately run a turnover ratio of 15 during its three-month peak season and closer to 2 during the rest of the year, and a blended annual figure of, say, 6 obscures both realities rather than usefully describing either one.

Calculating turnover separately for peak and off-peak periods gives a far more actionable picture, particularly for planning purchase orders. Ordering enough stock to sustain a peak-season pace of turnover year-round would badly overstock the business during quieter months, while planning purchases around the annual blended average risks running short right when demand is highest — exactly the period when a stockout is most costly in lost sales.

A Quick Health Check: Turnover Trend Over Time

A single turnover ratio, viewed in isolation, tells you where you stand today but not which direction things are heading. Tracking the ratio across several consecutive quarters reveals trends that a one-time snapshot simply can't — a steadily declining ratio, even one still technically within an acceptable industry range, is often the earliest visible sign of a demand-forecasting problem, slowing sales in a particular category, or a buying pattern that's drifted out of sync with what customers actually want. Catching that trend early, while it's still a minor drift rather than a serious cash-flow problem, is one of the most practical reasons to review this number on a regular schedule rather than only when something has already gone visibly wrong.

Using This Calculator Effectively

Enter your COGS for the period and your average inventory value to instantly see both your turnover ratio and days inventory outstanding. Compare the result against your specific industry's typical range rather than a generic benchmark, and revisit the calculation each quarter — a single number is a snapshot, but the direction it moves over consecutive periods is usually the more useful signal for catching a developing problem early.

Frequently Asked Questions

Related Calculators