SScaleWin Start free
Free tool · Shopify & D2C

Inventory Turnover Ratio Calculator: Days, Sell-Through & EOQ

Get your inventory turnover ratio, days of stock and cash stuck on shelves, plus sell-through rate, safety stock and EOQ for reordering.

✓ Free · no signupBy Ajay KumarUpdated

Check how fast your stock sells

₹

What the items you sold cost you, not their selling price. Using revenue makes the ratio look better than it is.

₹
₹

Value stock at cost. Know only one of the two? Leave the other empty.

Goal and sell-through rate
× / year

Shows how much cash you would free by hitting this goal. Many sources suggest 4–8 for D2C.

units
units
units
Reorder plan: safety stock and EOQ
units
units
days
days
₹
₹

Cost per order = shipping, admin and fees for one purchase order. Holding cost = storage, insurance and cash tied up for one unit for a year (often 20–30% of unit cost).

Inventory turnover ratio
4.00× per year
Healthy: you sell through your stock about every 91 days.
Days of inventory91 days
Average inventory₹9,00,000
Turns per year4.0×
Cash freed at 6× a year₹3,00,000
Stock planning
Sell-through rate75.0%
Safety stock220 units
Reorder point360 units
Best order size (EOQ)413 units

Inventory turnover = COGS ÷ average inventory

Track profit per product with ScaleWin →

Calculated in your browser. Nothing you type is stored.

What is the inventory turnover ratio and how do you calculate it?

The inventory turnover ratio shows how many times you sell and replace your stock in a period, usually a year. Divide cost of goods sold (COGS) by average inventory, both valued at cost. Average inventory is (beginning stock + ending stock) ÷ 2. Then divide 365 by the ratio to get your days of inventory on hand.

Inventory turnover = COGS ÷ ((Beginning inventory + Ending inventory) ÷ 2)

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

  1. Pick a currency chip: INR, USD, GBP, EUR or AED. INR uses lakh formatting, so you see ₹12,00,000, not 1,200,000.
  2. 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.
  3. 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.
  4. Set a goal turnover to see Cash freed at your goal turnover.
  5. For one SKU, add the inputs for sell-through, safety stock, reorder point and EOQ.
  6. 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).

Inventory turnover = COGS ÷ ((Beginning inventory + Ending inventory) ÷ 2)

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 ₹

  1. Annual COGS: ₹60,00,000
  2. Beginning inventory: ₹10,00,000. Ending inventory: ₹14,00,000
  3. Average inventory = (₹10,00,000 + ₹14,00,000) ÷ 2 = ₹12,00,000
  4. Turnover = ₹60,00,000 ÷ ₹12,00,000 = 5 turns a year
  5. 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:

ItemValue
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.

Turns per year = period turnover × (365 ÷ days in period)
  • 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.

Days on hand = 365 ÷ annual turns = (Average inventory ÷ COGS) × days in period
Turns per yearDays on hand
2183
491
661
846
1230

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.

FactorPushes turns upPushes turns down
CategoryFood, consumables, beauty refillsFurniture, electronics, wide size ranges
Lead timeLocal suppliers, short runsOverseas factories, sea freight
MOQSmall minimumsLarge minimums per colour or size
PerishabilityShort shelf life forces fast salesLong shelf life allows deep stock
SeasonalityOff-season monthsPre-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.

Cash freed = Current average inventory − (Annual COGS ÷ Target turnover)

Example in ₹

  1. Annual COGS: ₹1,20,00,000 (₹1.2 crore). Current turnover: 4
  2. Current average inventory = ₹1,20,00,000 ÷ 4 = ₹30,00,000
  3. Average inventory at 6 turns = ₹1,20,00,000 ÷ 6 = ₹20,00,000
  4. 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).

Sell-through % = Units sold ÷ (Units sold + Units remaining) × 100

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)

Safety stock = (Max daily sales × Max lead time) − (Avg daily sales × Avg lead time)

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)

Safety stock = Z × σ(daily demand) × √(Lead time in days)
Service levelZ
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

SS = Z × √[(σd² × Avg LT) + (Avg demand² × σLT²)]

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

Reorder point = (Average daily demand × Lead time in days) + Safety stock

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.

EOQ = √(2 × D × S ÷ H)
  • 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 ₹

  1. D = 20 a day × 365 = 7,300 units
  2. S = ₹4,000 per order
  3. H = 25% × ₹400 unit cost = ₹100
  4. 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.

Track stock, ad spend and profit together

ScaleWin connects your Shopify store with Meta and Google ads so you can see daily profit by product and put budget behind the stock you need to move.

Try ScaleWin free →

Frequently asked questions

Is a higher inventory turnover ratio always better?

No. Higher turns free cash and cut storage costs, but very high turns often mean thin stock and frequent stockouts. For a D2C brand, a stockout wastes the ad spend that sent people to the product page. Aim for days on hand that sit comfortably above your lead time plus safety stock.

What does an inventory turnover ratio of 1.5 mean?

It means you sold and replaced your average stock 1.5 times in the period. If that period is a year, you hold about 243 days of stock (365 ÷ 1.5), which is slow for most D2C brands. If it is a quarter, it equals 6 turns a year, or about 61 days.

Can I calculate inventory turnover with revenue instead of COGS?

You should not. Revenue includes your markup, so the ratio comes out too high. At a 60% gross margin, a revenue-based ratio is 2.5 times higher than the correct COGS-based one. Use COGS and value inventory at cost so both numbers are on the same basis.

What if I only know my ending inventory?

Use it as your average inventory. Accounting courses accept this when only one balance is available, and the calculator above handles it if you leave the other field blank. The result is less accurate if stock rose or fell sharply during the period, so add the starting value when you can.

How do I find inventory turnover in Shopify?

Get COGS from your cost-per-item data or your accounts, and inventory value at cost from Shopify's inventory reports or your books for the start and end of the period. Report access depends on your plan. Enter these values in the calculator above to get turns, days on hand and the cash-freed figure.

What is the difference between safety stock and reorder point?

Safety stock is the extra buffer you keep for demand spikes or late shipments. The reorder point is the stock level that tells you to place a new order. It equals average daily demand times lead time, plus safety stock. So safety stock is one part of the reorder point.

How often should I recalculate safety stock and reorder points?

Review them at least monthly, and right away when something changes: a new supplier, a shift in freight times, a big sale event or a jump in ad spend. Fast-moving or seasonal SKUs need more frequent checks than steady sellers. Old reorder points cause both stockouts and overstock.

Does the calculator store my data?

No. Everything runs in your browser and nothing is stored on a server. If you want to keep or share your numbers, use Copy link, which saves your inputs in the URL, or Save as PDF to print a clean report.

Related free tools