Publish Date :
Retail Analytics: The Metrics That Show Inventory Risk Early
A knit sells through 70% of its stock, yet only two weeks of cover remain. A shirt has plenty of stock, but its sales are slowing. Retail analytics becomes useful when those numbers are read together, before the next intake or buying decision.
INSIDE MERCHMIX / ATLAS
Strong sales.
Read the stock too.
Compare three apparel styles across the same four weeks. Move from exact report figures to stock bars, sales trends and a cover indicator.
Atlas report illustration with a consistent apparel planning example.
Apparel stock signals
Central store / four completed weeks / units
One store, four completed weeks and unit measures. The report compares three apparel styles in the same scope.
THE KEY IDEA
Read the signals together: the knit’s 70% sell-through leaves two weeks of cover, while the shirt’s 160 units represent twenty weeks at its latest rate. Atlas helps keep stock, sales direction and margin in the same decision.
Strong sell-through can hide a shortage risk
Everyday Knit has sold seventy of the hundred units received over four weeks. Thirty remain. Its 70% sell-through looks encouraging, but recent sales are fifteen a week, leaving only two weeks of cover. If new supply takes three weeks, the planner needs to investigate the timing gap.
Merchmix is a connected platform for retail planning and operations. Atlas is its reporting workspace, where teams can bring sales, stock and margin into the same trading discussion. The aim is to identify the inventory question early enough to act on it, rather than wait for the sales total to fall.
Define sell-through before comparing the percentages
Sell-through is units sold divided by units received for the selected scope and period, multiplied by one hundred. In the knit example, seventy divided by one hundred gives 70%. Cotton Shirt sells forty of two hundred received units, giving 20%. Straight Denim sells sixty of one hundred and twenty, giving 50%.
These examples assume the opening available quantity is the received quantity, with no later intake, returns or transfers during the four weeks. Real reports need a consistent denominator and movement basis. A high percentage can mean a strong selling result, but it can also mean little stock remains.
AN APPAREL PLANNING SCENARIO
Seventy per cent sold, but only two weeks left
Everyday Knit receives 100 units and sells 70 across four weeks, leaving 30. At the latest fifteen weekly sales, that is two weeks of cover. Its $70 selling price includes a 30% discount from $100; at a $40 unit cost, gross margin is 42.9%. Check supply timing and price context together before deciding on another intake.
Illustrative situation, not a customer case study.Put stock on hand beside the sales result
Stock on hand is the quantity held at the reporting point. The knit has thirty units, the shirt one hundred and sixty, and denim sixty. In this simplified range, received units less sold units gives the closing stock for each style.
The table view makes the contrast visible: knit sell-through is high and stock is low, while the shirt holds most of its original quantity. Before treating that stock as useful supply, check its location, size availability and the relevant inventory records. A total can conceal missing sizes or stock held in the wrong place.
Use a recent sales rate to calculate cover
Rate of sale is the number of units sold over a stated time interval. For the latest completed week, the knit sells fifteen, the shirt eight and denim fifteen. Weeks of cover is stock on hand divided by weekly unit sales, assuming that rate continues.
Thirty knits divided by fifteen gives two weeks. One hundred and sixty shirts divided by eight gives twenty weeks; sixty denim units divided by fifteen gives four. The shirt’s four-week average is ten, but its latest rate is eight. Using the average would give sixteen weeks and hide part of the recent slowdown.
Check the sales direction and the price behind it
Knit sales across the four weeks are fifteen, twenty, twenty and fifteen. The shirt moves from twelve to eleven, nine and eight; denim holds at fifteen each week. A single current total misses those different patterns. Against an assumed latest-week knit plan of twenty, fifteen actual sales represent 75% of plan.
The knit also sells at $70 after a 30% discount from $100. With a $40 unit cost, gross profit is $30 per unit and gross margin is $30 divided by $70, or 42.9%. The full-price gross margin would be 60%. A strong sell-through result therefore needs its price and margin context; it does not establish that demand will hold at full price.
FROM THE SIGNAL TO THE MERCHMIX DECISION
What to check before the next action
| What you see | Where to look in Merchmix | The decision to review |
|---|---|---|
| Knit: 70% sell-through / 2 weeks cover | Atlas / scoped sales and stock report | Check incoming supply and useful sizes against the assumed three-week lead time. |
| Shirt: 160 units / latest sales 8 per week | Atlas / stock table and weekly sales line | Investigate twenty weeks of cover while weekly sales ease from twelve to eight. |
| Knit: $70 price / 42.9% gross margin | Atlas / sales and margin context | Assess the 30% discount before treating sell-through as full-price demand. |
Read the signals as combinations
The knit combines 70% sell-through, two weeks of cover and a discounted selling price. Check confirmed incoming supply, useful sizes and the assumed three-week lead time before deciding whether to replenish. Discount-led sales alone are not a reason to repeat the same order.
The shirt combines twenty weeks of cover with slowing sales. Check the remaining selling window and incoming commitments before adding stock. Denim’s four weeks of cover and steady fifteen-unit weekly sales form a different pattern; compare that position with its own supply timing rather than apply the knit’s response across the range.
Use Atlas views to keep the comparison visible
The Atlas report layout provides runtime filters and table, bar, line and KPI views. With the relevant inventory measures configured, use a table for exact quantities, bars for the stock comparison, a line chart for weekly sales and an indicator for a scoped measure such as cover. Keep the location, period and unit basis consistent as the view changes.
A saved report can be reused in a dashboard so the trading discussion starts from the same scope. In the accompanying illustration, the knit’s sell-through, stock, cover and gross margin sit together. The charts and report layouts follow Atlas; the apparel calculations explain the inventory question rather than reproduce private operational records.
Turn a report signal into a specific stock question
For the knit, the question is whether suitable supply can arrive before two weeks of stock are exhausted at the assumed rate. For the shirt, it is why sales are slowing while one hundred and sixty units remain, and whether more stock is already due. Those questions require the underlying order, stock and product evidence.
Atlas supplies the reporting context. Take the chosen question into the appropriate planning or operational workflow, confirm the current records and assign the next decision. Then compare the refreshed position with the earlier signal, so the team can see whether cover, availability or the selling assumption actually changed.
BEFORE TURNING THE SIGNAL INTO A STOCK DECISION
- Which product, store and period does the signal describe?
- Are sales and stock measures on a consistent basis?
- Does availability explain part of the performance?
- Are incoming receipts and source coverage visible?
- Who owns the investigation and its next confirmation?
A CLEARER NEXT STEP
Common questions
How are sell-through and weeks of cover different?
Sell-through describes the proportion sold against the received quantity for a defined scope and period. Cover estimates how long the remaining stock lasts at a stated weekly sales rate. The knit has 70% sell-through and two weeks of cover, so both measures matter.
Which sales rate should the cover calculation use?
State the basis and compare it with recent trading. The shirt averages ten weekly sales across four weeks, but its latest week is eight. Its 160 units give sixteen weeks at the average or twenty at the latest rate. The difference exposes a slowdown rather than a single fixed answer.
Does strong sell-through prove a product needs another order?
No. Check remaining stock, size availability, incoming supply, lead time and the price that supported sales. The knit’s 70% sell-through includes an assumed 30% discount, so the margin and demand basis belong in the decision.
THE COMBINED SIGNAL / ATLAS
70% sold.
Two weeks left.
The knit’s sell-through, remaining stock, recent sales and margin describe one position. Keep the figures together before choosing a replenishment or buying response.
- 01Connect sell-through and cover
Seventy of one hundred sold; thirty remain at fifteen weekly sales.
- 02Check the selling basis
The $70 price includes a 30% discount; gross margin is 42.9%.
- 03Check supply timing
Compare two weeks of cover with the assumed three-week lead time.
Apparel risk dashboard
Central store / four completed weeks / units
One store, four completed weeks and unit measures. The report compares three apparel styles in the same scope.
FROM RELATED METRICS TO A CLEAR STOCK QUESTION
See the pattern.
Ask the next question.
Read the signals together: the knit’s 70% sell-through leaves two weeks of cover, while the shirt’s 160 units represent twenty weeks at its latest rate. Atlas helps keep stock, sales direction and margin in the same decision.