merchmix

Publish Date :

Discount Rate Creep: Spotting It Before the Half-Year Results

Rising sales can hide a falling realised price against ticket. Merchmix Atlas supports the weekly sales and margin comparison, while Core connects the emerging pattern with forward price and intake assumptions. Use a consistent discount definition and weighted totals before deciding what needs to change.

A young fashion analyst reviewing weekly realised prices and garment price tags.
Editorial illustration of the retail planning decision.

THE MERCHMIX DECISION / Atlas + Core

Sales rise. What happened to the price?

Read the weighted rate and its cause before changing the next commitment.

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

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

Sales rise. What happened to the price?

Week 1
4%100 units / $9,600 net
Week 2
8%150 units / $13,800 net
Week 3
14%200 units / $17,200 net
WeekRealised priceProduct GPMargin
Week 1$96$5,60058.3%
Week 2$92$7,80056.5%
Week 3$86$9,20053.5%
Ticket value$45,000
Net sales$40,600
Weighted discount9.8%
Original ticket denominator / not net-sales denominatorRising volume can conceal price creep

Combined reduction is $4,400 on $45,000 ticket value, or 9.8%. Inspect planned offers and mix before changing the forward buy.

Keep the ticket basis constant

The common ticket price is $100 per sold unit.

THE KEY IDEA

Read the weighted rate and its cause before changing the next commitment.

A strong sales total can conceal a weaker price mix

More units can lift revenue and gross profit even while a larger share of ticket value is given away. A team looking only at growth may miss the change until the period closes. The useful early signal is the relationship between unit volume, net price and goods margin.

Atlas supports scoped sales, profitability and merchandise analysis. Choose comparable products, stores and channels before interpreting the trend. A change in category or channel mix can explain part of a rate movement without any individual offer becoming deeper, so the headline percentage should begin the investigation rather than finish it.

Planning and product referencesMerchmix Atlas: product scope Merchmix Core: product scope Retail metric reference: markdown amounts and denominators

Define exactly what the discount rate means

This article uses original ticket value of sold units less realised selling value, divided by that original ticket value. That differs from discount divided by net sales. Name the denominator so readers can compare periods without confusing two valid but different measures.

The example assumes a common $100 ticket and excludes returns, tax and other adjustments. A real report needs an agreed basis for those items and for stacked reductions. Atlas’s supported calculation and reporting scope should be confirmed; this article does not claim that an identically named metric is preconfigured.

Read three weeks of volume and realised price

Week one sells a hundred units for $9,600 against $10,000 ticket value, a 4% discount rate. Week two sells 150 for $13,800 against $15,000, or 8%. Week three sells 200 for $17,200 against $20,000, or 14%.

Unit sales and net revenue rise each week, but average realised prices fall from $96 to $92 and $86. The same product and ticket assumptions isolate the price movement here. They do not establish whether the cause is a planned promotion, an exit decision, offer stacking or another commercial change.

THE FIGURES BEHIND THE DECISION

Sales rise. What happened to the price? Read the weighted rate and its cause before changing the next commitment.
WeekUnitsTicket valueNet salesDiscount rate
One100$10,000$9,6004%
Two150$15,000$13,8008%
Three200$20,000$17,20014%
Combined450$45,000$40,6009.8%

Weighted discount = ($45,000 − $40,600) ÷ $45,000 = 9.8% rounded. Product GP = $40,600 − 450 × $40 = $22,600 before other expenses.

Weight the period total instead of averaging rates

Combined original ticket value is $45,000 and net sales $40,600. The $4,400 reduction gives a weighted discount rate of 9.8%, rounded to one decimal place. A simple average of 4%, 8% and 14% gives 8.7%, which gives the smallest week too much influence.

Use the underlying amounts when rolling weeks into a brand, region or channel result. Compare that result with the intended plan before describing it as adverse. A deliberately planned clearance week should remain distinguishable from an unexpected price deterioration in continuing full-price merchandise.

THE PLANNING REFERENCERead the markdown guide

Read the margin consequence beside the volume growth

At a common $40 cost, product gross profit is $5,600, $7,800 and $9,200 across the three weeks. Gross profit dollars rise, while gross margin rates fall from 58.3% to 56.5% and 53.5%, rounded to one decimal place.

Combined goods cost is $18,000 and gross profit $22,600. Those totals exclude other expenses. Atlas can support the margin and sales review, while Core holds the forward merchandise assumptions. Neither a rising profit dollar nor a falling margin percentage alone determines which price or intake response is appropriate.

Investigate the reason before cutting the next buy

Separate the offer purpose, product mix and availability context. If a continuing line needs deeper reductions to sustain demand, its future depth may need review. If a planned exit explains the change, investigate whether stock clears as intended rather than penalise unrelated full-price lines.

Carry the supported conclusion into Core’s MFP/WSSI and scenario discussion. A revised price outlook can change the stock and buying requirement, but it does not amend an existing order or update the POS price. Those operational decisions require their own authority and recorded result.

A forward sensitivity turns the observed price into a concrete Core question. For 250 next-week units, $92 realised price would imply $23,000 revenue; retaining the latest $86 would imply $21,500. The $1,500 difference is a conditional price assumption, not an observed loss. Compare it with the intended promotion and product mix before changing intake.

SignalMerchmix workspaceDecision to review
Net sales grow stronglyAtlas / weekly tradeCompare units, realised price and margin together.
The blended rate changesAtlas / scoped reportingWeight amounts and inspect product, region and channel mix.
A price assumption weakensCore / MFP/WSSIReview future depth without implying an order or POS change.

Make the weekly review specific enough to act on

For this example, the three-week rate is 9.8% on ticket value, with a clear weekly move from 4% to 14%. The next question is which product or channel explains the change and whether it was planned. A single blended number cannot answer that.

Merchmix connects the trading evidence with the forward plan so the team can investigate while decisions remain changeable. Retain the denominator, scope and price purpose beside the percentage. The warning is not that every discount is wrong; it is that unexplained price movement should not hide behind stronger sales.

Give the weekly review a stable comparison cut and a named explanation for the largest movement. A channel gaining share at a lower realised price can raise the group rate without every line getting worse. Inspect the within-channel trend as well as the change in mix before asking buyers to reduce range depth.

BEFORE THE NEXT DECISION

  • Reporting owner

    Define ticket value, net sales and adjustments.

  • Trading owner

    Explain the purpose and scope of reductions.

  • Planner

    Connect the supported conclusion to the forward plan.

Common questions

Why not average 4%, 8% and 14%?

The weeks have different ticket values. Divide the combined $4,400 reduction by combined $45,000 ticket value.

What is the period rate?

9.8% rounded, using original ticket value of sold units as the denominator.

Can gross profit rise while margin falls?

Yes. More units can raise profit dollars while a lower realised price reduces the margin rate.

Does the example prove discounting is unplanned?

No. The purpose of the reductions must be investigated separately.

Does Atlas automatically change the buy?

No. Atlas supports analysis; forward planning and operational approvals remain separate.

atlas

Compare units, realised price and margin together.

Explore
core

Review future depth without implying an order or POS change.

Explore

Continue reading: Separate promotion and exit budgets

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