Clearance markdown recovery example for aged stock

Last updated: 2026-07-31

Written and reviewed by Seller Profit Guard Editorial Team.

A deeper clearance can recover more total value when higher expected sell-through and faster space release offset the lower unit price. In this synthetic case, a 50 percent markdown and 90 percent sell-through produce USD 850 expected net recovery, or 70.83 percent of cost basis. That outcome still depends on entered assumptions.

clearance-scenario workpaper from aged inventory and markdown inputs through expected recovery, review, and restoration — This original diagram explains a traceable Scenario B calculation with synthetic inventory data.

Hold the population constant

Use the same 100 units and USD 12 cost basis as the moderate case. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Population drift invalidates the comparison. At checkpoint 1, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Apply the clearance price

A 50 percent markdown converts USD 30 to USD 15. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Classify permanent versus temporary price events. At checkpoint 2, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Apply 90 percent sell-through

Calculate 90 expected sold units and 10 expected unsold units. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Explain why the probability changes. At checkpoint 3, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Calculate clearance sold recovery

After 10 percent fees and USD 4 fulfillment, net recovery is USD 9.50 per sold unit. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

A lower price can still have positive recovery. At checkpoint 4, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

clearance-scenario workpaper: calculate clearance sold recovery — This original diagram makes a traceable Scenario B calculation reviewable.

Calculate sales proceeds

Multiply 90 expected sold units by USD 9.50 for USD 855. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Preserve expected-value decimals. At checkpoint 5, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Calculate residual recovery

Multiply 10 expected unsold units by USD 2 for USD 20. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Do not assume every residual is recoverable. At checkpoint 6, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Subtract faster-clearance storage

Apply USD 0.25 across 100 units for USD 25. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Support the shorter window. At checkpoint 7, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Calculate total recovery

Add USD 855 and USD 20, then subtract USD 25 for USD 850. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Trace every term. At checkpoint 8, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Calculate the 70.83 percent rate

Divide USD 850 by USD 1,200 cost basis. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

The rate is operating evidence. At checkpoint 9, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

Read the threshold result

The scenario clears a 70 percent review threshold by 0.83 percentage points. The clearance-scenario workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario B calculation.

Narrow headroom needs sensitivity. At checkpoint 10, reperform the affected Scenario A and Scenario B terms, identify the input that changes expected recovery, and state the operational, accounting, tax, policy, or privacy conclusion that remains outside the calculator.

clearance-scenario workpaper: read the threshold result — This original diagram makes a traceable Scenario B calculation reviewable.

Clearance Markdown Recovery Scenario: population integrity control

Keep one SKU-location, condition state, availability rule, unit count, and cost basis. Control 1 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Mixed inventory blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: probability lineage control

Record sell-through definition, window, price, season, placement, availability, and source delay. Control 2 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Unsupported probability requires Review. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: cost separation control

Map fees, fulfillment, storage, disposal, and cost basis once. Control 3 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Duplicate or missing cost blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: three seller thresholds control

Compare expected recovery rate, cost-basis shortfall rate, and evidence days with three separately entered seller controls. Control 4 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

One passing threshold cannot override another. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: dated evidence governance control

Record a real source-review date and seller-policy effective date, with policy no later than the reviewed evidence. Control 5 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Impossible or reversed dates block. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: nine confirmations control

Confirm SKU-location grain, on-hand and cost basis, price and fees, sell-through, storage and fulfillment, residual recovery, condition, privacy, and accounting boundaries. Control 6 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Any missing confirmation blocks. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

clearance-scenario workpaper: clearance markdown recovery scenario: nine confirmations control — This original diagram makes a traceable Scenario B calculation reviewable.

Clearance Markdown Recovery Scenario: distinct scenarios control

Change at least one markdown, probability, selling cost, residual recovery, age, or evidence-window assumption between the two cases. Control 7 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

A copied scenario is not a comparison. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: output masking control

Mask derived money, rates, units, preference, and threshold gaps whenever structural validation returns Block. Control 8 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Never act on partial invalid arithmetic. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: decision boundary control

Separate scenario recovery from forecasting, accounting, tax, pricing authority, promotion setup, and disposal approval. Control 9 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Arithmetic cannot authorize action. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Clearance Markdown Recovery Scenario: privacy and recovery control

Use aggregates, protect source rows, retain prior values, monitor variance, and preserve restoration. Control 10 defines a pass condition, evidence owner, independent reviewer, correction deadline, sensitivity range, monitoring signal, stop condition, and restoration trigger before the clearance-scenario workpaper can support a traceable Scenario B calculation.

Public buyer or order data is prohibited. Apply the control to both synthetic fixtures while keeping inventory age, markdown price, expected units, selling costs, storage, disposal recovery, cost basis, recovery rate, and decision authority as separate concepts.

Hold the population constant: recovery lab 1

