Skip to main content

Methodology

Process Improvement Payback Planner methodology

Reconcile labour time saved, incremental throughput contribution and recurring cost before testing the payback of an improvement investment.

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

Hours saved per period
hoursSaved = baseline hours per period ร— hours-saved rate

Where

baselineHoursPerPeriod
Baseline hours per period (hours/period)Source: Business record
hoursSavedRate
Hours saved (decimal fraction of baseline period hours (1 = 100%))Source: User decision
hoursSaved
Hours saved per period (hours/period)Source: Calculated output
Labour saving per period
labourSaving = hours saved ร— loaded labour cost per hour

Where

hoursSavedRate
Hours saved (decimal fraction of baseline period hours (1 = 100%))Source: User decision
loadedLabourRate
Loaded labour cost per hour (currency units/hour, ex tax)Source: Business record
hoursSaved
Hours saved per period (hours/period)Source: Calculated output
labourSaving
Labour saving per period (currency units/period, ex tax)Source: Calculated output
Throughput contribution per period
throughputContribution = incremental throughput units ร— contribution per incremental unit

Where

incrementalThroughputUnits
Incremental throughput units (units/period)Source: User assumption
contributionPerIncrementalUnit
Contribution per incremental unit (currency units/unit, ex tax)Source: Business record
throughputContribution
Throughput contribution per period (currency units/period, ex tax)Source: Calculated output
Net benefit per period
netBenefitPerPeriod = labour saving + throughput contribution โˆ’ recurring period cost

Where

recurringPeriodCost
Recurring improvement cost (currency units/period, ex tax)Source: Business record
labourSaving
Labour saving per period (currency units/period, ex tax)Source: Calculated output
throughputContribution
Throughput contribution per period (currency units/period, ex tax)Source: Calculated output
netBenefitPerPeriod
Net benefit per period (currency units/period, ex tax)Source: Calculated output
Payback periods
paybackPeriods = upfront cost / positive net benefit per period

Where

upfrontCost
Upfront improvement cost (currency units/one-off implementation, ex tax)Source: User decision
netBenefitPerPeriod
Net benefit per period (currency units/period, ex tax)Source: Calculated output
paybackPeriods
Payback periods (periods)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.

Upfront improvement cost
1,000 currency units/one-off implementation, ex tax
Baseline hours per period
100 hours/period
Hours saved
0.2 decimal fraction of baseline period hours (1 = 100%)
Loaded labour cost per hour
40 currency units/hour, ex tax
Incremental throughput units
10 units/period
Contribution per incremental unit
20 currency units/unit, ex tax
Recurring improvement cost
100 currency units/period, ex tax

