Inventory Turnover Ratio: Formula, Example & Days (India)
6 min read
By
TranZact Solutions Team
· Published


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.
Find cost of goods sold (COGS). Take it from your profit and loss account for the period.
Find average inventory. Add opening and closing stock, then divide by 2. Our closing stock guide shows how to value both.
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.
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
Note stock value at each month-end
Average the monthly stock values
Divide period COGS by that average
Convert the ratio into days
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.




