Skip to main content

Methodology

Returns Profit Impact Planner methodology

This planner applies the ecommerce order return-loss identity to an original-order cohort and compares return-rate and recovery scenarios.
Duc Nguyen X.By Duc Nguyen X.ยท Founder, Margin101Last reviewed: View update historyMethodology

Educational only: Business decision support, not accounting, tax or legal advice.

Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.

Update policy: Reviewed when formulas or official dependencies change.

Scope: Market-neutral small-business planning using your own assumptions.

1. Formulas and units

Loss per returned order
D = max(0, R + L โˆ’ r ร— C โˆ’ f ร— F)

Where

N, R, Kpre, C, F, L
orders, revenue, contribution, product cost, fee stack and reverse logistics (orders/period and currency units ex indirect tax)Source: Business record
q, r, f, b
return, product recovery, fee reversal and incremental price retention rates (decimal)Source: User decision
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
max
non-negative maximum operator (operator)Source: Calculated output
Expected loss per original order
E = q ร— D

Where

q, r, f, b
return, product recovery, fee reversal and incremental price retention rates (decimal)Source: User decision
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
Net contribution per original order
K = Kpre โˆ’ E

Where

N, R, Kpre, C, F, L
orders, revenue, contribution, product cost, fee stack and reverse logistics (orders/period and currency units ex indirect tax)Source: Business record
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
Modelled period contribution
P = N ร— K

Where

N, R, Kpre, C, F, L
orders, revenue, contribution, product cost, fee stack and reverse logistics (orders/period and currency units ex indirect tax)Source: Business record
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
Return impact per period
ฮ” = โˆ’N ร— E

Where

N, R, Kpre, C, F, L
orders, revenue, contribution, product cost, fee stack and reverse logistics (orders/period and currency units ex indirect tax)Source: Business record
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
Economic break-even return rate
qBE = Kpre รท D

Where

N, R, Kpre, C, F, L
orders, revenue, contribution, product cost, fee stack and reverse logistics (orders/period and currency units ex indirect tax)Source: Business record
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output
Optional price buffer
X = E รท b

Where

q, r, f, b
return, product recovery, fee reversal and incremental price retention rates (decimal)Source: User decision
D, E, K, P, ฮ”, qBE, X
loss, contribution, impact, break-even rate and price buffer (currency units/order, currency units/period or decimal)Source: Calculated output

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

2. Worked example

Input assumptions

The illustrative fixture is engine-derived and uses user assumptions only; it is not a return-rate or recovery benchmark.

Calculation and outputs

Example

The illustrative fixture is engine-derived and uses user assumptions only; it is not a return-rate or recovery benchmark.

Loss per returned order
67.00 currency units
Expected loss per original order
5.36 currency units
Net contribution per original order
24.64 currency units
Modelled contribution per period
24,640.00 currency units
Return impact per period
-5,360.00 currency units
Economic break-even return rate
44.78%
Required price buffer ex indirect tax
6.31 currency units

The exact engine-derived outputs are shown in the labelled rows below.

Interpretation

Use the period impact to identify how much contribution returns consume after recovery and handling effects.

3. Validation and boundary checks

  • The loss components match the canonical ecommerce order profitability return identity.
  • Period impact equals original orders multiplied by negative expected loss per original order.
  • Break-even return rate is unavailable when contribution is already non-positive or loss is zero.

4. Assumptions and source classification

  • All values are user supplied, exclude indirect tax and use one consistent economic basis and period.
  • Price retention is the user-estimated all-in contribution retained from one extra ex-indirect tax price dollar.
  • Loss per returned order is floored at zero after applying product and fee recovery credits.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

5. Limitations

  • The model excludes indirect tax/refund accounting, exchanges, store credit, inventory timing, labour capacity and provider rules.
  • It is educational cohort scenario planning, not a policy, pricing, accounting or tax recommendation.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

6. Update and evidence policy

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

Change history

  1. : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner