James Allman | JA Technology Solutions LLC
GMROI & Inventory Turns Calculator
Calculate GMROI, inventory turns, days of supply, and sell-through from sales, margin, and average inventory.
GMROI & Inventory Turns Calculator
Enter annual sales, cost of goods sold or a gross margin percentage, and average inventory at cost to see GMROI, inventory turns, days of supply, and gross margin dollars. A one-line interpretation puts the GMROI figure in context using commonly cited bands, and a comparison table shows the same sales and margin at 20% more and 20% less inventory so the leverage is visible. A bonus section calculates sell-through from units sold and received, and the results export to CSV. Runs entirely in your browser.
Learn more ↓
Loading interactive explorer...
What GMROI Actually Measures
GMROI (gross margin return on inventory investment) answers a question margin percent cannot: for every dollar tied up in inventory, how many gross margin dollars come back over the period? It divides gross margin dollars by average inventory at cost, so a category earning $576,000 of margin on $180,000 of average inventory returns $3.20 per inventory dollar. The figure matters because inventory is capital. Two categories can run the same margin rate while one ties up triple the inventory to do it, and GMROI is the number that exposes the difference. The interpretation bands quoted in this calculator (below 1.0 giving back less than a dollar per dollar invested, 2.0 to 3.0 commonly cited as healthy for grocery) are rules of thumb that vary by segment, so treat them as orientation, not verdicts.
Turns and GMROI Tell Different Stories
Inventory turns measure speed: how many times the average inventory sells through in a period. GMROI measures productivity: speed multiplied by margin. A water category might turn 25 times at a thin margin while a spice set turns 3 times at a rich one, and both can post the same GMROI by different routes. That is why the two metrics belong side by side. Fast turns with weak GMROI point at margin problems; rich margin with weak GMROI points at bloated inventory, which is where the days-of-supply figure and the plus-or-minus 20% comparison table in this calculator earn their keep. For the replenishment decisions that actually move average inventory, the EOQ Calculator finds the order quantity trade-off and the ABC Analysis Tool shows which SKUs deserve the attention first. The Margin & Markup Calculator covers the rate math feeding the GM% input.
From One Calculation to a Standing Report
One GMROI number describes one category for one period. The useful version is a grid: GMROI and turns by category, store, and vendor, refreshed weekly from POS sales and inventory valuations, with the outliers flagged. I build exactly that kind of reporting against retail and merchandising systems. See custom reporting or grocery and retail services.
All tools run entirely in your browser. Your data never leaves your machine.