Inventory turnover ratio

The inventory turnover ratio tells you how many times you sell through and replace your stock in a period. This guide gives you the formula, a worked example with hypothetical numbers, how to judge your result, and practical ways to improve it.

What inventory turnover is

Turnover measures how quickly inventory converts into sales. A higher ratio means stock sells faster. A lower ratio means stock sits longer, which ties up cash and adds storage, insurance and obsolescence risk.

An annual ratio of 6 means you cycle through your average inventory about every two months. An annual ratio of 2 means the average unit sits for roughly six months before it sells.

The formula

• Cost of goods sold (COGS) is the cost of the products you sold during the period, in dollars. You can take it from your accounting records, or calculate it as units sold × unit cost.
• Average inventory is the value of stock on hand at cost, averaged over the same period. For a simple version, use (beginning inventory + ending inventory) ÷ 2.

Both figures are in dollars at cost and cover the same period. If one is at cost and the other at selling price, the ratio is meaningless.

Days of inventory

To express turnover as time, convert it to the average number of days stock takes to sell:

In the example, 365 ÷ 6.0 ≈ 60.8 days. The same number comes from (Average inventory ÷ COGS) × 365 = ($80,000 ÷ $480,000) × 365 ≈ 60.8. For a period shorter than a year, divide the days in that period by the turnover for that period.

Shorter periods and seasonal stores

You can calculate turnover monthly or quarterly to spot changes sooner. Compare like with like by annualizing:

If your stock level swings through the year, two data points can mislead. A store that builds stock for a mid-year peak could have low inventory at both ends of the year, which makes the simple average too low and the ratio too high. In that case, average several month-end values instead. See seasonal inventory planning for how stock levels shift around peaks.

What is a good ratio?

There is no universal target. The right level depends on shelf life, supplier lead times, margins, how predictable demand is and how you finance stock. A product that expires needs to turn quickly. A high-value item that sells infrequently will turn slowly and can still be healthy.

More useful comparisons are:

• Your own history. Track the ratio quarterly. A decline you did not plan for, such as stock built ahead of a peak season, deserves investigation.
• Your own categories. Compare like with like. Never compare a fast consumable with a slow, high-value item.
• Your own supply chain. If lead times are long, you will need to hold more stock, and that limits how high turnover can go.

A low or falling ratio often points to excess stock or slow sellers. A very high ratio can mean you run lean and sell out frequently, which costs sales. Read the number alongside your stockout rate; see preventing stockouts and the inventory KPIs guide.

Why turnover matters

Cash flow

Every dollar sitting in unsold stock is a dollar you cannot spend on marketing, new products or payroll. Faster turnover returns cash sooner.

Holding cost

Carrying cost is proportional to average inventory (see inventory carrying cost). Rearranging the turnover formula shows how much stock a given sales level requires:

Freshness and relevance

Stock that sits too long can go out of date, out of season or past its expiry. Healthy turnover reduces the amount you have to mark down or write off.

Turnover versus profit

Turnover ignores margin. Gross margin return on inventory (GMROI) combines both:

Say the store above had $800,000 of sales. Gross margin = $800,000 − $480,000 = $320,000, so GMROI = $320,000 ÷ $80,000 = 4.0. Check: 6.0 × ($320,000 ÷ $480,000) = 4.0. A low-margin item needs high turnover to earn its place, while a high-margin item can justify slower turns.

Eight ways to improve turnover

1. Forecast demand more carefully

Ordering too much of the wrong products is a common cause of poor turnover. Better estimates of demand per SKU reduce overstock. See demand forecasting and improving forecasting accuracy.

2. Clear dead stock

Stock with no sales for a long time drags the ratio down. Pick a threshold that fits your products, for example 90 days without a sale, and review it every quarter. Options include markdowns, bundles, liquidation and donation. Even selling at a loss frees cash and space for products that move. See dead stock management.

3. Set reorder points from data

A reorder point that is too high builds overstock. One that is too low causes stockouts.

See the reorder point formula and the safety stock formula for how to size each term.

4. Order smaller batches more often

With steady demand, average cycle stock is roughly half your order quantity, so smaller orders mean less stock on hand. Ask suppliers for shorter lead times and lower minimum order quantities, and see the EOQ formula for the cost trade-off. Tracking open orders is easier with good purchase order management.

5. Focus effort with ABC analysis

Classifying SKUs by value shows where tighter control improves the ratio most. See ABC analysis.

6. Target promotions at slow movers

Instead of store-wide sales that cut into full-price revenue, aim offers at slow-moving items: bundle them with best sellers, offer quantity discounts, or email customers who viewed them but did not buy.

7. Check whether it is really a conversion problem

Sometimes low turnover is a presentation issue, not an inventory one. Review photos, descriptions, pricing and search visibility before assuming you bought too much.

8. Measure by SKU and category, not just overall

One overall ratio can hide a handful of fast sellers carrying a long tail of stagnant items. Calculate the ratio per category, and per SKU where you can. One caution: a SKU that was out of stock for part of the period has low average inventory and can look artificially healthy, so check availability alongside the number.

Common mistakes

• Mixing cost and selling price. COGS and average inventory must both be at cost. Dividing sales revenue by inventory at cost overstates the ratio because revenue includes your markup.
• Averaging only two points. If stock swings, use monthly values.
• Ignoring seasonality. A yearly figure hides peaks and troughs, so calculate quarterly as well.
• Comparing different kinds of products. Judge each category against its own history and constraints.
• Looking only at the total. Drill down to category and SKU.

A short routine

1. Calculate turnover and days of inventory each quarter, overall and by category.
2. Compare with prior quarters and note planned stock builds.
3. List the slowest SKUs and decide on a markdown, bundle, reorder change or discontinuation.
4. Review reorder points for the fastest sellers so they do not run out.