Recalculate the relevant output from both fixtures. Use the same 100 units and USD 12 cost basis as the moderate case. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Population drift invalidates the comparison. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Apply the clearance price: recovery lab 2

Recalculate the relevant output from both fixtures. A 50 percent markdown converts USD 30 to USD 15. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Classify permanent versus temporary price events. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Apply 90 percent sell-through: recovery lab 3

Recalculate the relevant output from both fixtures. Calculate 90 expected sold units and 10 expected unsold units. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Explain why the probability changes. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Calculate clearance sold recovery: recovery lab 4

Recalculate the relevant output from both fixtures. After 10 percent fees and USD 4 fulfillment, net recovery is USD 9.50 per sold unit. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

A lower price can still have positive recovery. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Calculate sales proceeds: recovery lab 5

Recalculate the relevant output from both fixtures. Multiply 90 expected sold units by USD 9.50 for USD 855. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Preserve expected-value decimals. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Calculate residual recovery: recovery lab 6

Recalculate the relevant output from both fixtures. Multiply 10 expected unsold units by USD 2 for USD 20. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Do not assume every residual is recoverable. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Subtract faster-clearance storage: recovery lab 7

Recalculate the relevant output from both fixtures. Apply USD 0.25 across 100 units for USD 25. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Support the shorter window. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Calculate total recovery: recovery lab 8

Recalculate the relevant output from both fixtures. Add USD 855 and USD 20, then subtract USD 25 for USD 850. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Trace every term. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Calculate the 70.83 percent rate: recovery lab 9

Recalculate the relevant output from both fixtures. Divide USD 850 by USD 1,200 cost basis. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

The rate is operating evidence. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Read the threshold result: recovery lab 10

Recalculate the relevant output from both fixtures. The scenario clears a 70 percent review threshold by 0.83 percentage points. Change one input only, retain every other population and cost assumption, and record the new expected sold units, unsold units, net recovery, recovery rate, threshold headroom, and preferred scenario.

Narrow headroom needs sensitivity. Test a low and high case for sell-through, price, fee, fulfillment, storage, and disposal recovery. Explain when the preference crosses over and which protected evidence or approval would still be required before an inventory action.

Clearance Markdown Recovery Scenario: intent-specific implementation walkthrough

clearance-scenario workpaper checkpoint 1 addresses hold the population constant as a distinct requirement for a traceable Scenario B calculation. Use the same 100 units and USD 12 cost basis as the moderate case. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Population drift invalidates the comparison.

clearance-scenario workpaper checkpoint 2 addresses apply the clearance price as a distinct requirement for a traceable Scenario B calculation. A 50 percent markdown converts USD 30 to USD 15. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Classify permanent versus temporary price events.

clearance-scenario workpaper checkpoint 3 addresses apply 90 percent sell-through as a distinct requirement for a traceable Scenario B calculation. Calculate 90 expected sold units and 10 expected unsold units. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Explain why the probability changes.

clearance-scenario workpaper checkpoint 4 addresses calculate clearance sold recovery as a distinct requirement for a traceable Scenario B calculation. After 10 percent fees and USD 4 fulfillment, net recovery is USD 9.50 per sold unit. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. A lower price can still have positive recovery.

clearance-scenario workpaper checkpoint 5 addresses calculate sales proceeds as a distinct requirement for a traceable Scenario B calculation. Multiply 90 expected sold units by USD 9.50 for USD 855. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Preserve expected-value decimals.

clearance-scenario workpaper checkpoint 6 addresses calculate residual recovery as a distinct requirement for a traceable Scenario B calculation. Multiply 10 expected unsold units by USD 2 for USD 20. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Do not assume every residual is recoverable.

clearance-scenario workpaper checkpoint 7 addresses subtract faster-clearance storage as a distinct requirement for a traceable Scenario B calculation. Apply USD 0.25 across 100 units for USD 25. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Support the shorter window.

clearance-scenario workpaper checkpoint 8 addresses calculate total recovery as a distinct requirement for a traceable Scenario B calculation. Add USD 855 and USD 20, then subtract USD 25 for USD 850. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Trace every term.

clearance-scenario workpaper checkpoint 9 addresses calculate the 70.83 percent rate as a distinct requirement for a traceable Scenario B calculation. Divide USD 850 by USD 1,200 cost basis. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. The rate is operating evidence.

clearance-scenario workpaper checkpoint 10 addresses read the threshold result as a distinct requirement for a traceable Scenario B calculation. The scenario clears a 70 percent review threshold by 0.83 percentage points. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Narrow headroom needs sensitivity.

Evidence boundary for a traceable Scenario B calculation

