merchmix

Publish Date :

Which Stores Earn Their Stock?

A store’s sales total does not show how productively it uses stock investment. Atlas supports the sales, gross-profit and inventory comparison, while Core Plus supports the current location response. Compare like-for-like capital use before deciding where the next unit belongs.

A young planner comparing store floor sketches and stock-investment notes.
Editorial illustration of the retail planning decision.

THE MERCHMIX DECISION / Atlas + Core Plus

More sales do not necessarily mean better stock productivity.

Compare historical investment, then validate the current location decision.

Independent worked retail example. Quantities are planning assumptions, with financial amounts shown in US dollars. Proposed changes remain subject to review.

merchmix.Atlas + Core Plus / commercial review
Establish the basisCurrent assumptions

More sales do not necessarily mean better stock productivity.

Store A / thirteen weeks1.50GP per average stock dollar

$24,000 sales / $12,000 GP

$8,000 average stock at cost
Store B / thirteen weeks0.60GP per average stock dollar

$36,000 sales / $14,400 GP

$24,000 average stock at cost
Historical investment and current units retain separate basesB leads sales. A leads this stock ratio.

A thirty-unit proposal would give sixty and 120 locally, or six and eight weeks. Historical ratios do not establish future demand, suitable sizes or a cash release.

Read the same period

B leads on sales, but holds more average investment.

THE KEY IDEA

Compare historical investment, then validate the current location decision.

The biggest store result can conceal the biggest commitment

A high-revenue location may need substantially more inventory to produce that result. Another can earn less gross profit in total while using each stock dollar more productively. Both observations matter before allocation decisions rely on a simple league table of sales.

Atlas supports scoped sales, profitability and stock analysis. Define the product category, period and stock-cost basis consistently. Compare investment productivity over the completed period separately from the current stock decision. These defined calculations do not imply that every ratio is supplied in a ready-made report.

Planning and product referencesMerchmix Atlas: product scope Merchmix Core Plus: product scope

Use average stock at cost for the period comparison

For a completed thirteen-week window, A records $24,000 sales, $12,000 product gross profit and $8,000 average stock at cost. B records $36,000 sales, $14,400 gross profit and $24,000 average stock at cost. The averages refer to the same period as the sales and profit.

B leads on sales and gross-profit dollars. A’s margin is 50%, compared with B’s 40%. Neither margin percentage alone describes the investment behind it. Keep average stock distinguishable from a closing snapshot; a single count at the period end may not represent what the store carried while earning the result.

Read the return against the inventory actually employed

A’s period gross profit divided by average stock at cost is 1.50. B’s is 0.60. Those ratios are dollars of product gross profit per average inventory dollar over the stated thirteen weeks, not annual returns or a measure of whole-store net profit.

Rent, labour, other expenses, ownership and customer role remain outside this comparison. A stronger stock ratio can prompt an investigation without proving that the store should automatically receive more. A location may be highly productive because it was under-supplied, or because its range and selling conditions genuinely differ.

THE FIGURES BEHIND THE DECISION

More sales do not necessarily mean better stock productivity. Compare historical investment, then validate the current location decision.
Store / 13 weeksSalesProduct GPAverage stock at costGP / stock dollar
A$24,000$12,000$8,0001.50
B$36,000$14,400$24,0000.60

Period ratios: $12,000 ÷ $8,000 = 1.50; $14,400 ÷ $24,000 = 0.60. Separate current move: 30/150 becomes 60/120, still 180 units.

Keep the current stock response separate from hindsight

A separate current snapshot has A holding thirty units at an assumed ten weekly sales, or three weeks of cover. B holds 150 at fifteen per week, or ten weeks. A possible thirty-unit move would give A sixty and B 120, six and eight weeks respectively.

The network still owns 180 units. This snapshot is distinct from the historical average-stock values and does not imply the same constant rate throughout the past thirteen weeks. The transfer proposal needs current matching sizes, a timely route and a source position that can release them.

Do not silently substitute current stock for the historical average. The 180 current units concern a separate operational snapshot, while the $8,000 and $24,000 averages describe investment across thirteen weeks. The two views inform different questions and must retain their own timestamps and product-cost bases.

THE PLANNING REFERENCERead the allocation and replenishment guide

Do not use the ratio as an automatic allocation rule

A store with strong historical productivity can still lack space or demand for the next option. B may serve a broader customer role or hold stock for a different purpose. Compare relevant range, presentation, fulfilment and availability evidence before treating the ratio as a ranking of managerial quality.

Core Plus supports the local allocation, size and capacity context. The proposed thirty-unit move is a review example, not an execution or a cash release. Moving existing stock changes location; it does not reduce inventory investment at business level by itself.

Choose the improvement question for each store

For A, investigate whether the current availability and sizes support its customer opportunity. For B, investigate whether its depth and stock role justify the larger investment. A blanket instruction to raise A and cut B can hide both questions beneath an attractive ratio.

Atlas supplies the scoped comparison, and Core Plus supports an accepted stock response. Retain the assumptions and review the subsequent trading outcome. A projected cover calculation is not proof that the transferred units will sell or that a stronger historical ratio will persist.

Review what success would look like after an accepted move: usable availability at the destination, suitable source stock remaining and actual selling in the relevant period. A transfer can improve one indicator while creating another shortage if the retained source sizes were not checked. The historical ratio does not remove that operational responsibility.

SignalMerchmix workspaceDecision to review
Sales rankings dominate the reviewAtlas / store analysisCompare GP and average stock on the same period.
One store appears under-suppliedCore Plus / local responseInspect current sizes, source and timing.
A transfer is proposedCore Plus / reviewKeep owned inventory and actual execution distinct.

Allocate to an evidenced next use of stock

The worked historical comparison shows A at 1.50 and B at 0.60 for the same thirteen-week measure. The separate current proposal moves thirty units only if its size, timing, capacity and authority checks hold. No live store allocation is changed by the illustration.

Merchmix connects store performance with the stock decision it can inform. Use sales, profit and average inventory together, then return to the current customer opportunity before acting. The useful question is which store can justify the next unit, not which one owns the most impressive headline.

BEFORE THE NEXT DECISION

  • Analyst

    Validate comparable scope and average-stock basis.

  • Store owner

    Explain capacity and local customer role.

  • Allocation owner

    Approve only a supported current response.

Common questions

Does B perform best because it sells more?

It leads on sales and GP dollars, but uses more average inventory; other operating context still matters.

Are 1.50 and 0.60 annual returns?

No. They describe the stated thirteen-week product-GP-to-average-stock comparison.

Is average stock the same as closing stock?

No. A period average and a point-in-time balance answer different questions.

Does the transfer release cash?

Not by itself. The network retains 180 owned units.

Can the ratio approve an allocation?

No. Current demand, sizes, capacity, timing and authority still need review.

atlas

Compare GP and average stock on the same period.

Explore
core plus

Inspect current sizes, source and timing.

Explore

Continue reading: Margin and stock investment

Read the retail planning glossary

FROM THE ARTICLE TO YOUR OWN RETAIL PLAN

Review the decision.
See the workflow.

Bring your planning questions to a demo, or explore a proof of concept on your own data.

Book a demo Explore the proof of concept