Markdown Planning: Protect Margin on Slow-Moving Stock
By Newtown Analytics · · 9 min read
For ecommerce, marketing & growth leaders
Markdown planning is the discipline of deciding when to cut the price on slow-moving stock, by how much, and with what stopping rule, so that margin is protected and cash comes back before the stock loses all value. The instinct of many teams is to wait: the product may still sell at full price, the season may turn, a customer may place a large order. Sometimes waiting pays. Often it simply adds carrying cost and lets the item age to the point where only a deep discount or liquidation remains. A good markdown plan treats price as a planned lever with a calendar, a sell-through target and a decision rule, not as an emergency. This guide explains the principles, shows a worked markdown ladder with checked arithmetic, compares marking down now with waiting, covers channel and brand considerations and sets guardrails. It is part of demand planning and inventory optimization, follows inventory write-downs and how inventory decisions affect cash flow, and leads to inventory aging reports and FIFO vs. LIFO. Markdown timing affects the cash described in cash flow management.
Principles
Plan markdowns before you buy. For items with a limited selling window, build expected markdowns into the buying and pricing plan. A product with a planned 20 percent markdown share has a different true margin than one assumed to sell at full price.
Use sell-through, not feeling. Define the expected sell-through by week or month for each item, based on analogs. When actual sell-through falls behind the curve by a set margin, the item enters the markdown review.
Cut earlier and shallower rather than later and deeper. Waiting often leads to a deeper cut later, with fewer weeks to benefit from the lower price. A modest early cut can restart sales at a better margin than a late deep cut.
Protect the brand and the full-price business. Frequent or visible discounts train customers to wait. Consider channels and timing that limit the effect on full-price sales.
Set a stopping rule. Decide in advance when stock moves to liquidation, donation or disposal.
A worked markdown ladder
An item has 1,000 units with a cost of $12 and a full price of $30 (illustrative). The plan is a ladder of price steps:
| Stage | Price | Units sold | Revenue |
|---|---|---|---|
| Weeks 1 to 4: full price | $30.00 | 400 | $12,000 |
| Weeks 5 to 8: 25% off | $22.50 | 300 | $6,750 |
| Weeks 9 to 12: 50% off | $15.00 | 200 | $3,000 |
| Remaining units: liquidation | $8.00 | 100 | $800 |
| Total | 1,000 | $22,550 |
Check: 400 × 30 = 12,000; 300 × 22.50 = 6,750; 200 × 15 = 3,000; 100 × 8 = 800; the total is 22,550. The cost of the goods is 1,000 × 12 = $12,000, so gross margin is 22,550 - 12,000 = $10,550, or 10,550 / 22,550 = 46.8 percent of revenue. The average realized price is 22,550 / 1,000 = $22.55, 24.8 percent below the full price (1 - 22.55 / 30 = 0.248). If the original plan had assumed all 1,000 units at full price, the expected margin would have been $18,000, so the planned markdowns reduce margin by $7,450. That is the cost of overbuying relative to demand at full price, and it is why the buying decision matters more than the markdown tactics.
Mark down now or wait?
Suppose that after eight weeks, 600 units remain of the 1,000. Management is deciding between two options (illustrative).
Option 1: mark down 30 percent now. The new price is $21. Expected sales: 400 units over the next eight weeks, then the last 200 are liquidated at $8. Revenue: 400 × 21 = $8,400 plus 200 × 8 = $1,600, a total of $10,000.
Option 2: hold full price for eight more weeks. Expected sales: 150 units at $30, which is $4,500. Then mark down 50 percent to $15, selling 300 units for $4,500, and liquidate the last 150 at $8 for $1,200. Revenue: 4,500 + 4,500 + 1,200 = $10,200. This takes about sixteen weeks.
Option 2 produces $200 more revenue but takes twice as long. The carrying cost of the stock at an 18 percent annual rate on an average value of, say, $4,000 (about 330 units at $12) is 4,000 × 0.18 × (8 / 52) = $111 for eight weeks, so the extra eight weeks cost about $111 in carrying cost alone. Add the risk that the season ends and the 150 full-price units do not sell, and the cash tied up longer, and Option 1 looks at least as good. Check: 400 × 21 = 8,400; 8,400 + 1,600 = 10,000; 150 × 30 = 4,500; 300 × 15 = 4,500; 4,500 + 4,500 + 1,200 = 10,200. The numbers depend heavily on the assumed sales rates, which is why the sell-through estimates should come from your own history. The point of the example is to compare both revenue and time, and to count carrying cost and risk.
Deciding depth and timing
Use evidence from past markdowns: price elasticity by category, the response to each discount level, the share of buyers who wait for sales. See price elasticity of demand. Tests help: run a modest markdown on a sample of locations or a segment of customers and measure the lift before rolling out. Consider the product life cycle. Fashion and seasonal items lose value quickly, so earlier action is warranted. Staples and durable goods lose value slowly and can be held longer. Consider competitor pricing and the availability of substitutes.
Channels and alternatives to a public discount
Not every clearance should be a public markdown. Alternatives include bundling slow items with fast sellers, offering them to loyalty customers or wholesale buyers, using outlet or off-price channels, selling through marketplaces, returning to vendors, donating or reworking. Each has a recovery rate and a brand effect. A bundle may recover more of the value than a straight discount while protecting the price of the main item. See excess and obsolete inventory.
Markdown governance
- Calendar. Set markdown review dates for each category.
- Triggers. Sell-through below plan by a set percentage, coverage above a set number of days, or aging beyond a set threshold.
- Approval levels. Who can approve which depth, and when escalation is needed.
- Budget. A markdown allowance in the plan, tracked against actual.
- Measurement. Sell-through, realized margin, speed of clearance and effect on full-price sales.
- Learning. After each season, compare actual with plan and refine.
Link with buying
A markdown is the cost of an overbuy. Track markdown dollars by buyer and category and feed the results back to buying. If the same categories need heavy markdowns every season, the problem is the buy, not the pricing. Use open-to-buy limits and in-season replenishment to reduce initial commitments. See open-to-buy planning.
Building a sell-through curve
A markdown plan depends on knowing what normal looks like. For each item or category, build an expected sell-through curve from analogs: past products of the same type, season and price tier. The curve shows the cumulative share of the initial quantity sold by week. For example, a seasonal item might typically reach 20 percent in week 4, 45 percent in week 8 and 70 percent in week 12. If a new item is at 12 percent in week 4, it is running at 60 percent of the expected pace (12 / 20 = 0.6). That gap is the trigger for review, and the size of the gap helps decide the depth of the response. Keep curves by category and channel, since a curve for an online store will differ from one for wholesale accounts.
How depth, volume and margin interact
Return to the item with a cost of $12 and a full price of $30. Baseline demand at full price is 100 units a week, and the weekly gross margin is (30 - 12) × 100 = $1,800. Suppose price elasticity in this category is about -2, meaning a 25 percent cut in price raises volume by roughly 50 percent (illustrative, and only a rough guide for moderate cuts). At $22.50 the volume is about 150 units a week. Weekly revenue rises from $3,000 to 22.50 × 150 = $3,375, but weekly margin changes to (22.50 - 12) × 150 = $1,575, lower than $1,800. A markdown therefore reduces margin per week. It makes sense when the stock would otherwise not clear at full price at all, or when the time saved is worth more than the margin given up. With 600 units remaining, the full-price pace clears the stock in 600 / 100 = 6 weeks and the discounted pace in 600 / 150 = 4 weeks. If the season ends in four weeks, the discount may recover far more value than holding. If the season ends in ten weeks, holding is better. The decision turns on the time left and the confidence in the full-price pace, which is why a sell-through curve and a calendar are essential.
Working with sales, marketing and brand teams
A markdown affects more than the planning team. Sales may have accounts that expect price protection, marketing manages the message, and brand teams worry about perception. Agree the rules before the pressure arrives: which channels may carry which depth, how long a discount runs, how customers who bought recently at full price are treated and whether price adjustments are offered. A calendar shared across functions avoids the problem of a clearance launching on the same week as a full-price campaign. For wholesale customers, consider whether a markdown triggers price-protection claims, and include that cost in the analysis.
Measuring success
After each markdown event, record the starting quantity and cost, the discount sequence, the units and revenue at each step, the final recovery, the realized margin and the time to clear. Compare with the plan and with the cost of waiting. Track the share of the season's volume sold on markdown by category and buyer, because a rising share signals a buying problem. Over several seasons, the records build a library of real elasticity and sell-through evidence that improves the next plan far more than any rule of thumb.
End-of-season and carryover decisions
Some items can be held for the next season at a modest carrying cost, while others lose most of their value once the season ends. Basic and non-seasonal items usually justify carryover. Fashion and dated items usually do not. For carryover candidates, compare the cost of holding for another year, which at 18 percent is about 18 percent of cost plus storage, with the expected full-price sales next season. If an item costs $12 and is expected to sell at $30 next year, holding has a cost of about $2.16 plus storage, and the margin of about $18 per unit remains attractive if the item will really sell. If next year's version is replacing it, the answer changes. Document the decision and the reasoning.
Common mistakes
- Waiting for a miracle.
- Cutting too deep and too late.
- No sell-through plan.
- Ignoring the effect on full-price customers.
- Not counting carrying cost.
- No stopping rule for stock that will not sell.
- Not linking markdowns back to buying.
FAQs
What is markdown planning?
Planning the timing, depth and sequence of price reductions on slow-moving stock to maximize margin and recover cash.
When should I mark down?
When sell-through falls behind plan by a set margin, coverage is above target or the item is aging. Earlier, shallower cuts often beat late deep ones.
How deep should a markdown be?
Use price elasticity evidence and tests. Start modest, measure the response and step down according to a plan.
Do markdowns hurt the brand?
Frequent public discounts can train customers to wait. Use targeted channels, bundles or private sales to limit the effect.
How do I avoid markdowns in the first place?
Improve forecasts, remove bias, buy closer to demand, use open-to-buy limits and plan transitions.
Keep reading
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.