Broken size run: what to mark down and how deep
Shows how a broken run slows a style down and what to do about it. From the size curve and the stock by size it counts the demand coverage by sizes in stock, the effective rate, the weeks to sell each size, the tail sizes and the depth of the price cut needed for the tail to clear by the target term. So the price cut is targeted: for two sizes, not for the whole style. It complements “Size run” (completeness of the run) and the “Discount ladder”.
At a glance
- What question does it answer?
- What to cut in price when the run has holes: which sizes and by how much.
- What data is needed?
- The size curve and the stock by size.
- How to read the result?
- Look at the tails and their depth; holes are fixed by replenishment, tails by transfers and a targeted discount. Example on the default values: Demand coverage by sizes in stock: 80%; Effective rate: 16; Tail sizes: 1; Stock in the tails: 40. The figures are illustrative: enter your own to see your result.
Why and how to reason
When the run is broken the style sells only through the sizes in stock. In the example the coverage is 80%, the rate 16 of 20 pcs a week; size M holds 40 pcs and sells in 5.7 weeks against the target of 3: the rate must rise 1.90 times, a price cut of 27.5%. The other sizes need no cut.
When to use it
Apply to styles with holes and tails before deciding to cut the price of the whole style.
How to read the result
Look at the tails and the needed depth; holes are fixed by replenishment, tails by transfers and a targeted discount.
Common mistakes
The price of the whole style is cut, transfers between stores are not checked.
What data is needed?
- The size curve and the stock by size.
- The full-run rate, target term, elasticity.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Rate of the full run | pcs/week | 20 | How many pieces of the style would sell a week with a full run: a normalized rate without stock-outs. The example value is illustrative. |
| Target sell-out term | weeks | 3 | In how many weeks the tail must go. The example value is illustrative. |
| Elasticity (absolute value) | −2 | Enter the absolute value without a sign: an estimate from your price cuts on similar styles. It is not the elasticity of a lasting price change. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Coverage | the sum of the shares of sizes with stock above zero |
| Weeks by size | size stock ÷ (rate × size share) |
| Rate growth needed | u = stock ÷ (term × size rate) |
| Depth of the cut | d = 1 − u^(1 ÷ ε) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Demand coverage by sizes in stock
- 80 %The sum of the shares of sizes with stock above zero.
- Effective rate
- 16The full-run rate × coverage, pcs/week.
- Tail sizes
- 1Weeks to sell above the target term.
- Stock in the tails
- 40
- Share of stock in the tails
- 83.3 %
- Depth of the cut needed for the worst tail
- 27.5 %M
- Rate growth needed for the worst tail
- 1.9×
- Sales lost to holes
- 4Pcs a week: the share of sizes without stock × the rate.
- Weeks
- Target term
Data as a table
| Measure | Weeks | Target term |
|---|---|---|
| S | 0.7 | 3 |
| M | 5.7 | 3 |
| L | 1 | 3 |
| XL | 0 | 3 |
Sizes
| Size | Share of demand | Stock, pcs | Weeks | Depth needed |
|---|---|---|---|---|
| S | 15 % | 2 | 0.7 | 0 % |
| M | 35 % | 40 | 5.7 | 27.5 % |
| L | 30 % | 6 | 1 | 0 % |
| XL | 20 % | 0 | no stock | — |
The tail “M”: 5.7 weeks against the target of 3 weeks; the rate of the size must be raised 1.9 times, which is a price cut of 27.5 %. The other sizes need no cut.
Holes in the run (XL) lose about 4 pcs of sales a week: replenishing these sizes is usually better than a price cut.
What to do with the result: first move the tail-size stock to where it sells (a transfer between stores), then cut the price only on the tail sizes. Large sizes usually break first.
A typical mistake: cutting the price of the whole style when the problem is in two sizes, and not checking transfers between stores.
Nuances and limits
- Cutting the price of the whole style.
- Not checking transfers.