Blog · Finance metrics and formulas · Distribution
The return on inventory ratio compares gross profit with average inventory at cost. Work it by product category, prove the company total and distinguish gross margin return from turnover, markup and overall investment returns.
The return on inventory ratio measures gross profit earned per dollar of average inventory at cost. On this gross-margin basis, $630,000 of annual gross profit divided by $450,000 of average inventory gives a ratio of 1.40. It compares the earning contribution of stock investment before operating expenses, financing and taxes.
Here, return means gross margin return on inventory investment, often shortened to GMROI:
Return on inventory ratio = Gross profit / Average inventory at cost
Gross profit = Net sales − Cost of goods sold
Simple average inventory = (Beginning inventory + Ending inventory) / 2
The IRS's gross-profit calculation starts with receipts less returns and allowances, then subtracts cost of goods sold. Use that same basic distinction in a management report: sales after credits, less the cost attached to those sales. The detailed gross profit margin guide covers the sales denominator; this ratio instead uses inventory investment.
Specify the inventory basis. For purchased merchandise, IRS inventory guidance describes cost as invoice price less appropriate discounts plus transportation or other acquisition charges, subject to applicable capitalization rules. Your management calculation should use the company's consistently defined inventory cost, with its reserve treatment identified.
A ratio of 1.40 is $1.40 of gross profit for each dollar of average inventory. Do not subtract one and call the result an investment gain. Inventory is replenished and sold throughout the period, and the numerator is gross profit rather than net cash proceeds from selling an investment.
Use a sales or margin export for the reporting period and inventory snapshots at its boundaries. Keep item IDs so that a category reassignment does not quietly move sales into one category and inventory into another.
| File | Columns to retain | Required check |
|---|---|---|
| Sales and margin export | Transaction date, item, category, net sales, COGS | Returns and their cost reversals are included once |
| Inventory snapshots | Snapshot date, item, category, location, inventory cost | Same sites, ownership scope and cost basis on both dates |
| Category mapping | Item, reporting category, effective date | Each item has one category for this comparison |
| Ledger summary | Period, net sales, COGS, inventory accounts | Export totals reconcile before category ranking |
Use beginning and ending inventory only when they represent the period reasonably. A seasonal distributor can instead use regularly spaced daily or monthly balances. State the averaging method and number of observations, and apply it to every category. Two quiet endpoints can conceal stock held through the busiest part of the year.
An illustrative US distributor compares January 1 through December 31, 2025. It uses inventory at cost before reserves for this operating comparison, with the same basis in every category. Beginning and ending balances provide a simple average.
| Category | Net sales (USD) | COGS (USD) | Beginning inventory (USD) | Ending inventory (USD) |
|---|---|---|---|---|
| Industrial supplies | 900,000 | 630,000 | 150,000 | 210,000 |
| Safety supplies | 600,000 | 360,000 | 100,000 | 140,000 |
| Specialty parts | 300,000 | 180,000 | 120,000 | 180,000 |
| Total | 1,800,000 | 1,170,000 | 370,000 | 530,000 |
Calculate average inventory first, then gross profit and the return:
| Category | Average inventory calculation (USD) | Gross profit calculation (USD) | Return calculation | Return |
|---|---|---|---|---|
| Industrial supplies | (150,000 + 210,000) / 2 = 180,000 | 900,000 − 630,000 = 270,000 | 270,000 / 180,000 | 1.50 |
| Safety supplies | (100,000 + 140,000) / 2 = 120,000 | 600,000 − 360,000 = 240,000 | 240,000 / 120,000 | 2.00 |
| Specialty parts | (120,000 + 180,000) / 2 = 150,000 | 300,000 − 180,000 = 120,000 | 120,000 / 150,000 | 0.80 |
| Total | (370,000 + 530,000) / 2 = 450,000 | 1,800,000 − 1,170,000 = 630,000 | 630,000 / 450,000 | 1.40 |
Ratios are displayed to two decimal places. With net sales in B, COGS in C, beginning inventory in D and ending inventory in E, use:
F2 =(D2+E2)/2
G2 =B2-C2
H2 =IF(F2>0,G2/F2,NA())
Fill the formulas down. For the company ratio, divide total gross profit by total average inventory:
=SUM(G2:G4)/SUM(F2:F4)
Safety supplies earn the highest gross profit per inventory dollar. Specialty parts earn the least, despite having the same gross profit percentage as safety supplies. The difference deserves a stock-depth and service review before any buying decision.
The company result must equal the inventory-weighted average of category returns:
Company return = Sum of (Category return × Category average inventory) / Total average inventory
On these rows, the numerator is 1.50 × $180,000 + 2.00 × $120,000 + 0.80 × $150,000 = $630,000. Divide by $450,000 to recover 1.40. Use unrounded ratios when reproducing this check on other files.
A second identity explains the result commercially:
Return on inventory = Gross profit margin × Net sales / Average inventory at cost
Here, gross profit margin is $630,000 / $1,800,000 = 35%, and sales divided by average inventory is $1,800,000 / $450,000 = 4.00. Their product is 1.40.
That sales-based multiple is not inventory turnover, which uses COGS. Turnover on these rows is $1,170,000 / $450,000 = 2.60. Keep the definitions visible when comparing inventory ratios; the inventory-to-sales ratio owns a different stock-to-sales comparison.
The specialty category may contain essential parts that protect larger customer relationships. A low return identifies a question about inventory depth; it does not establish that the category should be discontinued.
Test a specific change. If specialty parts ended with $120,000 instead of $180,000, while beginning inventory and annual gross profit stayed unchanged, average inventory would be $120,000 and its ratio would become 1.00. Company average inventory would fall from $450,000 to $420,000, and company return would become $630,000 / $420,000 = 1.50.
That is a scenario with unchanged sales and service, not a promise that less inventory preserves them. Procurement should assess lead times and availability; sales should identify customer commitments; finance should check gross-profit treatment and period comparability.
Bring your sales and COGS export with matching inventory snapshot files. Covirage maps the columns, its tools compute and check category returns and total reconciliations, and the external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for distributors for the business context behind those stock and margin comparisons.
No. Inventory turnover divides cost of goods sold by average inventory at cost. Gross margin return divides gross profit by that average inventory. A category can turn quickly but generate a weak return if its gross profit per sale is small.
Use the company's margin structure, service requirements and comparable periods to set a target. A higher gross-margin return means more gross profit per dollar of inventory, but it does not prove higher net profit or adequate availability for customers.
Use inventory at cost for this definition. A retail-value denominator answers a different question and will not reconcile to the cost-based formulas here. Keep the same cost and reserve treatment across categories and reporting periods.
Yes, if the category's gross profit is negative and average inventory is positive. Investigate selling prices, returns and cost assignments. A zero or negative inventory denominator instead makes the ratio unsuitable for interpretation and should be flagged rather than treated as a useful return.