Defects Per Million Opportunities (DPMO)

Defects per Million Opportunities factors in the total opportunities for defect occurrence existing in a process. DPMO is considered long-term measurement of a process and this can be directly converted into a long-term Z-statistic (sigma value)

Given:

D: # of defects

O: # of opportunities for a defect

U: # of units

TOP: Total number of opportunities = U * O

Formula:


DPMO = DPO * 1,000,000


NOTE:


DPMO is NOT the same as PPM since it is possible that each unit (part) being appraised may be found to have multiple defects of the same type or may have multiple types of defects. A part is defective if it has one or more defects. The number of defectives can never exceed the number of defects.

IF each part only has one characteristic that can be a defect, then DPMO and PPM will be the same.

DPMO will always exceed or equal PPM for a given yield or sigma level of performance.


Example

Examine the table shown below:

Nail #1 it has two types of defects. Therefore it is ONE defective nail that contains TWO defects.

DPMO Example



SUMMARY OF TABLE

D = 19 total defects

O = 5 opportunities (categories of defect types)

U = 10 nails

TOP = U * O = 50 total opportunities

DPU = D / U = 19/10 = 1.9 defects per unit

DPO = D / TOP = 19/50 = 0.38

DPMO = 380,000

Out of a million opportunities, the long term performance of the process would create 380,000 defects




Using Excel to calculate Sigma and DPMO

There are a couple commonly used Microsoft Excel functions that converts Defects per Million Opportunities (DPMO) to a process sigma (z-score) and vice versa.

To convert from DPMO to process sigma:

Process Sigma = NORMSINV * ( 1 -( DPMO / 1,000,000))+ 1.5

To convert from process sigma to DPMO:

DPMO = 1,000,000 * ( 1 - ( NORMSDIST * (process sigma - 1.5 ))

NOTE:

A Six Sigma quality process refers to the process short-term performance or how it is performing currently when there are 3.4 DPMO. Over the long term, this six sigma process is estimated to shift -1.5 sigma (lower) and will perform at a 4.5 sigma level, which produces 1,350 DPMO.



Get the DPMO Calculator

Enter your values in the white cells and everything else is calculated. Notes are in the actual template that offer more guidance and information on each row.

DPMO, Z-score, TOP, DPU, and more




Find Six Sigma related materials, templates, and pocketbooks

DPMO (and more) Calculator available for your Six Sigma project

Search Six Sigma related jobs

Return to the Six-Sigma-Material Home Page



 Site Membership
CLICK HERE


Six Sigma Green Belt Certification
Black Belt Certification

Six Sigma

Templates & Calculators


Six Sigma Modules

The following presentations are available to download.

Click Here

Green Belt Program (1,000+ Slides)

Basic Statistics

SPC

Process Mapping

Capability Studies

MSA

Cause & Effect Matrix

FMEA

Multivariate Analysis

Central Limit Theorem

Confidence Intervals

Hypothesis Testing

T Tests

1-Way Anova Test

Chi-Square Test

Correlation and Regression

SMED

Control Plan

Kaizen

Error Proofing


Advanced Statistics
in Excel

Advanced Statistics in Excel

Six Sigma & Lean Courses

Agile & Scrum Online Course