Dead stock markdown worked example for a moderate cut
Last updated: 2026-07-31
Written and reviewed by Seller Profit Guard Editorial Team.
A moderate markdown does not automatically preserve more value. In this synthetic example, 100 units at USD 12 cost receive a 30 percent markdown, 55 percent expected sell-through, and explicit selling, fulfillment, storage, and disposal assumptions. Expected net recovery is USD 759.50, equal to 63.29 percent of cost basis.
Establish the opening inventory
Confirm 100 sellable units at USD 12 cost and USD 30 current price. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Do not mix locations or condition states. 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 30 percent markdown
Calculate a USD 21 markdown price and retain the unrounded rate. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Do not change platform pricing. 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 55 percent sell-through
Calculate 55 expected sold units and 45 expected unsold units. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Expected units are probability-weighted. 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 sold-unit recovery
After a 10 percent fee and USD 4 fulfillment, net recovery per sold unit is USD 14.90. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Check the fee base. 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.
Calculate sales recovery
Multiply 55 expected sold units by USD 14.90 to obtain USD 819.50. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Keep multiplication visible. 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 disposal recovery
Multiply 45 expected unsold units by USD 2 for USD 90. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Verify the disposal path. 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 storage
Charge USD 1.50 across 100 on-hand units for USD 150 decision-window storage. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Do not annualize twice. 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 net recovery
Add USD 819.50 and USD 90, then subtract USD 150 for USD 759.50. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Reperform the arithmetic. 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 recovery rate
Divide USD 759.50 by the USD 1,200 inventory cost basis for 63.29 percent. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
This is not gross margin. 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.
Interpret Review status
The default 70 percent threshold makes this scenario Review even though arithmetic is complete. The moderate-markdown workpaper records the exact source, definition, period, unit, currency, transformation, timestamp, owner, reviewer, exception, and prior accepted value needed for a traceable Scenario A calculation.
Thresholds do not approve actions. 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Dead Stock Markdown Worked Example: 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 moderate-markdown workpaper can support a traceable Scenario A 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.
Establish the opening inventory: recovery lab 1
Recalculate the relevant output from both fixtures. Confirm 100 sellable units at USD 12 cost and USD 30 current price. 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 mix locations or condition states. 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 30 percent markdown: recovery lab 2
Recalculate the relevant output from both fixtures. Calculate a USD 21 markdown price and retain the unrounded rate. 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 change platform pricing. 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 55 percent sell-through: recovery lab 3
Recalculate the relevant output from both fixtures. Calculate 55 expected sold units and 45 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.
Expected units are probability-weighted. 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 sold-unit recovery: recovery lab 4
Recalculate the relevant output from both fixtures. After a 10 percent fee and USD 4 fulfillment, net recovery per sold unit is USD 14.90. 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.
Check the fee base. 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 recovery: recovery lab 5
Recalculate the relevant output from both fixtures. Multiply 55 expected sold units by USD 14.90 to obtain USD 819.50. 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.
Keep multiplication visible. 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 disposal recovery: recovery lab 6
Recalculate the relevant output from both fixtures. Multiply 45 expected unsold units by USD 2 for USD 90. 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.
Verify the disposal path. 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 storage: recovery lab 7
Recalculate the relevant output from both fixtures. Charge USD 1.50 across 100 on-hand units for USD 150 decision-window storage. 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 annualize twice. 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 net recovery: recovery lab 8
Recalculate the relevant output from both fixtures. Add USD 819.50 and USD 90, then subtract USD 150 for USD 759.50. 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.
Reperform the arithmetic. 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 recovery rate: recovery lab 9
Recalculate the relevant output from both fixtures. Divide USD 759.50 by the USD 1,200 inventory cost basis for 63.29 percent. 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.
This is not gross margin. 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.
Interpret Review status: recovery lab 10
Recalculate the relevant output from both fixtures. The default 70 percent threshold makes this scenario Review even though arithmetic is complete. 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.
Thresholds do not approve actions. 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.
Dead Stock Markdown Worked Example: intent-specific implementation walkthrough
moderate-markdown workpaper checkpoint 1 addresses establish the opening inventory as a distinct requirement for a traceable Scenario A calculation. Confirm 100 sellable units at USD 12 cost and USD 30 current price. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Do not mix locations or condition states.
moderate-markdown workpaper checkpoint 2 addresses apply the 30 percent markdown as a distinct requirement for a traceable Scenario A calculation. Calculate a USD 21 markdown price and retain the unrounded rate. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Do not change platform pricing.
moderate-markdown workpaper checkpoint 3 addresses apply 55 percent sell-through as a distinct requirement for a traceable Scenario A calculation. Calculate 55 expected sold units and 45 expected unsold units. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Expected units are probability-weighted.
moderate-markdown workpaper checkpoint 4 addresses calculate sold-unit recovery as a distinct requirement for a traceable Scenario A calculation. After a 10 percent fee and USD 4 fulfillment, net recovery per sold unit is USD 14.90. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Check the fee base.
moderate-markdown workpaper checkpoint 5 addresses calculate sales recovery as a distinct requirement for a traceable Scenario A calculation. Multiply 55 expected sold units by USD 14.90 to obtain USD 819.50. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Keep multiplication visible.
moderate-markdown workpaper checkpoint 6 addresses calculate disposal recovery as a distinct requirement for a traceable Scenario A calculation. Multiply 45 expected unsold units by USD 2 for USD 90. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Verify the disposal path.
moderate-markdown workpaper checkpoint 7 addresses subtract storage as a distinct requirement for a traceable Scenario A calculation. Charge USD 1.50 across 100 on-hand units for USD 150 decision-window storage. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Do not annualize twice.
moderate-markdown workpaper checkpoint 8 addresses calculate net recovery as a distinct requirement for a traceable Scenario A calculation. Add USD 819.50 and USD 90, then subtract USD 150 for USD 759.50. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Reperform the arithmetic.
moderate-markdown workpaper checkpoint 9 addresses calculate recovery rate as a distinct requirement for a traceable Scenario A calculation. Divide USD 759.50 by the USD 1,200 inventory cost basis for 63.29 percent. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. This is not gross margin.
moderate-markdown workpaper checkpoint 10 addresses interpret review status as a distinct requirement for a traceable Scenario A calculation. The default 70 percent threshold makes this scenario Review even though arithmetic is complete. Record the source decision, formula effect, failed alternative, reviewer question, correction owner, monitoring signal, and restoration value. Thresholds do not approve actions.
Evidence boundary for a traceable Scenario A 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 moderate-markdown 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.
Dead Stock Markdown Worked Example: concrete working record
The workpaper shows every Scenario A input, calculation, source pointer, line owner, review note, sensitivity range, output, status, comparison with Scenario B, unresolved operational constraint, monitoring plan, and prior accepted price. It also records why the 55 percent probability is comparable and what observation would invalidate it.
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.
- Clearance Markdown Recovery Scenario: Reperform a clearance markdown example with higher expected sell-through, lower storage, deeper price reduction, and unsold-unit recovery.
- 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.