What percentage of revenue is a typical COPQ figure?

Companies running informal quality systems often sit at 15 to 25 percent of revenue, while organizations with mature programs reach 5 to 10 percent, and best-in-class operations hit 2 to 4 percent. If your calculated COPQ lands above 15 percent, most of it is usually failure cost, not appraisal or prevention. Use the percentage as your headline metric in management reviews because it normalizes cost across periods with different sales volumes.

What is the difference between internal and external failure costs?

Internal failure happens before the product ships: scrap, rework, reinspection, and downgrading. External failure happens after delivery: warranty claims, returns, customer credits, field service, and recalls. External failure typically costs 5 to 10 times more per defect because it adds freight, administration, and reputation damage. Shifting spend from external to internal detection, and ultimately to prevention, is the core goal COPQ tracking is meant to drive.

What are the four categories of quality cost?

Prevention, appraisal, internal failure, and external failure, known as the PAF model. Prevention stops defects (training, FMEA, supplier development). Appraisal finds them (inspection, testing, audits). Internal and external failure are the consequences. Prevention and appraisal are cost of good quality; the two failure buckets are cost of poor quality. In a healthy program prevention plus appraisal rises while failure costs fall, lowering total COPQ overall.

How do I build a business case for a quality investment using COPQ?

Baseline your current COPQ, then estimate how much a specific investment reduces failure cost. If external failure is 200,000 dollars a year and a 40,000 dollar prevention project cuts it 60 percent, you save 120,000 for a net 80,000 gain and a 2 to 1 return. Put the projected before-and-after figures in the period columns and the assumptions in notes so finance can audit the payback calculation.

Should I include the cost of downtime caused by quality problems?

Yes, when quality defects cause the stoppage. Line downtime for a rework loop, a containment sort, or a supplier reject belongs in internal failure cost. Value it at the fully loaded line rate, often 500 to 2,000 dollars per hour depending on the operation. Do not double count downtime already captured elsewhere. Note the assumption in the notes column so the figure is defensible when someone challenges the COPQ total.

How often should I update the COPQ tracker?

Quarterly matches most management review cycles and smooths out monthly noise in warranty and scrap data. Monthly works if you have clean ERP data and want faster feedback on an improvement project. Whatever cadence you choose, keep the revenue basis and cost definitions identical across periods, otherwise your period-over-period comparison is meaningless. Lock the category definitions in a legend row so different people entering data stay consistent.

Quality and Inspection

Cost of Poor Quality Spreadsheet Template

Measure total cost of poor quality by summing internal failure, external failure, appraisal, and prevention costs across a period.

Overview

This template quantifies Cost of Poor Quality for quality managers, plant controllers, and continuous improvement leads building a business case. Guesswork understates the true cost because most people only see scrap. A spreadsheet that sums internal failure, external failure, appraisal, and prevention forces the hidden costs into view: the rework labor, the warranty credits, the extra inspection headcount. Seeing COPQ as a percentage of revenue turns a vague quality problem into a dollar figure management will act on.

You enter costs under four categories. Internal failure captures scrap, rework, and reinspection. External failure captures returns, warranty, and customer credits. Appraisal captures inspection labor and test equipment. Prevention captures training, audits, and process work. The template totals all four and divides by period revenue to give COPQ as a percentage. Period-over-period columns show direction, and the notes column records the drivers behind each spike so a variance has an explanation, not a shrug.

In practice, pull the four categories from your ERP, payroll, and warranty ledger each quarter, then present the COPQ percentage in the management review. Use it to justify investment: if raising prevention spend by 30,000 dollars cuts external failure by 120,000, the notes column documents the return. Track the shift from failure costs toward prevention costs over time. Pair it with the Cost of Poor Quality Calculator to model a single scenario before committing the full-period data.

What this template includes

Internal failure costs (scrap, rework, reinspection)
External failure costs (returns, warranty, customer credits)
Appraisal costs (inspection labor, test equipment)
Prevention costs (training, audits, process improvement)
COPQ total and as a percentage of revenue
Period-over-period comparison
Notes column for major drivers

Suggested use case

Use this for a quarterly quality cost report, a business case for a quality improvement investment, or a management review presentation.

How to use it

Enter cost data under each of the four COPQ categories.
Enter revenue for the period to calculate COPQ as a percentage.
Compare periods to show improvement or degradation.
Use the notes column to explain major variances.

Frequently Asked Questions

What percentage of revenue is a typical COPQ figure?: Companies running informal quality systems often sit at 15 to 25 percent of revenue, while organizations with mature programs reach 5 to 10 percent, and best-in-class operations hit 2 to 4 percent. If your calculated COPQ lands above 15 percent, most of it is usually failure cost, not appraisal or prevention. Use the percentage as your headline metric in management reviews because it normalizes cost across periods with different sales volumes.
What is the difference between internal and external failure costs?: Internal failure happens before the product ships: scrap, rework, reinspection, and downgrading. External failure happens after delivery: warranty claims, returns, customer credits, field service, and recalls. External failure typically costs 5 to 10 times more per defect because it adds freight, administration, and reputation damage. Shifting spend from external to internal detection, and ultimately to prevention, is the core goal COPQ tracking is meant to drive.
What are the four categories of quality cost?: Prevention, appraisal, internal failure, and external failure, known as the PAF model. Prevention stops defects (training, FMEA, supplier development). Appraisal finds them (inspection, testing, audits). Internal and external failure are the consequences. Prevention and appraisal are cost of good quality; the two failure buckets are cost of poor quality. In a healthy program prevention plus appraisal rises while failure costs fall, lowering total COPQ overall.
How do I build a business case for a quality investment using COPQ?: Baseline your current COPQ, then estimate how much a specific investment reduces failure cost. If external failure is 200,000 dollars a year and a 40,000 dollar prevention project cuts it 60 percent, you save 120,000 for a net 80,000 gain and a 2 to 1 return. Put the projected before-and-after figures in the period columns and the assumptions in notes so finance can audit the payback calculation.
Should I include the cost of downtime caused by quality problems?: Yes, when quality defects cause the stoppage. Line downtime for a rework loop, a containment sort, or a supplier reject belongs in internal failure cost. Value it at the fully loaded line rate, often 500 to 2,000 dollars per hour depending on the operation. Do not double count downtime already captured elsewhere. Note the assumption in the notes column so the figure is defensible when someone challenges the COPQ total.
How often should I update the COPQ tracker?: Quarterly matches most management review cycles and smooths out monthly noise in warranty and scrap data. Monthly works if you have clean ERP data and want faster feedback on an improvement project. Whatever cadence you choose, keep the revenue basis and cost definitions identical across periods, otherwise your period-over-period comparison is meaningless. Lock the category definitions in a legend row so different people entering data stay consistent.