VanillaPM
Sign in Get started free Dashboard
Free calculator

Cost of quality calculator

A free cost of quality (CoQ) calculator. Enter prevention, appraisal, internal and external failure costs to see conformance against failure, the total cost of quality, each share, and the cost as a share of the budget.

Cost of quality
Conformanceprevention + appraisal
Failureinternal + external
Conformance sharehigher is usually healthier
  • Prevention
  • Appraisal
  • Internal failure
  • External failure
Conformance = prevention + appraisal
Failure = internal + external
Cost of quality = conformance + failure
Conformance share = conformance ÷ total
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

The four kinds of quality cost

Cost of quality is everything a project spends because quality matters, in four groups:

  • Prevention: stopping defects before they happen (training, design reviews, mock-ups).
  • Appraisal: finding defects (inspection, testing, audits).
  • Internal failure: fixing defects you found before handover (rework, scrap, re-testing).
  • External failure: defects the customer found (warranty work, repairs, claims, lost goodwill).

The first two are the cost of conformance, money spent to get it right. The last two are the cost of non-conformance, money spent because it was wrong.

Reading the result

A higher conformance share usually means a healthier project: a unit spent on prevention tends to save several on failure, and external failure is the most expensive of all because the customer saw it. If failure costs dominate, more prevention or earlier inspection usually pays for itself.

Cost of quality as a share of the budget helps you set an honest quality budget next time.

How VanillaPM uses it

In a project's quality workspace each quality cost is logged under its group, and VanillaPM keeps the same totals and flags prevention or appraisal work that has no budget line behind it.

Common mistakes

  • Counting only failures. Prevention and appraisal are part of the cost of quality too.
  • Forgetting external failure because it arrives after handover. Warranty claims belong to the project that caused them.

See it used on a real project: Pr7 · Plan and optimise quality