Act on the result
Compare proposed units sold with the break-even units before changing the live price or committing disposal terms.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
Product and retail businesses deciding whether a markdown improves recovery from a finite stock pool.
Markdown price, baseline and proposed contribution, change, remaining units and break-even sell-through.
Enter one inventory pool, its unit cost and regular recovery, then test markdown depth and proposed units sold.
Use a different tool when: Do not use this to test a general discount-volume decision without a finite inventory pool; use Discount Profit Impact Planner for that decision. Use this tool to choose markdown depth, sell-through, cash recovery and contribution for finite inventory.
Commerce & operations
Markdown price, baseline and proposed contribution, change, remaining units and break-even sell-through.
Amounts use the same currency as your inputs. No currency conversion is performed.
Compare markdown profit and inventory cash recovery with baseline sell-through, holding cost and salvage value.
Your numbers stay in this browser
Use the normal ex-tax selling price. Use one consistent ex-tax currency basis.
Use the inventory cost for each unit. Use one consistent ex-tax currency basis.
Use the whole inventory pool before full-price sales.
Enter units sold before the markdown decision.
Enter the proposed reduction from regular price.
Share of remaining stock expected to sell at the markdown price.
Share of remaining stock expected to sell without markdown.
Carrying cost for each unit left after the scenario. Use one consistent ex-tax currency basis.
Cash expected from each unit not sold normally. Use one consistent ex-tax currency basis.
Every value is bound to the registered inventory or hospitality engine and keeps the decision components visible on one consistent basis.
Each row names the assumption axis changed from the baseline.
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
regular unit price ร (1 โ markdown rate)80.00Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โstarting stock โ prior full-price units60 unitsUses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โavailable units ร markdown sell-through45 unitsUses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โbaseline sold contribution + baseline unsold recovery contribution2,010.00Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โmarkdown sold contribution + proposed unsold recovery contribution3,675.00Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โproposed contribution โ baseline contribution1,665.00Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โunits available โ proposed units sold15 unitsUses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โfull-price cash + markdown cash + salvage โ holding cost7,675.00Uses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โ(baseline contribution โ all-unsold contribution) / (markdown price โ recovery per unsold unit)22.8 unitsUses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โbreak-even markdown units / units available0.38 percentUses one consistent period, item basis and market-neutral ex-tax currency where money applies. The engine retains full precision; display rounding does not feed calculation.
Retail Markdown Profitability & Recovery Planner formulas โThis calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| baselineSellThroughWithoutMarkdownRate | Share of remaining stock expected to sell without markdown. | proportion of the relevant inventory or price basis | 0 to 1 | Required | 0.3 |
| expectedMarkdownSellThroughRate | Share of remaining stock expected to sell at the markdown price. | proportion of the relevant inventory or price basis | 0 to 1 | Required | 0.75 |
| holdingCostPerLeftoverUnit | Carrying cost for each unit left after the scenario. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 5 |
| markdownRate | Enter the proposed reduction from regular price. | proportion of regular unit price discounted | 0 to 1 | Required | 0.2 |
| regularUnitPrice | Use the normal ex-tax selling price. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 100 |
| salvageValuePerLeftoverUnit | Cash expected from each unit not sold normally. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 10 |
| startingUnits | Use the whole inventory pool before full-price sales. | whole product units | 0 to 100000000 | Required | 100 |
| unitInventoryCost | Use the inventory cost for each unit. Use one consistent ex-tax currency basis. | currency units/planning period, ex tax | 0 to 10000000 | Required | 40 |
| unitsSoldAtFullPrice | Enter units sold before the markdown decision. | currency units/planning period, ex tax | 0 to 100000000 | Required | 40 |
A positive change means the entered markdown sell-through and unsold recovery improve contribution versus the baseline scenario.
Data used here
Compare proposed units sold with the break-even units before changing the live price or committing disposal terms.
Retest a deeper markdown, lower proposed sell-through and lower recovery per unsold unit.
Educational estimate, not advice. See all assumptions & limitations โ
Guides to interpret the decision and its assumptions.
Compare the contribution recovered by a markdown with holding cost, sell-through evidence and the cost of waiting.
Read guideCompare proposed units sold with the break-even units before changing the live price or committing disposal terms.
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.