Skip to main content

Methodology

Operating Leverage Scenario Planner methodology

Stress-test how a revenue change flows through a fixed and variable cost structure.
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

Baseline Contribution Ex Tax
baselineContributionExTax = baseline revenue × (1 − variable-cost rate)

Where

baselineRevenueExTax
Baseline revenue (currency units/planning period, ex tax)Source: Business record
variableCostRate
Variable-cost rate (proportion of revenue consumed by variable costs)Source: Business record
baselineContributionExTax
Baseline Contribution Ex Tax (currency units, ex tax)Source: Calculated output
Baseline Operating Profit Ex Tax
baselineOperatingProfitExTax = baseline contribution − fixed costs

Where

fixedCostsExTax
Fixed costs (currency units/planning period, ex tax)Source: Business record
baselineContributionExTax
Baseline Contribution Ex Tax (currency units, ex tax)Source: Calculated output
baselineOperatingProfitExTax
Baseline Operating Profit Ex Tax (currency units, ex tax)Source: Calculated output
Scenario Revenue Ex Tax
scenarioRevenueExTax = baseline revenue × (1 + revenue change)

Where

baselineRevenueExTax
Baseline revenue (currency units/planning period, ex tax)Source: Business record
revenueChangeRate
Revenue change (proportional change in revenue versus baseline)Source: User assumption
scenarioRevenueExTax
Scenario Revenue Ex Tax (currency units, ex tax)Source: Calculated output
Scenario Operating Profit Ex Tax
scenarioOperatingProfitExTax = scenario revenue × contribution rate − fixed costs

Where

fixedCostsExTax
Fixed costs (currency units/planning period, ex tax)Source: Business record
scenarioRevenueExTax
Scenario Revenue Ex Tax (currency units, ex tax)Source: Calculated output
scenarioOperatingProfitExTax
Scenario Operating Profit Ex Tax (currency units, ex tax)Source: Calculated output
Operating Profit Change Ex Tax
operatingProfitChangeExTax = scenario profit − baseline profit

Where

baselineOperatingProfitExTax
Baseline Operating Profit Ex Tax (currency units, ex tax)Source: Calculated output
scenarioOperatingProfitExTax
Scenario Operating Profit Ex Tax (currency units, ex tax)Source: Calculated output
operatingProfitChangeExTax
Operating Profit Change Ex Tax (currency units, ex tax)Source: Calculated output
Degree Of Operating Leverage
degreeOfOperatingLeverage = baseline contribution / baseline profit

Where

baselineContributionExTax
Baseline Contribution Ex Tax (currency units, ex tax)Source: Calculated output
baselineOperatingProfitExTax
Baseline Operating Profit Ex Tax (currency units, ex tax)Source: Calculated output
degreeOfOperatingLeverage
Degree Of Operating Leverage (operational units)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 worked rows below come directly from the registered engine and visible default fixture.

Calculation and outputs

Example

The worked rows below come directly from the registered engine and visible default fixture.

Baseline Contribution Ex Tax
225,000 currency units
Baseline Operating Profit Ex Tax
45,000 currency units
Scenario Revenue Ex Tax
550,000 currency units
Scenario Operating Profit Ex Tax
67,500 currency units
Operating Profit Change Ex Tax
22,500 currency units
Degree Of Operating Leverage
5 units

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

Interpretation

Scenario operating profit shows how the entered revenue change flows through the fixed and variable cost structure.

3. Validation and boundary checks

  • All inputs must be finite and within the visible boundaries.
  • Costs, revenue and contribution use one consistent ex-tax basis and planning period.
  • Whole-unit thresholds round upward only where the named engine formula requires it.

4. Assumptions and source classification

  • All prices, costs, demand limits and capacity values are user-supplied records or explicit scenarios.
  • Allocated costs remain visible and separate from avoidable costs.
  • The global workflow infers no market benchmark, policy threshold or future demand.

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 does not forecast demand, implementation timing, service quality or strategic fit.
  • It does not replace accounting, tax, legal or financial 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 Operating Leverage Scenario planner and methodology.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner