Seller Profit Guard

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.

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

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.

moderate-markdown workpaper: calculate sold-unit recovery
This original diagram makes a traceable Scenario A calculation reviewable.

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.

moderate-markdown workpaper: interpret review status
This original diagram makes a traceable Scenario A calculation reviewable.

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.

moderate-markdown workpaper: dead stock markdown worked example: nine confirmations control
This original diagram makes a traceable Scenario A calculation reviewable.

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

Related Seller Profit Guard tools

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.