Methodology
Service Level Cost Planner methodology
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
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
expectedRetainedCustomers = orders ร expected retention upliftWhere
- 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
retentionContribution = expected retained customers ร contribution per retained customerWhere
- 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
netServiceLevelBenefit = retention contribution โ incremental service cost โ implementation costWhere
- 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
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
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
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
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
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
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
- : 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.
- Small-Business Profitability: Read the Profit Layers
Separate contribution, gross profit and operating profit so each result supports the decision it actually measures.
Read guide