Methodology
Process Improvement Payback 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
hoursSaved = baseline hours per period ร hours-saved rateWhere
- 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
labourSaving = hours saved ร loaded labour cost per hourWhere
- 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
throughputContribution = incremental throughput units ร contribution per incremental unitWhere
- 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
netBenefitPerPeriod = labour saving + throughput contribution โ recurring period costWhere
- 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
paybackPeriods = upfront cost / positive net benefit per periodWhere
- 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
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
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
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
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
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
- : Initial public release of the Process Improvement Payback planner and methodology.
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