What is the inventory turnover ratio?
The inventory turnover ratio tells you how many times you sold through your stock and replaced it in a period. A ratio of 5 for a year means your average stock was sold and bought again five times. You will also see it called stock turnover, inventory turns, stock turn or merchandise turnover.
For a D2C brand, turns measure how fast your cash moves. You paid your supplier for every unit in your warehouse before any customer paid you. The faster stock turns, the sooner that cash comes back for the next purchase order or the next month of ads. Slow turns mean money sits on shelves while you fund growth from somewhere else.
One store-wide ratio is a diagnosis, not a plan. This page goes from the diagnosis (turns and days) to the decisions: how much cash you could free, when to reorder and how much to order.
How to use this inventory turnover calculator
- Pick a currency chip: INR, USD, GBP, EUR or AED. INR uses lakh formatting, so you see ₹12,00,000, not 1,200,000.
- Enter COGS and choose whether it covers a month, a quarter or a year. The tool converts the result to turns per year. Note the warning at this input: use COGS, not revenue.
- Enter start and end inventory value at cost. If you only know one value, enter that one and the tool uses it as the average.
- Set a goal turnover to see Cash freed at your goal turnover.
- For one SKU, add the inputs for sell-through, safety stock, reorder point and EOQ.
- Read the verdict pill (slow, okay, healthy or very fast, based on days on hand) and the formula lines, which show each calculation with your own numbers.
Example values are pre-filled, so a full result shows on load, and results update as you type. Copy link saves your inputs in the URL, and Save as PDF prints a clean report. Everything runs in your browser and nothing is stored.
Inventory turnover formula with a worked example
The inventory turnover formula needs two numbers from the same period, both at cost (Wikipedia).
Watch the brackets. Add the two stock values first, then divide by 2. If you write "beginning + ending ÷ 2" without brackets, you only halve the ending value and your average comes out too high.
Worked example in ₹
- Annual COGS: ₹60,00,000
- Beginning inventory: ₹10,00,000. Ending inventory: ₹14,00,000
- Average inventory = (₹10,00,000 + ₹14,00,000) ÷ 2 = ₹12,00,000
- Turnover = ₹60,00,000 ÷ ₹12,00,000 = 5 turns a year
- Days on hand = 365 ÷ 5 = 73 days
The same maths in $
COGS $480,000, beginning stock $90,000, ending stock $110,000. Average = $100,000. Turnover = $480,000 ÷ $100,000 = 4.8. Days on hand = 365 ÷ 4.8 ≈ 76 days.
Only one stock value?
Use that value as your average inventory, as Pearson's accounting course explains. The result is less accurate if stock moved a lot during the period, so add the second value once you have it.
Where Shopify merchants find the inputs
For COGS, fill in cost per item on your products so cost data flows into your reports, or take COGS from your accounts. You can also work it out as beginning inventory + purchases − ending inventory, or use our COGS Calculator. For stock value, take a month-end figure at cost from Shopify's inventory reports (availability depends on your plan), your inventory app or your books. Leave out GST input credit (India) or VAT (UK, EU, Gulf) that you can reclaim.
Why you must use COGS, not revenue
Revenue includes your markup. If you divide revenue by inventory, turnover looks much faster than it really is. Here is the same store at a 60% gross margin:
| Item | Value |
|---|---|
| Annual revenue | ₹1,50,00,000 |
| COGS (40% of revenue) | ₹60,00,000 |
| Average inventory at cost | ₹12,00,000 |
| Revenue ÷ inventory (wrong) | 12.5 |
| COGS ÷ inventory (right) | 5.0 |
The revenue version is 2.5 times too high, because 1 ÷ 0.40 = 2.5. A founder who reads 12.5 thinks they hold about 29 days of stock. The real figure is 73 days. That is why the calculator shows a warning right at the COGS input.
Two more mistakes to avoid:
- Inventory at retail price. Under IAS 2, inventories are measured at the lower of cost and net realisable value. India's Ind AS 2 follows the same rule. Value stock at cost so it matches COGS.
- Mixed periods. One quarter of COGS against a full-year average gives you a quarterly ratio, not an annual one.
In India, RTO parcels from failed COD orders come back into the warehouse. Count only units you can sell again. Not sure of your margin? Check it with the Gross Margin Calculator.
Monthly or quarterly numbers: converting to turns per year
A turnover ratio means nothing until you know what period it covers. A ratio of 0.29 could be a week, a month or a year. Always convert it to turns per year before you compare.
- Monthly: May COGS ₹5,00,000 and average inventory ₹5,00,000 give a monthly ratio of 1. Multiply by 12 to get about 12 turns a year, or roughly 30 days of stock.
- Quarterly: Quarter COGS $150,000 and average inventory $100,000 give 1.5 per quarter. Multiply by 4 to get 6 turns a year, or about 61 days.
When you choose monthly or quarterly in the tool, it does this conversion for you. A monthly ratio of 1 then reads correctly as about 12 turns a year.
Days of inventory: turning the ratio into days on hand
Days sales of inventory (DSI), also called days inventory outstanding (DIO) or days on hand, is the same number shown in days. It is easier to act on, because you can compare it with your supplier lead time.
| Turns per year | Days on hand |
|---|---|
| 2 | 183 |
| 4 | 91 |
| 6 | 61 |
| 8 | 46 |
| 12 | 30 |
The verdict pill in the tool uses days on hand to label your result as slow, okay, healthy or very fast. Use it as a starting point, then check your lead time. If you hold 120 days of stock and your supplier delivers in 30, you are probably overstocked. If you hold 20 days and lead time is 45, a stockout is close.
What is a good inventory turnover ratio?
Sources do not agree. Extensiv says a good ratio is between 5 and 10. A Shopify blog post gives 4 to 8 times a year. Neither range is wrong. They describe different businesses. A single "good" number for every D2C brand does not exist.
| Factor | Pushes turns up | Pushes turns down |
|---|---|---|
| Category | Food, consumables, beauty refills | Furniture, electronics, wide size ranges |
| Lead time | Local suppliers, short runs | Overseas factories, sea freight |
| MOQ | Small minimums | Large minimums per colour or size |
| Perishability | Short shelf life forces fast sales | Long shelf life allows deep stock |
| Seasonality | Off-season months | Pre-season stock build |
For context, the US Census Bureau put the retail inventories-to-sales ratio at 1.36 for August 2026, meaning retailers held about 1.36 months of sales in stock (FRED, vintage 15 Oct 2026). It is based on sales, not COGS, so it is not a direct match for your ratio. The data also gets revised.
The best benchmark is your own trend and your lead time. Also remember that very high turns are not always good. They can mean frequent stockouts, and ads sending paid traffic to sold-out pages.
How much cash is stuck in your stock?
This is the question most founders really care about. If you hit a higher turnover with the same COGS, you need less average inventory. The difference is cash you get back.
Example in ₹
- Annual COGS: ₹1,20,00,000 (₹1.2 crore). Current turnover: 4
- Current average inventory = ₹1,20,00,000 ÷ 4 = ₹30,00,000
- Average inventory at 6 turns = ₹1,20,00,000 ÷ 6 = ₹20,00,000
- Cash freed = ₹30,00,000 − ₹20,00,000 = ₹10,00,000
Example in $
COGS $600,000 with $200,000 average inventory is 3 turns. At 5 turns you need $600,000 ÷ 5 = $120,000. Cash freed = $80,000.
That cash lowers your working capital needs and shortens your cash conversion cycle. For a brand that runs on paid ads, ₹10 lakh back from stock can fund weeks of testing. Before you spend it, check the return with the ROAS Calculator. The calculator above shows this figure as "Cash freed at your goal turnover".
Sell through rate: formula and how it differs from turnover
Sell through rate measures the share of available units you sold in a window. Shopify's inventory report defines it as units sold ÷ (units sold + units still in stock), using the most recent 30 days, with a processing delay of about 2 days (Shopify Help Center).
Example: you sold 300 units and 200 are left. Sell-through = 300 ÷ 500 × 100 = 60%. Units sold plus units remaining equals starting units plus units received, which is what the calculator asks for.
Do not mix this up with "percent of inventory sold", which divides units sold by starting stock. If you started with 250 units, received 250 more mid-month and sold 300, that figure is 120%. True sell-through can never go above 100%.
Use sell-through for single SKUs, launches and seasonal drops. Use turnover for the business as a whole across a year. What is a good sell-through for a new launch? No reliable industry number exists. Work back from your plan instead. If you plan to clear 600 units in 3 months, you need about 200 sales a month, so check month one against that pace.
Safety stock formula
Safety stock is the buffer that covers demand spikes and late shipments. There are three common versions.
1. Max minus average (no statistics needed)
Max 26 a day × 50 days = 1,300. Average 20 a day × 45 days = 900. Safety stock = 400 units. It is simple, but it usually gives a large buffer.
2. Statistical (demand varies)
| Service level | Z |
|---|---|
| 90% | 1.28 |
| 95% | 1.65 |
| 99% | 2.33 |
A SKU sells 20 a day with a standard deviation of 6 and a 45-day lead time from China. Safety stock = 1.65 × 6 × √45 = 1.65 × 6 × 6.71 ≈ 67 units.
3. Demand and lead time both vary
Use this when shipping times from China or India swing by weeks. Keep in mind that more safety stock means more average inventory, which lowers turnover. Set the service level per SKU, not the same for all.
Reorder point: when to place the next PO
Measure lead time from the day you place the PO to the day stock is ready to sell. Include production, freight, customs clearance and 3PL inbound. Many brands count only the factory time and run out.
For a product with a 45-day lead time from China, selling 20 units a day with 67 units of safety stock: reorder point = 20 × 45 + 67 = 967 units. When stock on hand plus stock already on order falls to 967, place the next order.
Economic order quantity (EOQ): how much to order
Economic order quantity is the order size that keeps the total of ordering cost and holding cost lowest. At EOQ, the two costs are equal over a year.
- D = annual demand in units
- S = cost per order (freight booking, admin, inspection)
- H = annual holding cost per unit = holding rate × unit cost
Example in ₹
- D = 20 a day × 365 = 7,300 units
- S = ₹4,000 per order
- H = 25% × ₹400 unit cost = ₹100
- EOQ = √(2 × 7,300 × 4,000 ÷ 100) = √5,84,000 ≈ 764 units
In dollars: D = 7,300, S = $60, H = 25% × $8 = $2. EOQ = √(2 × 7,300 × 60 ÷ 2) = √438,000 ≈ 662 units.
Does EOQ work for small brands with MOQs?
Partly. EOQ assumes steady demand and no price breaks. If your supplier's MOQ is 1,000 units, you order at least 1,000. Round to carton packs and adjust for seasonal peaks. Use EOQ as a reference point, not a strict rule.
EOQ vs reorder point
EOQ tells you how much to order. Reorder point tells you when. The reorder point can be larger than EOQ. Here it is 967 against an EOQ of 764, because the long lead time means you need a new order placed before the last one arrives.
How to improve your inventory turnover ratio without stocking out
- Go SKU by SKU. A store-wide ratio can look healthy while one bestseller is about to run out and ten slow SKUs hold most of your cash. Sort SKUs by stock value (ABC analysis) and fix the A items first.
- Order smaller and more often. Split big POs into two or three shipments, and negotiate lower MOQs, even at a small price premium.
- Clear dead stock. Use markdowns, bundles with bestsellers or free gifts above a cart value. Check the margin first with the Break-even Calculator.
- Match ads to stock. Push budget toward overstocked SKUs and cut spend on low-stock ones. ScaleWin tracks profit and ad spend daily across Meta and Google, so you can see which products are worth pushing.
- Close the loop. Forecast demand, set safety stock and reorder points, order near EOQ, then check turns and days again every month.