Skip to main content

Methodology

Affiliate Commission Profit Planner methodology

Test affiliate program profit and a contribution-based commission ceiling.
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

Incremental Orders
incrementalOrders = attributed orders × incrementality

Where

attributedOrders
Attributed orders (whole or operational units)Source: Business record
incrementalOrders
Incremental Orders (units)Source: Calculated output
incrementality
Incrementality assumption (decimal rate)Source: User assumption
Retained Orders
retainedOrders = incremental orders × (1 − returns)

Where

incrementalOrders
Incremental Orders (units)Source: Calculated output
retainedOrders
Retained Orders (units)Source: Calculated output
Commissionable Orders
commissionableOrders = incremental orders × (1 − returns × reversal)

Where

incrementalOrders
Incremental Orders (units)Source: Calculated output
commissionableOrders
Commissionable Orders (units)Source: Calculated output
Retained Contribution
retainedContribution = retained orders × pre-commission contribution

Where

retainedOrders
Retained Orders (units)Source: Calculated output
retainedContribution
Retained Contribution (money)Source: Calculated output
Commission Cost
commissionCost = commissionable orders × revenue × rate

Where

commissionRate
Commission rate (decimal rate)Source: Business record
commissionableOrders
Commissionable Orders (units)Source: Calculated output
commissionCost
Commission Cost (money)Source: Calculated output
Program Profit
programProfit = retained contribution − commission − fixed cost

Where

fixedProgramCost
Fixed program cost (currency units on one consistent basis)Source: Business record
retainedContribution
Retained Contribution (money)Source: Calculated output
commissionCost
Commission Cost (money)Source: Calculated output
programProfit
Program Profit (money)Source: Calculated output
Max Commission Rate
maxCommissionRate = commission ceiling when pre-commission contribution covers fixed cost and target

Where

commissionRate
Commission rate (decimal rate)Source: Business record
commissionCost
Commission Cost (money)Source: Calculated output
maxCommissionRate
Max Commission Rate (percent)Source: Calculated output
targetContribution
Target contribution (currency units)Source: User decision
max
Maximum operator (operator)Source: Calculated output
Max Commission Rate State
maxCommissionRateState = reachable unless contribution is insufficient before commission

Where

commissionRate
Commission rate (decimal rate)Source: Business record
maxCommissionRate
Max Commission Rate (percent)Source: Calculated output
maxCommissionRateState
Max Commission Rate State (state)Source: Calculated output
max
Maximum operator (operator)Source: Calculated output
Contribution Shortfall Before Commission
contributionShortfallBeforeCommission = max(0, fixed cost + target contribution − retained contribution)

Where

retainedContribution
Retained Contribution (money)Source: Calculated output
commissionCost
Commission Cost (money)Source: Calculated output
contributionShortfallBeforeCommission
Contribution Shortfall Before Commission (money)Source: Calculated output
targetContribution
Target contribution (currency units)Source: User decision
max
Maximum operator (operator)Source: Calculated output
Commission Headroom
commissionHeadroom = maximum rate − entered rate

Where

commissionRate
Commission rate (decimal rate)Source: Business record
commissionHeadroom
Commission Headroom (percent)Source: Calculated output
Referral programme contribution
referralPeriodContribution = qualifiedReferrals × incrementality × contributionPerReferral − qualifiedReferrals × rewardPerReferral − fixedProgrammeCost

Where

qualifiedReferrals
Qualified referrals (whole referrals)Source: Business record
incrementality
Incrementality assumption (decimal rate)Source: User assumption
contributionPerReferral
Contribution per incremental referral (currency units per referral)Source: Business record
rewardPerReferral
Reward per qualified referral (currency units per referral)Source: User decision
fixedProgrammeCost
Fixed referral programme cost (currency units)Source: Business record
referralPeriodContribution
Referral programme contribution (currency units)Source: Calculated output
Maximum referral reward
maximumReward = max(0, (incrementalContribution − fixedProgrammeCost − targetContribution) ÷ qualifiedReferrals)

Where

qualifiedReferrals
Qualified referrals (whole referrals)Source: Business record
fixedProgrammeCost
Fixed referral programme cost (currency units)Source: Business record
incrementalContribution
Incremental contribution (currency units)Source: Calculated output
targetContribution
Target contribution (currency units)Source: User decision
maximumReward
Maximum referral reward (currency units)Source: Calculated output
max
Maximum operator (operator)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

Worked values below come from the same registered engine and visible default assumptions.

Calculation and outputs

Example

Worked values below come from the same registered engine and visible default assumptions.

Incremental Orders
140
Retained Orders
126
Commissionable Orders
126
Retained Contribution
5,040.00 currency units
Commission Cost
1,260.00 currency units
Program Profit
3,480.00 currency units
Max Commission Rate
27.6%
Max Commission Rate State
Unreachable
Contribution Shortfall Before Commission
0.00 currency units
Commission Headroom
17.6%

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

Interpretation

Program profit shows retained contribution after commission, returns treatment and fixed programme cost.

3. Validation and boundary checks

  • All inputs must be finite and non-negative unless the formula explicitly permits a negative calculated profit or gap.
  • Rates must remain between 0% and 100%; horizons and declared counts use the exact whole-number boundaries shown by the inputs.
  • Zero denominators return an explicit unreachable state rather than Infinity, NaN or a numeric sentinel.
  • Compared records must use one consistent attribution, contribution, period and currency basis.

4. Assumptions and source classification

  • Retention, conversion, attribution and incrementality are user assumptions rather than causal claims.
  • Customer value is contribution-based and bounded to the selected finite horizon.
  • No provider rate, market benchmark, country rule or policy constant is embedded.
  • The embedded referral workflow pays rewards on every qualified referral while recognising contribution only for the user-entered incremental share.

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 workflow does not forecast demand, retention, conversion or campaign performance.
  • It does not replace financial, accounting, tax or legal advice.

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