For plant & quality leadership

Your cost of poor qualityis real. It’s just scattered.

Scrap, rework, sorting, warranty, and expedite-to-cover-an-escape live in five different GL accounts and are never totaled together — so the number that would make someone act never lands on a desk. This ledger sums all five per cell, projects it monthly and annually, and names the worst cell and the one stream driving it. Summed and attributed, COPQ is undeniable.

Get the Ledger — $99one-time · instant download · yours to keep
Five deliverables · runnable
COPQ ledger engine
Python
Ledger workbook (.xlsx)
.xlsx
COPQ-audit guide
.docx
Cost-reduction runbook
.docx
Six-cell worked sample
.csv
Works alongside
OEE Honesty Grader · PM Deferral Tripwire · Manufacturing Ops Pack
01.The Problem

The most expensive number in the plant is the one nobody adds up.

5 accounts

hold the cost of poor quality — scrap, rework, containment, warranty, expedite. Each looks small alone. Nobody owns the sum.

15–20%

of revenue is where COPQ typically hides in a plant that has never measured it — but you don’t need that stat. You need your own number.

1 stream

often drives most of a cell’s COPQ. A cost that’s one runaway leak is a different fix than diffuse cost — if you can see it.

Every quality consultant arrives with a benchmark: “COPQ is 15–20% of revenue, you’re probably losing millions.” It may be true, and it changes nothing, because a borrowed percentage doesn’t survive contact with a CFO. What survives is your own scrap, your own warranty claims, your own expedite premiums, summed against your own revenue. That’s arithmetic on data you already have — scattered across five accounts that were never meant to be added together.

02.See It Work

Sum a cell. Watch a modest 7.7% still read BLEEDING.

Live ledger · evaluated 2026-06-30

BLEEDING
7.7%
COPQ of revenue
Total COPQ
$69,000
Monthly
$23,000
Annual
$276,000
Dominant
Warranty/returns 75%

Fix: Attack Warranty/returns — it is 75% of this cell’s COPQ ($52,000)

One stream is both dominant (≥60% of COPQ) and over the $25,000 floor — a concentrated leak forces BLEEDING regardless of the ratio. Diversify or reduce it and the cell releases to its ratio band.

Every dollar is your own input — no industry multiplier. Scores a cost structure, never a person.

The worked cell runs at 7.7% COPQ — the kind of number that reads as background noise — yet it’s BLEEDING, because warranty alone is 75% of its cost and over the dollar floor. A cost that’s one runaway stream is a fire the ratio hides. Fix the warranty stream and the same cell releases to CONTROLLED. Every dollar is a figure you enter; nothing is invented.

03.The Engine

One command consolidates the ledger and names the cell to fix first.

$ python3 copq_ledger.py sample_cells.csv --as-of 2026-06-30
======================================================================
COST-OF-POOR-QUALITY LEDGER  -  RedHub AI  (CPQ-099)
Evaluation date: 2026-06-30
======================================================================

Cell: Weld cell A
  Streams (scrap/rework/contain/warranty/expedite):
    $4,000 / $6,000 / $3,000 / $52,000 / $4,000
  Total COPQ / COPQ%              : $69,000 / 7.7%
  Monthly / Annual (projected)   : $23,000 / $276,000
  Dominant stream                : Warranty/returns (75.4%)  <- concentrated leak
  VERDICT                        : BLEEDING
  Fix                            : Attack Warranty/returns - it is 75% of this cell's COPQ ($52,000)

Cell: Weld cell A (warranty fixed)
  Streams (scrap/rework/contain/warranty/expedite):
    $4,000 / $6,000 / $3,000 / $9,000 / $4,000
  Total COPQ / COPQ%              : $26,000 / 2.9%
  Monthly / Annual (projected)   : $8,667 / $104,000
  Dominant stream                : Warranty/returns (34.6%)
  VERDICT                        : CONTROLLED

Cell: Machining cell B
  Streams (scrap/rework/contain/warranty/expedite):
    $38,000 / $22,000 / $9,000 / $7,000 / $6,000
  Total COPQ / COPQ%              : $82,000 / 6.8%
  Monthly / Annual (projected)   : $27,333 / $328,000
  Dominant stream                : Scrap (46.3%)
  VERDICT                        : COST DRAG
  Fix                            : Reduce Scrap first (largest stream)

