Margin Looks Fine. So Why Is So Much Cash Tied Up in Stock?

Margin and inventory investment answer different questions

Gross margin percentage relates product gross profit to sales. Gross margin return on inventory investment, or GMROI, relates gross profit to average inventory held at cost. Oracle’s retail metric documentation uses gross margin and average inventory cost in that calculation. The article’s example reports a period ratio, not an annualised forecast or an industry benchmark.

Atlas supports the sales, gross-profit, margin and stock review; Core connects the resulting planning question with budget and intake assumptions. The relevant product claim is the ability to inspect those underlying measures in scope. This article does not assert a particular built-in GMROI report or an automatic stock-optimisation recommendation.

Put the numerator and denominator on the same basis

Agree the merchandise scope, trading period, cost valuation and treatment of returns before comparing categories. A closing stock snapshot is not automatically an average inventory measure. Seasonal receipts can make the difference important, particularly when a large delivery arrives just before the period ends.

Use a consistent method for the average, such as suitable weekly stock-at-cost snapshots over the selected period. The retailer must establish which observations are complete and comparable. Do not mix one category’s quarter of gross profit with another category’s annual average stock, or combine a retail-valued denominator with a cost-based measure without explaining it.

Two healthy margins can conceal very different returns

Consider an independent thirteen-week comparison. Knitwear sells $18,000 with $10,800 cost of goods sold, producing $7,200 gross profit and a 40% margin. Its average inventory at cost is $6,000. Outerwear sells $24,000 with $13,200 cost of goods sold, producing $10,800 gross profit and a 45% margin, while averaging $18,000 of stock at cost.

Knitwear’s period GMROI is 1.20: $7,200 divided by $6,000. Outerwear’s is 0.60: $10,800 divided by $18,000. Outerwear earns more gross profit and a higher margin percentage, but less gross profit per dollar of average inventory. The figures are worked USD assumptions, not a retailer’s reported results.

Read the ratio as a question about the stock path

The comparison does not prove outerwear is a bad category. Its seasonality, lead time, future demand or required size coverage may justify some of the investment. It does show why a buyer should examine the average stock balance rather than celebrate the 45% margin alone.

In Atlas, compare sales, gross profit, cover and stock within the agreed scope. Then inspect the receipts and range depth behind the average. A slow location, an early delivery or stock concentrated in weak sizes can create different responses. A category-level ratio should lead to those questions rather than replace their evidence.

Test a smaller investment without assuming unchanged demand

A sensitivity reduces outerwear’s average inventory assumption from $18,000 to $13,500 while holding gross profit at $10,800. The resulting period GMROI is 0.80. The lower denominator improves the ratio mathematically; it does not prove the same profit can be earned with less stock.

The $4,500 difference is a change in assumed average inventory investment, not a guaranteed cash release or saving. A commercially valid plan must show how the lower stock path preserves availability, timing and the relevant demand. Removing the best-selling sizes could improve a spreadsheet denominator while damaging the numerator in practice.

Bring the investment question into Core

Core’s MFP/WSSI connects sales, stock and intake across periods. Use it to test whether the category can achieve a more appropriate stock path through receipt timing, range depth or a different buying assumption. Existing orders remain commitments unless a supported, authorised change is confirmed.

The response need not be a blanket reduction. A targeted intake adjustment can be more useful than suppressing every option in a category that still has credible demand. Keep the approved baseline beside the scenario, identify which stock measure changes and give the commercial owner an explicit decision rather than a single better-looking ratio.

Review margin, investment and service together

For the worked example, the next question is why outerwear requires three times knitwear’s average stock investment while producing one and a half times its gross profit. The answer may involve the range, receipts or selling window; the ratio itself does not establish the cause. Check availability before treating lower depth as an improvement.

Use Atlas to keep the evidence comparable and Core to test the stock consequence of a response. Retain the period label and avoid mechanically annualising a seasonal result. A useful GMROI review connects an attractive margin with the investment needed to earn it, and leaves the retailer with a decision it can support at product and period level.

Common questions