-
Excel workbook preview
Six Sigma and Statistical Quality
Cost of Poor Quality (COPQ) Calculator
3 downloads per free account, no card needed.
Who this is for
A project lead who must put a money value on the problem for the charter business case, or a manager asked by finance what defects really cost.
What is inside
- 14 sample failure cost elements for a metal fabrication plant, internal and external
- Annual cost = annual quantity x unit cost, with data source and confidence per line
- Expected reduction % per line and live projected annual saving
- Summary sheet: internal, external and hidden cost totals and COPQ as % of revenue
- Bar chart of COPQ by category that redraws from the totals
- Dropdowns for category and confidence, 20 blank cost lines
How to use it: Take quantities from your own records (scrap reports, rework hours, credit notes, warranty claims) and agree the unit costs with finance before you quote the total.
Files & formats
- XLSXcost-of-poor-quality-calculator.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



