Markdown Recovery Calculator
P23-EDU
by TWENTY3 Intelligence
Markdown Recovery Calculator
Library
⬇ PDF
⬇ Excel
v1.0
Inventory Tool 19
Markdown
Recovery
Calculator
At what markdown depth does a product stop being worth selling vs liquidating? Map recovery scenarios across discount levels, find the margin floor, and identify the optimal price reduction strategy.
1
Product & Inventory
Units to Liquidate
Unit COGS ($)
Original WS / Sell Price ($)
Monthly Holding Cost ($)
Storage + capital for this SKU
Price Elasticity
% demand increase per 1% discount
Baseline Monthly Sales at Full Price
2
Markdown Scenarios
Markdown 1 (%)
Markdown 2 (%)
Markdown 3 (%)
Liquidation Offer ($)
Optimal Markdown Depth
-
maximizes net recovery
Markdown Scenario Comparison
Scenario
Price
Net Recovery
Months
Margin Floor Analysis
COGS floor (0% margin)
-
Break-even price
-
Max markdown before loss
-
Liquidation net
-
Best option
-
Recovery vs Holding Cost
Monthly holding cost
-
Revenue lost per month at full price
-
Cost of 3 more months of holding
-
P23-EDU · TWENTY3 Intelligence
Inventory Tool 19
·
Markdown Recovery Calculator
·
Discount Depth · Margin Floor · Optimal Recovery
·
P23-EDU · TWENTY3 Intelligence
Inventory Tool 19
·
Markdown Recovery Calculator
·