The moderate fixture uses 100 units, USD 12 unit cost, USD 30 current price, a 30 percent markdown, 55 percent expected sell-through, 10 percent selling fees, USD 4 fulfillment per sold unit, USD 1.50 storage per on-hand unit, and USD 2 disposal recovery per unsold unit. Expected net recovery is USD 759.50, or 63.29 percent of cost basis. The clearance fixture uses the same inventory and cost basis, a 50 percent markdown, 90 percent expected sell-through, 10 percent selling fees, USD 4 fulfillment per sold unit, USD 0.25 storage per on-hand unit, and USD 2 disposal recovery per unsold unit. Expected net recovery is USD 850, or 70.83 percent of cost basis.

The enhanced packet also displays cost-basis shortfall rates of 36.71 and 29.17 percent, expected net recovery per opening unit of USD 7.60 and USD 8.50, and recovery-floor gaps of negative 6.71 and positive 0.83 percentage points. It can demonstrate entered arithmetic and sensitivity, but it cannot prove future demand, optimal price, incrementality, accounting value, tax treatment, cash timing, policy compliance, buyer response, disposal eligibility, or the correct business action.

Release, monitor, and restore the clearance-scenario workpaper

Block invalid or non-finite units, costs, prices, rates, dates, evidence, scope, currency, confirmations, duplicated scenarios, privacy, or conflicts, and mask every derived output. Review short evidence, very old inventory, negative sold-unit recovery, recovery below the seller floor, or shortfall above the seller ceiling. Ready clears only the three entered thresholds, nine confirmations, and the rest of the entered worksheet.

Before indexing or operational use, preserve evidence and rollback artifacts; run typecheck, unit, integration, build, content, similarity, SEO, image, link, mobile, strict-route, deployment, and live checks; then compare later evidence without claiming same-period causality.

Clearance Markdown Recovery Scenario: concrete working record

The clearance packet records price event type, timing, floor constraints, expected sell-through evidence, fee and fulfillment mappings, storage release assumption, disposal fallback, headroom to threshold, operational approvals, channel restrictions, monitoring cadence, stop condition, and the prior price needed for restoration.

Sources and further reading

Seller Profit Guard methodology: Evidence, formula, privacy, correction, release, monitoring, and rollback rules.
Seller Profit Guard data privacy: Local-first boundaries for inventory, supplier, customer, order, and raw export data.
Shopify Help: Product analytics overview: Official definitions for product sell-through, days of inventory remaining, and inventory value context.
Shopify Help: Inventory reports: Official reporting periods, month-end inventory snapshots, sell-through, ending quantity, and days-remaining boundaries.
Square Support: Run an aging inventory report: Official weighted age, last-received date, age bands, on-hand quantity, value, and location filters.
Microsoft Learn: Item Age Composition by Quantity and Value: Current official receipt-date aging report for on-hand quantity and value with item and location filters.
Oracle Retail: Markdown data requirements: Official treatment of permanent, clearance, and promotional markdown data.
Oracle Retail Markdown Optimization User Guide: Official lifecycle context for markdown timing, depth, profitability, and inventory targets.

Related Seller Profit Guard tools

Dead Stock Markdown Calculator: Compare moderate and clearance scenarios using expected net recovery and cost-basis recovery rate.
Inventory Carrying Cost Calculator: Estimate the annual holding burden separately from a markdown decision window.
Maximum Discount Calculator: Calculate a contribution-based discount ceiling for ordinary retained orders.
Contribution Margin Calculator: Measure retained order contribution separately from inventory disposition.
Methodology: Review evidence, formula, privacy, correction, release, and rollback.
Data Privacy: Protect inventory, supplier, customer, order, and raw export data.
Dead Stock Markdown Formula and Inputs: Define markdown price, sell-through probability, selling costs, storage, disposal recovery, cost basis, and expected net recovery.
Dead Stock Markdown Worked Example: Reperform a moderate markdown example from aged inventory through expected units, selling costs, storage, disposal, and recovery rate.
Dead Stock Markdown Modeling Mistakes: Find population, probability, fee, storage, disposal, cost-basis, accounting, privacy, and decision errors in markdown recovery models.
Dead Stock Markdown Data Sources: Map inventory age, on-hand units, cost, price, sell-through, fees, fulfillment, storage, and disposal recovery to controlled evidence.
Dead Stock Markdown Decision Threshold: Set a seller-owned recovery threshold, evidence floor, sensitivity range, approval boundary, stop rule, and restoration trigger.
Moderate vs Clearance Markdown: Compare moderate and clearance markdowns across price, expected units, costs, storage, disposal, recovery, uncertainty, and reversibility.
Weekly Dead Stock Markdown Routine: Run a weekly age review, source reconciliation, scenario comparison, approval, monitoring, exception, and restoration routine.
Interpret Markdown Recovery Results: Interpret expected units, recovery, rate, threshold, uncertainty, operating boundaries, and actual-versus-expected results without false precision.
Dead Stock Markdown Audit Template: Audit inventory scope, price, sell-through, costs, storage, disposal, formula, approvals, execution, monitoring, privacy, and rollback.

Next step: Open Seller Profit Guard.

This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.