Cell: Assembly cell C
  Streams (scrap/rework/contain/warranty/expedite):
    $9,000 / $7,000 / $5,000 / $3,000 / $2,000
  Total COPQ / COPQ%              : $26,000 / 3.5%
  Monthly / Annual (projected)   : $8,667 / $104,000
  Dominant stream                : Scrap (34.6%)
  VERDICT                        : CONTROLLED

Cell: Paint line D
  Streams (scrap/rework/contain/warranty/expedite):
    $3,000 / $2,500 / $2,000 / $1,500 / $1,000
  Total COPQ / COPQ%              : $10,000 / 1.7%
  Monthly / Annual (projected)   : $3,333 / $40,000
  Dominant stream                : Scrap (30.0%)
  VERDICT                        : CONTROLLED

Cell: Final QC gate
  Streams (scrap/rework/contain/warranty/expedite):
    $52,000 / $41,000 / $60,000 / $38,000 / $29,000
  Total COPQ / COPQ%              : $220,000 / 14.7%
  Monthly / Annual (projected)   : $73,333 / $880,000
  Dominant stream                : Containment (27.3%)
  VERDICT                        : BLEEDING

----------------------------------------------------------------------
PLANT QUALITY-COST VERDICT : MARGIN BLEEDING
Org COPQ (monthly/annual)  : $144,333 / $1,732,000
Fix first (worst cell)     : Final QC gate (annual $880,000, dominant Containment)
----------------------------------------------------------------------
Every dollar is your own input - no industry multiplier. Scores a
cost structure, never a person. Not accounting, tax, or engineering
advice.

Stdlib-only Python. It sums the five streams, projects monthly and annual, flags the concentrated leak, and rolls the plant up worst-cell-wins. The workbook reproduces these exact figures, and the demo above computes the identical numbers — verified byte-for-byte on the shipped sample.

04.The Standard

Three rules keep the number defensible.

Consolidate what's scattered

The five streams live in five accounts. The product's whole job is to total them per cell and project the figure — because the sum, not the parts, is what forces a decision.

Attribute to a cell and a stream

A plant-wide COPQ number is a shrug. This names the worst cell by annual dollars and the single stream driving it, so the fix has an address.

Your dollars, your denominator

Every figure is your own input; COPQ% is against your own revenue. No industry multiplier, no invented per-unit cost — which is what makes the number survive a finance review.

05.What It Is — And Isn't

A consolidation ledger, not an accounting system or a benchmark.

What it is
  • A deterministic, offline ledger you run on figures you already have.
  • A monthly and annual COPQ projection per cell, with the worst cell named.
  • A pointer to the one cost stream to attack first in each bleeding cell.
What it isn’t
  • Not an accounting system — it consolidates figures, it doesn’t book entries.
  • It scores a cost structure, never a person or a named supplier.
  • No baked-in benchmark; every dollar and tolerance is yours. Not accounting, tax, or engineering advice.
06.Who It's For

Anyone who owns a margin the plant is quietly spending.

Built for
  • Quality and operations leaders who suspect COPQ is large but can't size it
  • Plant managers building the business case for a quality investment
  • CI and Lean teams choosing which cell and which stream to attack first
  • Controllers and consultants who need a figure built from real numbers
Not built for
  • Booking journal entries — it consolidates, it doesn't post to the GL
  • Ranking operators or suppliers — it scores a cost structure, not people
  • Quoting an industry COPQ percentage — it computes yours from your data
  • Replacing your ERP's cost accounting — it totals what the ERP keeps apart
08.Common Questions

The honest answers.

Most ERP reports show the streams separately — scrap in one account, warranty in another, expedite freight buried in logistics — and never total them against the cell that caused them. The whole problem with cost of poor quality is that it’s scattered across five general-ledger accounts, so no single number ever lands on anyone’s desk. This ledger sums all five per cell, projects the figure monthly and annually, and names the worst cell and the stream driving it. Consolidation and attribution are the product; a stream-by-stream report is exactly what leaves the money invisible.

Put the whole number
on one desk.

One purchase, lifetime access, 12 months of updates. $99, once.

Sold by RedHub AI LLC · Secured by Stripe · redhub.ai