Skip to main content

Methodology

Service Level Cost Planner methodology

Compare the incremental cost of a higher service level with the contribution from expected retained customers and its break-even retention uplift.

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 service cost
incrementalServiceCost = orders ร— (proposed service cost per order โˆ’ baseline service cost per order)

Where

orders
Orders in decision period (orders/period)Source: Business record
baselineServiceCostPerOrder
Baseline service cost per order (currency units/order, ex tax)Source: Business record
premiumServiceCostPerOrder
Proposed service cost per order (currency units/order, ex tax)Source: User decision
incrementalServiceCost
Incremental service cost (currency units, ex tax)Source: Calculated output
Expected retained customers
expectedRetainedCustomers = orders ร— expected retention uplift

Where

orders
Orders in decision period (orders/period)Source: Business record
expectedRetentionUpliftRate
Expected retention uplift (decimal fraction of decision-period orders (1 = 100%))Source: User decision
expectedRetainedCustomers
Expected retained customers (units)Source: Calculated output
Retention contribution
retentionContribution = expected retained customers ร— contribution per retained customer

Where

retainedCustomerContribution
Contribution per retained customer (currency units/additionally retained customer, ex tax)Source: User assumption
expectedRetainedCustomers
Expected retained customers (units)Source: Calculated output
retentionContribution
Retention contribution (currency units, ex tax)Source: Calculated output
Net service-level benefit
netServiceLevelBenefit = retention contribution โˆ’ incremental service cost โˆ’ implementation cost

Where

implementationCost
Implementation cost (currency units/service-level implementation, ex tax)Source: User decision
incrementalServiceCost
Incremental service cost (currency units, ex tax)Source: Calculated output
retentionContribution
Retention contribution (currency units, ex tax)Source: Calculated output
netServiceLevelBenefit
Net service-level benefit (currency units, ex tax)Source: Calculated output
Break-even retention uplift
breakEvenRetentionUpliftRate = (incremental service cost + implementation cost) / (orders ร— contribution per retained customer)

Where

orders
Orders in decision period (orders/period)Source: Business record
retainedCustomerContribution
Contribution per retained customer (currency units/additionally retained customer, ex tax)Source: User assumption
implementationCost
Implementation cost (currency units/service-level implementation, ex tax)Source: User decision
incrementalServiceCost
Incremental service cost (currency units, ex tax)Source: Calculated output
retentionContribution
Retention contribution (currency units, ex tax)Source: Calculated output
breakEvenRetentionUpliftRate
Break-even retention uplift (decimal rate)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 labelled rows below are formatted directly from the exact shared engine using the visible default inputs.

Orders in decision period
1,000 orders/period
Baseline service cost per order
2 currency units/order, ex tax
Proposed service cost per order
5 currency units/order, ex tax
Expected retention uplift
0.05 decimal fraction of decision-period orders (1 = 100%)
Contribution per retained customer
100 currency units/additionally retained customer, ex tax
Implementation cost
500 currency units/service-level implementation, ex tax

Calculation and outputs

  1. Incremental service cost

    incrementalServiceCost = orders ร— (proposed service cost per order โˆ’ baseline service cost per order)
    Orders in decision period
    1,000 orders/period
    Baseline service cost per order
    2 currency units/order, ex tax
    Proposed service cost per order
    5 currency units/order, ex tax
    Implementation cost
    500 currency units/service-level implementation, ex tax
    Net service-level benefit
    1,500 money

    Engine result: 3,000 money

  2. Expected retained customers

    expectedRetainedCustomers = orders ร— expected retention uplift
    Orders in decision period
    1,000 orders/period
    Expected retention uplift
    0.05 decimal fraction of decision-period orders (1 = 100%)
    Retention contribution
    5,000 money
    Break-even retention uplift
    0.035 percent

    Engine result: 50 units

  3. Retention contribution

    retentionContribution = expected retained customers ร— contribution per retained customer
    Expected retention uplift
    0.05 decimal fraction of decision-period orders (1 = 100%)
    Contribution per retained customer
    100 currency units/additionally retained customer, ex tax
    Expected retained customers
    50 units

    Engine result: 5,000 money

  4. Net service-level benefit

    netServiceLevelBenefit = retention contribution โˆ’ incremental service cost โˆ’ implementation cost
    Baseline service cost per order
    2 currency units/order, ex tax
    Proposed service cost per order
    5 currency units/order, ex tax
    Expected retention uplift
    0.05 decimal fraction of decision-period orders (1 = 100%)
    Contribution per retained customer
    100 currency units/additionally retained customer, ex tax
    Implementation cost
    500 currency units/service-level implementation, ex tax
    Incremental service cost
    3,000 money
    Retention contribution
    5,000 money
    Break-even retention uplift
    0.035 percent

    Engine result: 1,500 money

  5. Break-even retention uplift

    breakEvenRetentionUpliftRate = (incremental service cost + implementation cost) / (orders ร— contribution per retained customer)
    Orders in decision period
    1,000 orders/period
    Baseline service cost per order
    2 currency units/order, ex tax
    Proposed service cost per order
    5 currency units/order, ex tax
    Contribution per retained customer
    100 currency units/additionally retained customer, ex tax
    Implementation cost
    500 currency units/service-level implementation, ex tax
    Incremental service cost
    3,000 money
    Expected retained customers
    50 units
    Retention contribution
    5,000 money
    Net service-level benefit
    1,500 money

    Engine result: 0.035 percent

