Cost of Poor Quality Calculator
Put a dollar figure on the quality problems hiding inside your process. Enter your failure, appraisal and prevention costs, then see COPQ as a percent of revenue, a ranked Pareto of your cost drivers and the savings available if you hit your target.
💰 What this calculator does
Cost of poor quality is the money you spend because your process does not get it right first time. This calculator collects every quality cost you carry across four categories, adds them up and shows the total as a percent of revenue. It then ranks your cost drivers so you know which one to attack first.
Most finance systems hide these costs. Scrap sits in materials. Rework sits in labour. Warranty sits in customer service. Lost sales never get recorded at all. Pulling them into one number changes the conversation with your executive team, because a percentage of revenue is language they already use.
The calculator works from raw dollar inputs. You enter what each cost element actually costs you in a year and the tool derives every ratio, benchmark and saving from those numbers. Nothing is pre-aggregated and nothing is estimated on your behalf.
📐 The other formulas the tool runs
- Failure costs equal internal failure plus external failure.
- Conformance costs equal appraisal plus prevention.
- Prevention to failure ratio equals prevention costs divided by failure costs.
- Escape ratio equals external failure divided by internal failure.
- Recovery opportunity equals current COPQ minus revenue multiplied by your target percent.
🧾 The four cost categories
Internal failure
Defects you catch before the customer does. Scrap, rework, retesting, downtime and yield loss. Painful but cheap compared with the alternative.
External failure
Defects the customer catches. Warranty, returns, complaints, recalls, lost sales and liability. The most expensive money you will ever spend.
Appraisal
The cost of checking. Inspection, testing, audits, calibration and documentation review. Necessary, but it finds problems rather than stopping them.
Prevention
The cost of stopping defects before they happen. Quality planning, training, improvement projects, quality systems and supplier development.
📋 How to use it
- Get your annual revenue, headcount and annual output volume from finance. Use the same twelve month window for every figure you enter.
- Set your target COPQ percent. Ten percent of revenue is a sensible first target for most organisations. Five percent is world class.
- Enter internal failure costs. Ask production and operations for scrap value, rework hours multiplied by the loaded labour rate, and downtime cost.
- Enter external failure costs. Warranty and returns come from finance. Lost sales come from your sales team and churn data.
- Enter appraisal costs. Count inspector salaries, laboratory costs, audit time and calibration contracts.
- Enter prevention costs. Count training spend, improvement project budgets, quality planning time and supplier development programmes.
- Click Calculate COPQ. Review the headline percentage, the Pareto table and the recommended actions.
- Export the Excel report and attach it to your project charter or business case.
📊 COPQ benchmark bands
| Band | COPQ as percent of revenue | Typical sigma level | What it means |
|---|---|---|---|
| World class | Under 5 percent | Above 5 sigma | Quality is designed in. Prevention spend outweighs failure spend. |
| Competitive | 5 to 10 percent | Around 4.5 sigma | Strong control. Remaining cost sits in a small number of drivers. |
| Average | 10 to 20 percent | Around 4 sigma | Detection led. Most spend goes on finding and fixing, not preventing. |
| Weak | 20 to 30 percent | Around 3 sigma | The hidden factory is large. A DMAIC programme pays for itself quickly. |
| Critical | Above 30 percent | Below 3 sigma | Quality cost is eating margin. Treat this as a board level issue. |
Sigma levels shown are the commonly quoted cost of quality equivalents. They give you a rough position, not a measured process capability. Run the Process Sigma Level Calculator for a measured figure.
✨ Pro tips
- Count rework in loaded labour hours, not raw wages. Include supervision, overheads and the machine time you lost.
- Estimate lost sales with your sales team rather than leaving the field blank. A conservative number beats a missing one.
- Track the prevention to failure ratio over time. It moves before the total COPQ does, so it is your leading indicator.
- Run this calculator once per quarter with the same definitions. Trend matters more than the absolute figure.
- Split the analysis by product line or site if your operation is large. One combined number hides the worst performer.
- Take the top three cost drivers straight into your project selection matrix. That is the fastest route from measurement to action.
⚠️ Common mistakes
- Counting only scrap. Scrap is usually less than a quarter of true COPQ. The rest hides in labour, delay and lost customers.
- Mixing time periods. A twelve month revenue figure against six months of warranty data doubles your apparent performance.
- Treating appraisal spend as prevention. Inspection finds defects. It does not stop them.
- Ignoring lost sales and reputation damage because they are hard to measure. Hard to measure is not the same as zero.
- Cutting appraisal spend before the process is capable. That simply moves internal failure into external failure.
🧭 Where this sits in DMAIC
This is a Measure phase tool with a strong Define phase use. In Define you use COPQ to size the prize and justify the project charter. In Measure you use it to set the financial baseline that your Control phase will be judged against. In Control you rerun it to prove the saving is real rather than claimed.
📥 Load a sample dataset
Load an industry example to see how the model behaves, then replace it with your own cost data.
🏢 Business context
Every ratio in the results comes from these four numbers plus your cost inputs. Use one consistent twelve month period.
🧾 Quality cost inputs
Enter the annual dollar cost of each element. Leave a field blank if you do not carry that cost. Category totals update as you type.
No results yet
Enter your quality costs on the Calculator tab, then click Calculate COPQ.
What is the cost of poor quality
The cost of poor quality is every dollar you would not spend if your process produced a perfect result first time, every time. It covers the obvious costs like scrap and warranty, and the quiet ones like re-inspection, expedited freight, complaint handling and the customer who never came back. Joseph Juran called the unmeasured portion the gold in the mine, because it sits in the process waiting for someone to count it.
Organisations that have never measured it are usually shocked by the result. Quality cost commonly lands between 15 and 25 percent of revenue in businesses without a mature quality programme. In a business turning over 10 million dollars, that is 1.5 to 2.5 million dollars a year spent on getting things wrong and fixing them again.
The four cost of quality categories
The prevention, appraisal and failure model splits quality cost into four buckets. Two of them are failure costs and two of them are conformance costs. The split matters because the four buckets behave differently when you invest in them.
Internal failure costs
Defects caught inside your four walls. Scrap, rework, re-inspection, unplanned downtime, yield loss and failure analysis. Expensive, but far cheaper than letting the defect reach a customer.
External failure costs
Defects that reached the customer. Warranty claims, returns, complaint handling, product recalls, lost sales and legal exposure. These carry a reputation cost that never shows on an invoice.
Appraisal costs
The cost of finding out whether the work is right. Inspection, testing, supplier audits, calibration and documentation review. Appraisal is a filter, not a fix.
Prevention costs
The cost of stopping defects before they happen. Quality planning, training, process improvement, quality management systems and supplier quality programmes. The only category with a positive return.
How to calculate cost of poor quality
Add the four category totals to get total COPQ, then divide by annual revenue and multiply by 100 to express it as a percentage. That percentage is the number your executive team will respond to, because it sits in the same units as margin and growth.
The calculator also derives four diagnostic ratios from the same raw inputs. Failure share tells you how much of your quality spend is reactive. Prevention share tells you how much is proactive. The prevention to failure ratio tells you whether your investment mix will bring the total down. The escape ratio compares external failure with internal failure and tells you whether your defences are holding.
What a good prevention to failure ratio looks like
In detection led organisations, prevention spend often sits below 5 percent of total quality cost while failure costs run above 65 percent. Every dollar goes on finding and fixing. In mature organisations the picture inverts. Prevention runs at 20 to 25 percent of quality cost and total COPQ falls, because defects stop being created in the first place.
A prevention to failure ratio of 0.30 or better usually signals a programme that is heading in the right direction. Below 0.10 means you are paying for failure rather than investing in capability.
Using COPQ to justify a Six Sigma project
COPQ turns an improvement idea into a business case. Take the largest cost driver from the Pareto table, halve it as a conservative target, and you have a benefit figure you can defend. Attach the Excel export to your project charter so the finance business partner can trace every input.
Rerun the calculation at the end of the Control phase using the same definitions. The difference between the two runs is your realised saving, and it is far harder to argue with than a claimed improvement percentage.
Frequently asked questions
What percentage of revenue should COPQ be?
Under 5 percent is world class and 5 to 10 percent is competitive. Between 10 and 20 percent is the average range for organisations without a mature quality programme. Above 25 percent, quality cost is consuming your margin and needs board level attention.
Should prevention and appraisal costs be included in COPQ?
Both definitions are in use. The narrow definition counts only failure costs. This calculator uses the full cost of quality model and includes all four categories, because the mix between them is what tells you whether your spending strategy is working. The results show failure costs separately, so you can quote either figure.
How do I estimate lost sales from poor quality?
Take your churn rate for customers who logged a quality complaint, multiply by average customer lifetime value, then multiply by the number of complaining customers. Use a conservative figure and document the assumption. A defensible estimate is more useful than a blank field.
Why is external failure cost weighted so heavily?
The one to ten to one hundred rule says a defect costs one unit to prevent, ten units to correct internally and one hundred units once it reaches the customer. External failure also carries reputation damage and lost future revenue that never appears in your ledger.
How often should I recalculate COPQ?
Quarterly for an active improvement programme, annually as a minimum. Use identical definitions each time so the trend is meaningful. Rerun it immediately after a major process change to capture the effect.
Can I export the results?
Yes. The calculator generates a branded four sheet Excel workbook containing a summary, your input data, the Pareto and category analysis, and a prioritised action plan you can hand straight to project owners.
