How to Calculate Inventory Turnover
Inventory turnover measures how many times you sell and replace your stock during a period. To calculate inventory turnover, divide your cost of goods sold (COGS) by your average inventory:
Inventory Turnover = COGS ÷ Average Inventory
For example, $360,000 in annual COGS with $60,000 average inventory: $360,000 ÷ $60,000 = 6× turnover — meaning you sell through your stock six times per year, or roughly every 61 days.
Turnover alone doesn't tell the full story. Pair it with days of inventory (DSI) to see how long stock sits, and GMROI to see the gross profit earned per dollar of inventory investment.
Inventory Turnover Formulas
Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
Inventory Turnover = Annual COGS ÷ Average Inventory
DSI = 365 ÷ Inventory Turnover
GMROI = Gross Profit ÷ Average Inventory
= (Annual Revenue × Gross Margin %) ÷ Average Inventory
Use inventory values at cost, not retail price. COGS means the cost of the products sold during the period; it does not mean total sales revenue. Turnover and DSI describe speed, while GMROI combines inventory investment with gross profit.
How to Use This Calculator
- Enter Annual COGS for the year, or annualize a shorter period. Use the cost of the goods sold, not the amount customers paid.
- Enter Beginning Inventory and Ending Inventory at cost for the same period. Their average represents the inventory investment used in the ratio.
- Enter Avg Inventory Value if you already have an average inventory figure; use the same valuation basis and period as COGS.
- Enter Annual Revenue and Gross Margin % so the calculator can estimate gross profit and GMROI. Check that your gross margin matches the revenue and COGS period.
- Enter Warehouse Cost % to assess the annual cost of holding inventory as a percentage of its value.
- Review turnover, DSI, GMROI, benchmarks, and improvement scenarios. Change an input to see how a different inventory level or operating assumption affects the results.
For reliable comparisons, use a full year of data or annualize a shorter period consistently. Seasonal stores should also compare similar seasons, since a single beginning-and-ending snapshot can miss large inventory swings.
Step-by-Step Example
A Shopify store selling skincare sets wants to check whether its stock is generating enough return. It records $360,000 in annual COGS, $70,000 in beginning inventory, $50,000 in ending inventory, $600,000 in revenue, a 40% gross margin, and a 22% warehouse cost rate.
| Calculation | Working | Result |
|---|---|---|
| Average inventory | ($70,000 + $50,000) ÷ 2 | $60,000 |
| Inventory turnover | $360,000 ÷ $60,000 | 6× |
| DSI | 365 ÷ 6 | 60.8 days |
| Gross profit | $600,000 × 0.40 | $240,000 |
| GMROI | $240,000 ÷ $60,000 | $4.00 per $1 invested |
| Estimated annual warehouse cost | $60,000 × 0.22 | $13,200 |
A scenario that reduces average inventory by 8%, while holding annual sales and COGS constant, lowers the average stock value to $55,200. Turnover becomes 6.52× ($360,000 ÷ $55,200), DSI becomes 56.0 days (365 ÷ 6.52), and GMROI rises to $4.35 ($240,000 ÷ $55,200). The improvement frees $4,800 in cash, but only works if the lower stock level does not cause missed sales or stockouts.
Interpreting Turnover, DSI, and GMROI Together
A high turnover ratio is not automatically a sign of good inventory management. It can mean products sell efficiently, but it can also mean stock is too lean to meet demand. A low ratio may indicate excess stock, slow-moving products, or intentional inventory held for seasonal peaks.
| Product type | Indicative annual turnover |
|---|---|
| Grocery and food | 12–20× |
| Fashion and apparel | 4–6× |
| Electronics | 5–8× |
| Beauty and cosmetics | 4–7× |
| General retail | 4–6× |
| Jewelry | 1–3× |
These ranges are starting points, not universal targets: product lifecycles, supplier lead times, seasonality, and margins all affect the right level. The calculator compares results with 10 industry benchmarks, while the U.S. Census Bureau’s retail data provides broader sales and inventory context—not a direct target for an individual Shopify store.
For a product-level diagnosis, use the ABC Inventory Analysis Tool to identify which SKUs contribute most to sales and inventory investment. If slow sellers are tying up cash, the Dead Stock Identifier can help compare markdown, liquidation, and reinvestment options. The Small Business Administration’s finance guidance also explains why tracking financial records and cash flow matters when managing business resources.
6 Tips to Improve Inventory Turnover
- Test a 10% reduction in reorder quantities for a slow-moving SKU. Smaller, more frequent orders can reduce average stock, but check supplier minimums and shipping costs first.
- Review the bottom 20% of SKUs by sales each month. Mark down, bundle, or discontinue products that occupy space without earning enough gross profit.
- Set a 30-day aging alert in your inventory workflow. Promote products before they become dead stock rather than waiting until a large clearance is unavoidable.
- Compare a 14-day supplier lead time with a 28-day lead time. Ask suppliers about shorter or split deliveries; shorter lead times may let you replenish with less safety stock.
- Run an ABC classification quarterly. Give A-items tighter reorder monitoring, then review C-items for excess stock or weak returns.
- Test a 5% safety-stock reduction on a predictable, fast-replenishing product. Check stockout rates and lost sales before applying the change across your catalog.
- Compare turnover with gross margin before discounting. A promotion can speed up stock movement while reducing gross profit; track GMROI to see whether the faster sale still earns an adequate return.
Frequently Asked Questions
What is inventory turnover and how is it calculated?
Inventory turnover measures how many times you sell and replace inventory per year. Calculate it by dividing COGS by average inventory, where average inventory is beginning inventory plus ending inventory divided by two. A higher result can indicate faster movement, but compare it with your industry and stock availability before treating it as better.
What is a good inventory turnover ratio for e-commerce?
A healthy ratio depends on the products you sell: grocery and food often turn over 12–20×, while jewelry may turn over 1–3×. For many Shopify stores, 4–8× is a useful reference range; compare against your specific category because seasonality and replenishment lead times change what is practical.
What is GMROI and why does it matter?
GMROI, or Gross Margin Return on Inventory Investment, measures gross profit earned per dollar invested in average inventory. A result of $3.50 means each inventory dollar generated $3.50 in gross profit; it combines margin and turnover, so a fast-selling product with weak margins may still have a poor return.
How do I improve inventory turnover?
Start by identifying slow-moving SKUs, then test smaller reorder quantities, better demand forecasts, and earlier promotions for aging stock. Shorter supplier lead times and ABC analysis can help you reduce excess inventory while protecting availability for your best sellers.
What is days of inventory (DSI)?
Days Sales of Inventory (DSI) estimates the average number of days inventory takes to sell, using 365 divided by inventory turnover. A lower DSI means stock moves faster, but compare it with supplier lead times and payment terms: selling stock after supplier invoices come due can create a cash-flow gap.
About This Calculator
The Inventory Turnover Calculator was built by Luis Dev Studio for Shopify merchants who want to assess stock speed, inventory returns, and cash tied up in products. For help applying the results to your store, contact us.
Updated by Luis Gonzalez · Sep 28, 2026