Act on the result
Target the largest controllable failure category and define how the prevention result will be measured.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
Businesses reconciling prevention, inspection, rework, scrap, warranty and complaint cost.
Cost-of-quality components, total failure cost, scenario savings and prevention payback.
Enter each quality-cost category once for the same period, then test a separate prevention scenario.
Use a different tool when: Do not use this to test the savings, capacity value and payback of a process improvement; use Process Improvement Payback Planner for that decision. Use this tool to quantify prevention, appraisal, internal failure and external failure economics.
Profit & break-even
Cost-of-quality components, total failure cost, scenario savings and prevention payback.
Amounts use the same currency as your inputs. No currency conversion is performed.
Reconcile scrap, rework labour, warranty cost and recovered value before testing the affordable spend and net benefit of a quality-prevention programme.
Your numbers stay in this browser
Enter the whole units produced in the decision period.
Enter the observed share of units that currently fail.
Enter material and disposal cost attributable to one failed unit. Use one consistent ex-tax currency basis.
Enter labour hours required to correct one failed unit.
Include wages and relevant employer on-costs for one rework hour. Use one consistent ex-tax currency basis.
Enter expected fulfilment, replacement or support cost per failed unit. Use one consistent ex-tax currency basis.
Enter salvage or resale value recovered from one failed unit. Use one consistent ex-tax currency basis.
Enter the incremental programme cost for the same decision period. Use one consistent ex-tax currency basis.
Enter the failure-rate scenario after the prevention programme.
Review the operating threshold and incremental comparison on the same entered capacity, cost and demand basis.
Each row names the assumption axis changed from the baseline.
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
produced units ร current failure rate50 unitsUses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โproduced units ร proposed failure rate20 unitsUses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โcurrent failed units ร (scrap cost + rework hours ร loaded labour rate + warranty cost โ recovered value)3,500.00Uses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โproposed failed units ร (scrap cost + rework hours ร loaded labour rate + warranty cost โ recovered value)1,400.00Uses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โmaximum prevention spend โ prevention programme cost1,600.00Uses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โcurrent quality failure cost โ proposed quality failure cost2,100.00Uses the exact shared engine result and only the entered market-neutral operating assumptions. The engine retains raw precision; display formatting does not feed calculation.
Quality Failure Cost Planner formulas โThis calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| failureRate | Enter the observed share of units that currently fail. | decimal fraction of produced units (1 = 100%) | 0 to 1 | Required | 0.05 |
| loadedLabourRate | Include wages and relevant employer on-costs for one rework hour. Use one consistent ex-tax currency basis. | currency units/rework hour, ex tax | 0 to 10000000 | Required | 30 |
| preventionProgrammeCost | Enter the incremental programme cost for the same decision period. Use one consistent ex-tax currency basis. | currency units/decision period, ex tax | 0 to 10000000 | Required | 500 |
| producedUnits | Enter the whole units produced in the decision period. | units/period | 0 to 100000000 | Required | 1000 |
| proposedFailureRate | Enter the failure-rate scenario after the prevention programme. | decimal fraction of produced units (1 = 100%) | 0 to 1 | Required | 0.02 |
| recoveredValuePerFailure | Enter salvage or resale value recovered from one failed unit. Use one consistent ex-tax currency basis. | currency units/failed unit, ex tax | 0 to 10000000 | Required | 5 |
| reworkHoursPerFailure | Enter labour hours required to correct one failed unit. | hours/failure | 0 to 100000000 | Required | 1.5 |
| scrapCostPerFailure | Enter material and disposal cost attributable to one failed unit. Use one consistent ex-tax currency basis. | currency units/failed unit, ex tax | 0 to 10000000 | Required | 20 |
| warrantyCostPerFailure | Enter expected fulfilment, replacement or support cost per failed unit. Use one consistent ex-tax currency basis. | currency units/failed unit, ex tax | 0 to 10000000 | Required | 10 |
Keep prevention and appraisal separate from internal and external failure so the cost-of-quality reconciliation stays auditable.
Data used here
Target the largest controllable failure category and define how the prevention result will be measured.
Retest lower prevention effectiveness, higher external failure cost and delayed savings.
Educational estimate, not advice. See all assumptions & limitations โ
Guides to interpret the decision and its assumptions.
Bridge input cost to accepted output by separating scrap, yield loss and rework without double-counting failure cost.
Read guideTarget the largest controllable failure category and define how the prevention result will be measured.
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.