Example

The labelled rows below are formatted directly from the exact shared engine using the visible default inputs.

Incremental service cost
3,000.00
Expected retained customers
50 units
Retention contribution
5,000.00
Net service-level benefit
1,500.00
Break-even retention uplift
3.5%
Break-even reachability
Reachable within 0%โ€“100%

The net service-level benefit is 1,500.00.

Interpretation

A higher service level is viable only when its incremental contribution protection covers its incremental operating cost.

3. Validation and boundary checks

  • All inputs must be finite and remain inside the visible non-negative validation boundaries.
  • Capacity and demand fields that represent physical units reject fractional values where the engine requires whole units.
  • Rates remain inside the closed range from 0% to 100%.
  • Unreachable contribution, crossover or payback thresholds return an explicit unavailable state rather than Infinity.
  • Option comparisons reject an infeasible option when its entered capacity is below the required workload.
  • The raw break-even retention uplift remains visible even above 100%, while the separate reachability state marks any threshold above the supported 0%โ€“100% input domain as operationally unreachable.
Orders in decision period minimum
orders โ‰ฅ 0 orders/period โ€” A lower value is rejected before calculation.
Orders in decision period maximum
orders โ‰ค 100,000,000 orders/period โ€” A higher value is rejected before calculation.
Baseline service cost per order minimum
baselineServiceCostPerOrder โ‰ฅ 0 currency units/order, ex tax โ€” A lower value is rejected before calculation.
Baseline service cost per order maximum
baselineServiceCostPerOrder โ‰ค 10,000,000 currency units/order, ex tax โ€” A higher value is rejected before calculation.
Proposed service cost per order minimum
premiumServiceCostPerOrder โ‰ฅ 0 currency units/order, ex tax โ€” A lower value is rejected before calculation.
Proposed service cost per order maximum
premiumServiceCostPerOrder โ‰ค 10,000,000 currency units/order, ex tax โ€” A higher value is rejected before calculation.
Expected retention uplift minimum
expectedRetentionUpliftRate โ‰ฅ 0 decimal fraction of decision-period orders (1 = 100%) โ€” A lower value is rejected before calculation.
Expected retention uplift maximum
expectedRetentionUpliftRate โ‰ค 1 decimal fraction of decision-period orders (1 = 100%) โ€” A higher value is rejected before calculation.
Contribution per retained customer minimum
retainedCustomerContribution โ‰ฅ 0 currency units/additionally retained customer, ex tax โ€” A lower value is rejected before calculation.
Contribution per retained customer maximum
retainedCustomerContribution โ‰ค 10,000,000 currency units/additionally retained customer, ex tax โ€” A higher value is rejected before calculation.
Implementation cost minimum
implementationCost โ‰ฅ 0 currency units/service-level implementation, ex tax โ€” A lower value is rejected before calculation.
Implementation cost maximum
implementationCost โ‰ค 10,000,000 currency units/service-level implementation, ex tax โ€” A higher value is rejected before calculation.

4. Assumptions and source classification

  • All operating volumes, rates, workload, capacity, time, cost and contribution values are supplied by the user.
  • Money inputs use one consistent ex-tax basis and every record refers to the same operating period.
  • Demand realisation, recovery, hours saved and expected unit rates are scenarios, not forecasts or benchmarks.
  • Committed sunk cost is disclosed but excluded from make, buy, outsource and hire incremental economics.
  • The shared engine retains raw precision and display formatting never feeds back into calculation.

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

  • Results depend on complete and comparable incremental cost, capacity and operating records.
  • The model does not forecast demand, service quality, employee performance, supplier reliability or disruption duration.
  • A positive result or short payback does not establish implementation feasibility or guarantee a commercial outcome.
  • The planner does not replace operational, 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 planner and methodology after pre-launch calculation, content, source and interaction review.

Guides to interpret the decision and its assumptions.

Return to the planner