Retail Merchandising & Liquidation Lab

Retail Markdown Optimization Lab

Simulate retail markdown cadences, inventory liquidation, price elasticity, gross margin dilution, and terminal salvage in a free interactive merchandise lab.

Markdown Cadence Stage Liquidation Table Retail Theory FAQ

Merchandising Presets

Load benchmark retail markdown cadences.

Step 1: Configure Inventory & Multi-Stage Markdown Cadence

Markdown Cadence & Liquidation Inputs

Total stock units to liquidate.
Full original sticker price.
Landed wholesale purchase cost.
Weekly sales at full price.

Stage 1: Promotional Mark

Stage 2: Clearance Mark

Stage 3: Deep Clearance

Velocity response to discounts (1.8 = +90% velocity at 50% off).
Recovery from jobbers/liquidators for unsold units.
Total Realized Revenue
$107,340
Full ticket potential: $204,000
Total Gross Profit
$35,340
Markdown dilution cost: $96,660
Blended Gross Margin
32.9%
Original ticket margin: 64.7%
Overall Sell-Through
96.8%
77 unsold salvage units

Multi-Stage Markdown Cadence & Profit Realization Table

Markdown Stage Price & Discount Duration Units Liquidated Realized Revenue Gross Profit & Margin

Retail Inventory Lifecycle Strategy

Markdown Cadence Economics

Effective markdown planning balances margin retention against inventory obsolescence:

  • First Markdown Depth: The initial mark should be deep enough to stimulate significant velocity lift (+20% to +35%) without giving away excessive gross margin.
  • Price Discrimination: Multi-tier markdowns allow retailers to capture high willingness-to-pay early adopters before clearing to bargain seekers.
  • Carrying Cost vs Liquidation: Holding unsold apparel or electronics incurs warehouse storage, insurance, and working capital interest.
  • Salvage Avoidance: Selling to salvage jobbers at 10% of cost results in severe write-down losses; aggressive mid-season markdowns yield higher net cash.

Track inventory turn in the GMROI & Turnover Lab.

Mathematical Merchandising Formulation

Markdown formulas

Discounted Price (P_stage) = P_0 × (1 - Discount %)

Weekly Velocity = Base Velocity × (1 + ε × Discount %)

Stage Units Sold = min(Remaining Stock, Velocity × Weeks)

Gross Margin Dilution = (Units Sold × P_0) - Realized Revenue

Blended Margin % = [(Total Revenue - Total COGS) ÷ Total Revenue] × 100%

Calculate monthly budget in the Open-To-Buy Lab.

FAQ

Retail markdown & liquidation questions

What is retail markdown optimization?

Retail markdown optimization is the strategic process of scheduling price reductions across a product's lifecycle to liquidate seasonal inventory before obsolescence while maximizing cumulative gross profit.

Why is markdown timing critical in retail merchandising?

Discounting too early gives away gross margin on units that could have sold at full price, while discounting too late leaves high unsold volumes that must be liquidated below cost or written off.

How does price elasticity affect clearance sales velocity?

Discount depth accelerates weekly sales velocity according to the product's elasticity: Sales Velocity = Base Velocity * (1 + Elasticity * Discount %). Higher elasticity allows faster inventory clearance with smaller discount steps.

What is gross margin dilution in markdown planning?

Gross margin dilution (markdown cost) is the reduction in realized margin dollars caused by price cuts compared to the full original retail ticket price: Markdown Cost = Full Ticket Value - Realized Revenue.

What is terminal salvage value in inventory liquidation?

Terminal salvage value is the recovery price obtained by selling residual unsold inventory to third-party discount jobbers or liquidators at season end, typically 5% to 30% of original cost.

Can I export the markdown optimization plan to CSV?

Yes. You can export complete stage-by-stage unit sales, discounts, realized revenues, gross profits, and salvage write-downs as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Retail & Inventory Tools

Explore our Retail & Inventory Hub, monitor sell-through rates in Sell-Through Lab, plan purchase budgets in Open-To-Buy Lab, calculate inventory turnover in GMROI & Turnover Lab, or optimize safety buffers in Safety Stock Lab.