---
title: Defects Per Million Opportunities | DPMO | Calculator
description: Get the DPMO (Defects Per Million Opportunities) calculator template and quickly convert an Apples to Oranges comparison to an Apples to Apples normalized comparison using the concept of DPMO and Lean Six Sigma.  With DPMO and the provided Six Sigma table you will know how your product sigma level.
image: https://www.sapbwconsulting.com/hubfs/Lean%20Six%20Sigma%20DPMO%20Calculator/Lean%20Manufacturing%20on%20the%20Mechanism%20of%20Metal%20Gears..jpeg
---

# How to calculate your DPMO

## Do You Need to Know How to Calculate the Defects Per Million Opportunities (DPMO) of your Products or Processes?

### Did You Know You Can Do a DPMO on Budgeting Processes, Say for a [SAP Project](https://www.sapbwconsulting.com/blog/how-to-set-the-scope-of-your-sap-refx-project)?

Many [SAP customers](https://www.sapbwconsulting.com/blog/inbound-marketing/how-to-uncover-sap-services-opportunities) have embarked on a lean six sigma effort.  But they find they need a common way to measure quality in order to determine which sigma level they are operating at.  

![Lean Manufacturing Six Sigma](https://www.sapbwconsulting.com/hs-fs/hubfs/Lean%20Six%20Sigma%20DPMO%20Calculator/Lean%20Manufacturing%20on%20the%20Mechanism%20of%20Metal%20Gears..jpeg?width=1000&name=Lean%20Manufacturing%20on%20the%20Mechanism%20of%20Metal%20Gears..jpeg)

## Defects Per Million Opportunities (DPMO)  

### What Is DPMO and How Do You Use It?

DPMO (Defects Per Million Opportunities) is a measure used in quality management to assess how often errors occur in a process, relative to the number of chances for those errors to happen.

**Analogy**: Imagine you run a bakery that produces cookies. Every time you bake a batch, you have a checklist with 1,000 specific things that could potentially go wrong (like burning the cookies or adding too much sugar). If you bake 1,000 batches and find that 10 things went wrong across all those batches, you would have 10 defects out of 1,000,000 opportunities (since 1,000 batches x 1,000 opportunities per batch = 1,000,000).

So, in simple terms, DPMO tells you how many defects you would expect to find if you had 1 million opportunities for something to go wrong. The lower the DPMO, the better the quality of the process.

## Want to Know How to Calculate DPMO From Sigma Level

In order to both determine what any specific product's sigma level is or in order to compare 2 or more item's quality, you need a common [way to measure](https://www.sapbwconsulting.com/blog/14-sap-business-planning-best-practices) their quality level.  And thus was born the concept of **Defects Per Million Opportunities or DPMO**.  With this tool, you can:

- Convert varying levels of **defects per unit produced** into a 'universally comparable' number
- **Measure defects and sigma levels** for both manufactured products as well as processes, such as [processing a check](https://www.sapbwconsulting.com/sap-fico-consulting)
- Convert Apples-to-Oranges comparison's to Apples-to-Apples

 

You can get your free copy of this simple yet powerful, proven tool from the world of **Total Quality Management** by completing the form on the right.

![SAP](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/960101754/?value=0&guid=ON&script=0) 

![](https://www.facebook.com/tr?id=199270410761059&ev=PageView&noscript=1)

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage",
  "@type" : "WebPage",
  "about" : [ {
    "@type" : "Thing",
    "name" : "Defects per million opportunities (DPMO)",
    "sameAs" : "https://en.wikipedia.org/wiki/Defects_per_million_opportunities"
  }, {
    "@type" : "Thing",
    "name" : "Six Sigma",
    "sameAs" : "https://en.wikipedia.org/wiki/Six_Sigma"
  }, {
    "@type" : "Thing",
    "name" : "Process capability",
    "sameAs" : "https://en.wikipedia.org/wiki/Process_capability_index"
  }, {
    "@type" : "Thing",
    "name" : "Defect (quality)",
    "sameAs" : "https://en.wikipedia.org/wiki/Product_defect"
  }, {
    "@type" : "Thing",
    "name" : "Opportunity (quality)",
    "sameAs" : "https://en.wikipedia.org/wiki/Defects_per_million_opportunities"
  }, {
    "@type" : "Thing",
    "name" : "Yield (manufacturing)",
    "sameAs" : "https://en.wikipedia.org/wiki/Yield_(engineering)"
  }, {
    "@type" : "Thing",
    "name" : "Sigma level",
    "sameAs" : "https://en.wikipedia.org/wiki/Sigma_level"
  } ],
  "audience" : {
    "@type" : "Audience",
    "audienceType" : "Quality Managers, Six Sigma Practitioners, Manufacturing Engineers"
  },
  "breadcrumb" : {
    "@type" : "BreadcrumbList",
    "itemListElement" : [ {
      "@type" : "ListItem",
      "item" : "https://www.sapbwconsulting.com/",
      "name" : "Home",
      "position" : 1
    }, {
      "@type" : "ListItem",
      "item" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator",
      "name" : "DPMO Calculator",
      "position" : 2
    } ]
  },
  "description" : "Use the online DPMO calculator and download the free template to measure process performance (DPO, DPMO, and sigma level).",
  "headline" : "Defects Per Million Opportunities (DPMO) Calculator",
  "isPartOf" : {
    "@id" : "https://www.sapbwconsulting.com#website"
  },
  "mainEntity" : [ {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#app"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#template"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#inputs"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#howto"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#faq"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#offer-app"
  }, {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#offer-doc"
  }, {
    "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person"
  } ],
  "mentions" : [ {
    "@type" : "Thing",
    "name" : "Quality management",
    "sameAs" : "https://en.wikipedia.org/wiki/Quality_management"
  }, {
    "@type" : "Thing",
    "name" : "Lean manufacturing",
    "sameAs" : "https://en.wikipedia.org/wiki/Lean_manufacturing"
  }, {
    "@type" : "Thing",
    "name" : "Process improvement",
    "sameAs" : "https://en.wikipedia.org/wiki/Business_process_improvement"
  }, {
    "@type" : "Thing",
    "name" : "Statistical process control",
    "sameAs" : "https://en.wikipedia.org/wiki/Statistical_process_control"
  }, {
    "@type" : "Thing",
    "name" : "Defects per unit (DPU)",
    "sameAs" : "https://en.wikipedia.org/wiki/Quality_control"
  }, {
    "@type" : "Thing",
    "name" : "Parts per million (PPM)",
    "sameAs" : "https://en.wikipedia.org/wiki/Parts-per_notation"
  } ],
  "name" : "Defects Per Million Opportunities (DPMO) Calculator",
  "potentialAction" : [ {
    "@type" : "ViewAction",
    "name" : "Use the DPMO Calculator (Web)",
    "target" : {
      "@type" : "EntryPoint",
      "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ],
      "urlTemplate" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator"
    }
  }, {
    "@type" : "DownloadAction",
    "name" : "Download the DPMO Calculator Template",
    "target" : {
      "@type" : "EntryPoint",
      "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ],
      "urlTemplate" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#form"
    }
  } ],
  "primaryImageOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#image"
  },
  "publisher" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  },
  "subjectOf" : {
    "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#offercatalog"
  },
  "url" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#image",
  "@type" : "ImageObject",
  "caption" : "DPMO Calculator screenshot",
  "url" : "https://www.sapbwconsulting.com/hubfs/dpmo-calculator.png"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#app",
  "@type" : "WebApplication",
  "applicationCategory" : "BusinessApplication",
  "applicationSubCategory" : "Quality & Six Sigma",
  "author" : {
    "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person"
  },
  "browserRequirements" : "Requires a modern web browser with JavaScript enabled",
  "featureList" : [ "Computes DPO = defects / (units × opportunities per unit)", "Computes DPMO = DPO × 1,000,000", "Indicates approximate sigma level via reference table", "Pairs with downloadable Excel template" ],
  "image" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#image"
  },
  "isAccessibleForFree" : true,
  "mainEntityOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage"
  },
  "name" : "DPMO Calculator (Web)",
  "offers" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#offer-app"
  },
  "operatingSystem" : "Web",
  "provider" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#offer-app",
  "@type" : "Offer",
  "availability" : "https://schema.org/InStock",
  "eligibleRegion" : "Worldwide",
  "itemOffered" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#app"
  },
  "name" : "Free Web DPMO Calculator",
  "price" : "0.00",
  "priceCurrency" : "USD",
  "seller" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  },
  "url" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#template",
  "@type" : "DigitalDocument",
  "author" : {
    "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person"
  },
  "description" : "Free XLSX template to calculate DPO, DPMO, and approximate sigma level with your process data.",
  "encodingFormat" : "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
  "inLanguage" : "en",
  "mainEntityOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage"
  },
  "name" : "DPMO Calculator (Excel Template)",
  "potentialAction" : {
    "@type" : "DownloadAction",
    "name" : "Download the DPMO Calculator (XLSX)",
    "target" : {
      "@type" : "EntryPoint",
      "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ],
      "urlTemplate" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#form"
    }
  },
  "provider" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#offer-doc",
  "@type" : "Offer",
  "availability" : "https://schema.org/InStock",
  "eligibleRegion" : "Worldwide",
  "itemOffered" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#template"
  },
  "name" : "Free DPMO Excel Template",
  "price" : "0.00",
  "priceCurrency" : "USD",
  "seller" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  },
  "url" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#inputs",
  "@type" : "ItemList",
  "itemListElement" : [ {
    "@type" : "ListItem",
    "name" : "Units produced (sample size)",
    "position" : 1
  }, {
    "@type" : "ListItem",
    "name" : "Opportunities for defect per unit",
    "position" : 2
  }, {
    "@type" : "ListItem",
    "name" : "Total defects observed",
    "position" : 3
  }, {
    "@type" : "ListItem",
    "name" : "Defects per Opportunity (DPO) — output",
    "position" : 4
  }, {
    "@type" : "ListItem",
    "name" : "Defects per Million Opportunities (DPMO) — output",
    "position" : 5
  }, {
    "@type" : "ListItem",
    "name" : "Approximate sigma level — output",
    "position" : 6
  } ],
  "itemListOrder" : "Unordered",
  "mainEntityOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage"
  },
  "name" : "Key Inputs and Outputs",
  "numberOfItems" : 6
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#howto",
  "@type" : "HowTo",
  "description" : "Follow these steps to compute DPO, DPMO, and estimate sigma level.",
  "mainEntityOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage"
  },
  "name" : "How to calculate DPMO",
  "step" : [ {
    "@type" : "HowToStep",
    "name" : "Measure and define",
    "position" : 1,
    "text" : "Record units produced, total defects, and the number of defect opportunities per unit."
  }, {
    "@type" : "HowToStep",
    "name" : "Compute DPO",
    "position" : 2,
    "text" : "DPO = defects ÷ (units × opportunities per unit)."
  }, {
    "@type" : "HowToStep",
    "name" : "Compute DPMO",
    "position" : 3,
    "text" : "DPMO = DPO × 1,000,000."
  }, {
    "@type" : "HowToStep",
    "name" : "Estimate sigma level",
    "position" : 4,
    "text" : "Use a standard DPMO↔sigma reference table to approximate sigma level."
  }, {
    "@type" : "HowToStep",
    "name" : "Track improvements",
    "position" : 5,
    "text" : "Repeat periodically to evaluate process changes and trend performance."
  } ],
  "supply" : [ {
    "@type" : "HowToSupply",
    "name" : "Units produced"
  }, {
    "@type" : "HowToSupply",
    "name" : "Opportunities per unit"
  }, {
    "@type" : "HowToSupply",
    "name" : "Defects count"
  } ],
  "tool" : [ {
    "@type" : "HowToTool",
    "name" : "Web calculator"
  }, {
    "@type" : "HowToTool",
    "name" : "Excel template (optional)"
  } ],
  "totalTime" : "PT10M"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#faq",
  "@type" : "FAQPage",
  "mainEntity" : [ {
    "@type" : "Question",
    "acceptedAnswer" : {
      "@type" : "Answer",
      "text" : "DPMO (Defects per Million Opportunities) measures the number of observed defects normalized to one million defect opportunities, enabling comparison across processes."
    },
    "name" : "What is DPMO?"
  }, {
    "@type" : "Question",
    "acceptedAnswer" : {
      "@type" : "Answer",
      "text" : "Count distinct chances a defect could occur on one unit. Keep the definition consistent across measurements to ensure comparability."
    },
    "name" : "How do I choose opportunities per unit?"
  }, {
    "@type" : "Question",
    "acceptedAnswer" : {
      "@type" : "Answer",
      "text" : "PPM is defects per million units; DPMO adjusts for multiple opportunities per unit, giving a more granular view when each unit has several potential defect points."
    },
    "name" : "What is the difference between DPMO and PPM?"
  }, {
    "@type" : "Question",
    "acceptedAnswer" : {
      "@type" : "Answer",
      "text" : "Yes—after computing DPMO, the tool references a standard table to indicate an approximate sigma level for your process."
    },
    "name" : "Can the calculator estimate sigma level?"
  } ],
  "mainEntityOfPage" : {
    "@id" : "https://www.sapbwconsulting.com/defects-per-million-opportunities-dpmo-calculator#webpage"
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person",
  "@type" : "Person",
  "affiliation" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  },
  "jobTitle" : "Principal Consultant",
  "name" : "Lonnie D. Ayers, PMP",
  "url" : "https://www.sapbwconsulting.com/about-lonnie-ayers"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com#website",
  "@type" : "WebSite",
  "hasPart" : [ {
    "@id" : "https://www.sapbwconsulting.com#sitenavigation"
  } ],
  "name" : "SAP BW Consulting, Inc.",
  "publisher" : {
    "@id" : "https://www.sapbwconsulting.com#organization"
  },
  "url" : "https://www.sapbwconsulting.com"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com#organization",
  "@type" : "Organization",
  "contactPoint" : {
    "@type" : "ContactPoint",
    "areaServed" : "US",
    "availableLanguage" : [ "en", "es" ],
    "contactType" : "sales",
    "telephone" : "+1-812-340-5581"
  },
  "logo" : {
    "@type" : "ImageObject",
    "caption" : "SAP BW Consulting, Inc. logo",
    "url" : "https://www.sapbwconsulting.com/hs-fs/hubfs/sapbw-consulting.png?width=2847&name=sapbw-consulting.png"
  },
  "name" : "SAP BW Consulting, Inc.",
  "sameAs" : [ "https://www.linkedin.com/company/sapbwconsulting", "https://www.youtube.com/user/SAPBWConsulting", "https://twitter.com/Lonniea39", "https://www.facebook.com/SAPBWConsulting" ],
  "url" : "https://www.sapbwconsulting.com"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com#sitenavigation",
  "@type" : "SiteNavigationElement",
  "isPartOf" : {
    "@id" : "https://www.sapbwconsulting.com#website"
  },
  "name" : "Primary Navigation",
  "url" : "https://www.sapbwconsulting.com"
}
```