E-commerce Inventory Turnover Calculator
Calculate your inventory turnover ratio and days to sell inventory. Enter COGS and average inventory value to benchmark performance.
Calculate Gross Margin Return on Inventory Investment (GMROI) to measure inventory profitability. Target above 200% for healthy performance.
| Scenario | Margin % | Turnover | GMROI | vs Current |
|---|---|---|---|---|
| Current | 37.5% | 4.17x | 250% | - |
| +5% Margin | 42.5% | 4.17x | 177% | +-73% |
| +1 Turn | 37.5% | 5.17x | 194% | +-56% |
| +5% Margin & +1 Turn | 42.5% | 5.17x | 220% | +-30% |
| -20% Inventory | 37.5% | 5.21x | 313% | +63% |
| Industry | Avg Margin | Avg Turnover | Avg GMROI |
|---|---|---|---|
| Apparel & Fashion | 55% | 4x | 220% |
| Electronics | 28% | 8x | 224% |
| Beauty & Personal Care | 62% | 6x | 372% |
| Home & Garden | 45% | 5x | 225% |
| Grocery & Consumables | 25% | 14x | 350% |
| Toys & Games | 42% | 5.5x | 231% |
| Lever | Current | Needed | Change Required |
|---|---|---|---|
| Reduce Inventory (keep margin & turns) | $120,000.00 | $120,000.00 | Already met |
| Increase Margin (keep inventory & turns) | 37.5% | 60% | +22.5 pp |
| Increase Turnover (keep margin & inventory) | 4.17x | 6.67x | +2.5 turns |
GMROI (Gross Margin Return on Inventory Investment) measures how much gross profit you earn for every dollar invested in inventory. It combines profitability and inventory efficiency into a single powerful metric that reveals whether your inventory investment is generating adequate returns.
A GMROI of 200% means you earn $2 in gross margin for every $1 of average inventory cost. This is generally considered the minimum healthy threshold for e-commerce. Top-performing businesses achieve GMROI of 300โ500% or higher.
This calculator computes GMROI from your gross margin and average inventory cost, helping you evaluate whether your inventory investment is productive. It is especially useful for comparing performance across product categories, seasons, or channels.
Revenue alone does not tell you if your inventory investment is profitable. GMROI combines margin and turns into one metric that reveals whether each dollar in inventory is working hard enough. Use it to identify your best and worst inventory investments.
GMROI = (Gross Margin / Average Inventory Cost) ร 100
Gross Margin = Revenue โ COGS
Alternatively: GMROI = Gross Margin % ร Inventory TurnoverResult: GMROI: 250%
With $300,000 in gross margin and $120,000 average inventory cost: GMROI = (300,000 / 120,000) ร 100 = 250%. For every dollar invested in inventory, you earn $2.50 in gross margin. This is above the 200% healthy threshold.
Grocery and consumables: 300โ500% (low margins, very high turns). Electronics: 150โ300% (moderate margins and turns). Apparel: 200โ400% (higher margins but seasonal). Home goods: 200โ350% (moderate margins and turns). Your category mix determines your overall GMROI potential.
Allocate inventory investment proportionally to GMROI by category. If electronics has a GMROI of 180% and beauty has 350%, consider shifting investment toward beauty (if market size supports it). This portfolio optimization approach maximizes total return on inventory investment.
Since GMROI = margin ร turns, you can achieve the same GMROI with different strategies. A luxury item at 60% margin and 4 turns = GMROI of 240%. A commodity at 15% margin and 16 turns = GMROI of 240%. Both are equally productive uses of inventory capital.
Last updated:
Above 200% is generally healthy, meaning you earn $2 for every $1 in inventory. Above 300% is strong, and above 400% is excellent. Below 150% suggests either margins or turnover need improvement. The benchmark varies by category.
Gross margin tells you how profitable your sales are. GMROI tells you how profitable your INVENTORY INVESTMENT is. A product with 50% margin but very slow turnover can have poor GMROI, while a 20% margin product that turns quickly may have excellent GMROI.
Absolutely. Before ordering a new product, estimate its expected margin and turnover to project GMROI. Compare against your portfolio average. Only add products that will maintain or improve your overall GMROI, unless they serve a strategic purpose.
Two levers: increase gross margin (raise prices, reduce COGS, cut fees) or increase inventory turnover (better forecasting, smaller orders, faster shipping). Often improving turnover is easier and has a larger impact than squeezing additional margin.
Use cost basis (what you paid for the inventory) for GMROI calculations. This gives you the return on your actual investment. Using retail value would understate your GMROI and make comparisons less meaningful.
Monthly is ideal for dynamic e-commerce businesses, quarterly at minimum. Calculate both total business GMROI and category-level GMROI. Track trends over time โ declining GMROI even with growing revenue signals deteriorating inventory productivity.
Calculate your inventory turnover ratio and days to sell inventory. Enter COGS and average inventory value to benchmark performance.
Calculate per-SKU profit by subtracting COGS, marketplace fees, shipping, advertising, and return costs from revenue. Build a full product P&L.