Calculation and outputs

  1. Hours saved per period

    hoursSaved = baseline hours per period ร— hours-saved rate
    Baseline hours per period
    100 hours/period
    Hours saved
    0.2 decimal fraction of baseline period hours (1 = 100%)
    Loaded labour cost per hour
    40 currency units/hour, ex tax
    Recurring improvement cost
    100 currency units/period, ex tax
    Labour saving per period
    800 currency units/period, ex tax
    Throughput contribution per period
    200 currency units/period, ex tax
    Net benefit per period
    900 currency units/period, ex tax

    Engine result: 20 hours/period

  2. Labour saving per period

    labourSaving = hours saved ร— loaded labour cost per hour
    Upfront improvement cost
    1,000 currency units/one-off implementation, ex tax
    Baseline hours per period
    100 hours/period
    Hours saved
    0.2 decimal fraction of baseline period hours (1 = 100%)
    Loaded labour cost per hour
    40 currency units/hour, ex tax
    Recurring improvement cost
    100 currency units/period, ex tax
    Hours saved per period
    20 hours/period

    Engine result: 800 currency units/period, ex tax

  3. Throughput contribution per period

    throughputContribution = incremental throughput units ร— contribution per incremental unit
    Incremental throughput units
    10 units/period
    Contribution per incremental unit
    20 currency units/unit, ex tax

    Engine result: 200 currency units/period, ex tax

  4. Net benefit per period

    netBenefitPerPeriod = labour saving + throughput contribution โˆ’ recurring period cost
    Upfront improvement cost
    1,000 currency units/one-off implementation, ex tax
    Baseline hours per period
    100 hours/period
    Loaded labour cost per hour
    40 currency units/hour, ex tax
    Incremental throughput units
    10 units/period
    Contribution per incremental unit
    20 currency units/unit, ex tax
    Recurring improvement cost
    100 currency units/period, ex tax
    Hours saved per period
    20 hours/period
    Labour saving per period
    800 currency units/period, ex tax
    Throughput contribution per period
    200 currency units/period, ex tax

    Engine result: 900 currency units/period, ex tax

  5. Payback periods

    paybackPeriods = upfront cost / positive net benefit per period
    Upfront improvement cost
    1,000 currency units/one-off implementation, ex tax
    Baseline hours per period
    100 hours/period
    Loaded labour cost per hour
    40 currency units/hour, ex tax
    Recurring improvement cost
    100 currency units/period, ex tax
    Hours saved per period
    20 hours/period
    Labour saving per period
    800 currency units/period, ex tax
    Throughput contribution per period
    200 currency units/period, ex tax
    Net benefit per period
    900 currency units/period, ex tax

    Engine result: 1.111111 periods

Example

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

Hours saved per period
20 hours
Labour saving per period
800.00
Throughput contribution per period
200.00
Net benefit per period
900.00
Payback periods
1.11 periods

The payback periods is 1.11 periods.

Interpretation

Measured savings and optional capacity value should remain separate so payback is not overstated.

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.
Upfront improvement cost minimum
upfrontCost โ‰ฅ 0 currency units/one-off implementation, ex tax โ€” A lower value is rejected before calculation.
Upfront improvement cost maximum
upfrontCost โ‰ค 10,000,000 currency units/one-off implementation, ex tax โ€” A higher value is rejected before calculation.
Baseline hours per period minimum
baselineHoursPerPeriod โ‰ฅ 0 hours/period โ€” A lower value is rejected before calculation.
Baseline hours per period maximum
baselineHoursPerPeriod โ‰ค 100,000,000 hours/period โ€” A higher value is rejected before calculation.
Hours saved minimum
hoursSavedRate โ‰ฅ 0 decimal fraction of baseline period hours (1 = 100%) โ€” A lower value is rejected before calculation.
Hours saved maximum
hoursSavedRate โ‰ค 1 decimal fraction of baseline period hours (1 = 100%) โ€” A higher value is rejected before calculation.
Loaded labour cost per hour minimum
loadedLabourRate โ‰ฅ 0 currency units/hour, ex tax โ€” A lower value is rejected before calculation.
Loaded labour cost per hour maximum
loadedLabourRate โ‰ค 10,000,000 currency units/hour, ex tax โ€” A higher value is rejected before calculation.
Incremental throughput units minimum
incrementalThroughputUnits โ‰ฅ 0 units/period โ€” A lower value is rejected before calculation.
Incremental throughput units maximum
incrementalThroughputUnits โ‰ค 100,000,000 units/period โ€” A higher value is rejected before calculation.
Contribution per incremental unit minimum
contributionPerIncrementalUnit โ‰ฅ 0 currency units/unit, ex tax โ€” A lower value is rejected before calculation.
Contribution per incremental unit maximum
contributionPerIncrementalUnit โ‰ค 10,000,000 currency units/unit, ex tax โ€” A higher value is rejected before calculation.
Recurring improvement cost minimum
recurringPeriodCost โ‰ฅ 0 currency units/period, ex tax โ€” A lower value is rejected before calculation.
Recurring improvement cost maximum
recurringPeriodCost โ‰ค 10,000,000 currency units/period, 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 Process Improvement Payback planner and methodology.

Guides to interpret the decision and its assumptions.

Return to the planner