Inventory Turnover Ratio: Formula, Example & Days (India)

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

What is inventory turnover ratio?

Inventory turnover ratio shows how many times a business uses up and replaces its stock in a period. The formula is cost of goods sold ÷ average inventory, where average inventory = (opening stock + closing stock) ÷ 2. Divide 365 by the ratio to get the days stock sits before it is sold, so a ratio of 4 means about 91 days.

Inventory turnover ratio = Cost of goods sold ÷ Average inventory

A high ratio means stock moves fast and less cash sits in the store. A low ratio means money is stuck in material that isn't moving.

How to calculate inventory turnover ratio (step by step)

You need three numbers from your books.

  1. Find cost of goods sold (COGS). Take it from your profit and loss account for the period.

  2. Find average inventory. Add opening and closing stock, then divide by 2. Our closing stock guide shows how to value both.

  3. Divide COGS by average inventory. The answer is how many times your stock turned over.

Here is a worked example for a component maker. The figures are illustrative.

Item

Amount

COGS for the year

₹6 Cr

Opening stock

₹1.2 Cr

Closing stock

₹1.8 Cr

Average inventory

(₹1.2 Cr + ₹1.8 Cr) ÷ 2 = ₹1.5 Cr

Inventory turnover ratio

₹6 Cr ÷ ₹1.5 Cr = 4

So this factory used up and replaced its stock 4 times in the year.

Inventory turnover in days

Days often tell an owner more than a ratio does. The formula is days = 365 ÷ inventory turnover ratio.

In our example, 365 ÷ 4 ≈ 91 days. Stock sits about three months before it is used and sold.

You can also go direct: average inventory ÷ COGS × 365. Some teams use 360 days for easier maths, which gives 90 days here. Pick one and stick to it.

Inventory turnover for a manufacturer: raw material, WIP and finished goods

A factory holds three kinds of stock. One blended ratio can look healthy while one stage is choking. Work out each one separately.

Raw material turnover

Raw material turnover = raw material consumed ÷ average raw material stock. A low number points to purchase, such as buying too much or too early. Track it by material category, as our raw materials inventory guide explains.

WIP turnover

WIP turnover = cost of production ÷ average WIP. A low number points to the shop floor. Jobs are waiting between processes, machines or job workers.

Finished goods turnover

Finished goods turnover = COGS ÷ average finished goods stock. A low number points to sales and dispatch. Goods are made but not moving out.

Which stock ratio points to which team


Stock

Formula

Raw material

Consumed ÷ average raw material stock

Purchase

WIP

Cost of production ÷ average WIP

Shop floor

Finished goods

COGS ÷ average finished goods stock

Sales and dispatch

How TranZact helps you track inventory turnover

Splitting turnover by stage needs stock figures you can trust every month. In most factories, those figures are spread across Tally, Excel and WhatsApp, which were never built to keep stock live. So the ratio gets worked out once a year, after the problem has grown.

TranZact AI is manufacturing AI software used by 10,000+ manufacturers. It keeps the inputs for this calculation ready in any month, not just at year end.

  • Live stock across stores. Stock tracking with inventory ageing and valuation, across multiple stores. See the inventory management features.

  • Consumption without typing. A photo of a paper entry becomes a system entry, so consumption gets recorded the moment it happens.

  • Stock at job workers. Sub-contracting is built in, so you know how much is out on job work.

  • Buying to plan. Reorder levels and AI stock alerts cover regular items. The MRP engine runs through your orders and BOMs, then tells you what to buy and when.

  • Reports. 65+ reports and dashboards. Batch-wise stock tracking comes with Scale+ and above, as listed on pricing.

  • Tally stays. Accounting stays in Tally, Busy or Zoho Books, with one-way sync and no double entry.

You still apply the formula yourself. What TranZact does is keep live stock value, ageing and consumption current, so the inputs are ready any month. TranZact goes live in 2–3 weeks.

Book a demo →

What is a good inventory turnover ratio?

There is no single right number. It depends on your industry, product mix and supplier lead times.

A unit buying imported material with long lead times will carry more stock than one buying locally. So compare against your own past months and same-industry peers, not other sectors.

For a reference point, the finance glossary WallStreetMojo says 5 to 10 is good for most industries, including manufacturing. Treat that as their view, not a rule.

  • A low ratio usually means overstock, slow-moving items or obsolete stock. Cash is locked up, and holding costs keep adding up.

  • A very high ratio can mean you are running too lean. That risks stockouts, stopped production and missed dispatches.

Sales or cost of goods sold: which formula to use

Some people divide sales by average inventory. But sales include your margin, while stock is valued at cost. That mix makes the ratio look better than it is.

COGS at cost is the more realistic choice. Sales-based versions exist mainly to compare companies on published figures. Whichever you pick, use it every time so your months stay comparable.

Why the ratio drops in a factory and how to improve it

When turnover falls, the cause is usually one of four habits.

  • Bulk buying for a discount. The rate looks good, but the material sits for months.

  • Slow and dead items. A few items stop moving and nobody notices. See our slow-moving inventory guide.

  • WIP waiting between processes. Half-made parts pile up before a bottleneck machine or at a job worker.

  • Making without orders. Finished goods are produced to keep machines busy, then wait for a buyer.

The fixes are simple to state. Set reorder levels for regular items. Review slow movers item by item, using FSN analysis to sort fast, slow and non-moving stock.

Clear dead stock instead of carrying it year after year. And plan purchase from confirmed orders and the BOM, not from habit.

A monthly turnover check in five steps
  1. Note stock value at each month-end

  2. Average the monthly stock values

  3. Divide period COGS by that average

  4. Convert the ratio into days

  5. Review the slowest items first

Common mistakes when calculating it

  • Mixing sales with stock at cost. It inflates the ratio. Use COGS.

  • Using only the year-end snapshot. Opening and closing stock can both be unusual. An average of monthly values is more representative.

  • One blended number for all items. One slow, high-value item can hide inside a healthy total.

  • Ignoring stock at job workers. Material sent out for job work is still your inventory. Leave it out and the ratio looks better than it is.

Don't be the bottleneck. Become the AI-Run Factory. See your own items, stores and stock value in TranZact on a short call.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders