What is RPN Disccusion

FMEA RPN – Risk Priority Number, Calculation and Evaluation


FMEA RPN was evaluated and actions were implemented but problems still happen. You might not address the high risks.
So how to prioritize the risk effectively right inside Excel?


FMEA RPN (Risk Priority Number) is a numerical assessment of the risk priority level of a failure mode in an FMEA analysis. FMEA RPN helps the responsible team/individual to prioritize risks and make the decision on the corrective actions.

2. How to calculate the Risk Priority Number?

FMEA RPN is calculated by multiplying Severity (S), Occurrence (O), and Detection (D) indexes. Severity, Occurrence, and Detection indexes are derived from the FMEA analysis:

Risk Priority Number = Severity x Occurrence x Detection
  • Severity: The severity of the failure mode is ranked on a scale from 1 to 10. A high severity ranking indicates severe risk.
  • Occurrence: The potential of failure occurrence is rated on a scale from 1 to 10. A high occurrence rank reflects high failure occurrence potential.
  • Detection: The capability of failure detection is ranked on a scale from 1 to 10. A high detection rank reflects low detection capability.

# 1 FMEA Tool for Excel

Save hours of work

Example: from the Process FMEA analysis of a painting process, the RPN is 120 for failure mode of foreign body in the painting layer.

Risk Priority Number Calculation in Excel
RPN and Risk Evaluation

RPN is not the only risk assessment number used with FMEA. Some companies use other indexes to assess risks, such as the Critical Number (CN) or Severity-Occurrence-Detection (SOD). However, they are rarely used.

2.1 Critical Number (CN)

Some companies find it difficult to decide on a detection ranking. Therefore, they do not use detection (D) in their calculation of the RPN to avoid arguments regarding the detection ranking.

Critical Number (CN) = Severity (S) x Occurrence (O)


Failure ModeSeverityOccurrenceDetectionCN
Failure Mode 165530
Failure Mode 257635

2.2 SOD

The FMEA RPN does not cover all the numbers in the range from 1 to 1000. Therefore, some companies use the numerical value of SOD. In this case, the values of S, O, and D range from 0 to 9 (not from 1 to 10).

SOD = 100 x S + 10 x O + D

Consider the following example.

Failure ModeSeverityOccurrenceDetectionSOD
Failure Mode 1811811
Failure Mode 2799799

Although Failure Mode 1 has a higher SOD than Failure Mode 2, it has lower risk because its potential for occurrence is small and the possibility of detection is high (if it happens).

Thus, the disadvantage of SOD is that severity has a more critical role than Occurrence and Detection in the SOD equation.

3. How to evaluate Risk Priority Number?

The RPN can be used to prioritize high-risk issues and determine the requirement for corrective action. After calculation, most companies prioritize risks from the highest to the lowest RPN.

The team can use the Risk Priority Number to prioritize and reduce risks in the two following methods:

3.1 FMEA RPN Threshold

Many organizations use an RPN limit to determine which failure mode requires corrective action and which risks are acceptable. The RPN threshold is easy to use.

However, using an RPN threshold may cause team members to spend excessive time trying to reduce the Detection, Occurrence, and Severity rankings for lowering the RPN. This situation sometimes places the organization and its customers in danger.

3.2 Top RPNs

The other organizations may address the corrective action for the top RPNs. After that, the team reset and find another top RPNs for the next improvement process. This method promotes continuous improvement.

4. Risk Priority Number’s disadvantage

The two ways above are based only on the comparison between the RPN of failure modes. The comparison based on the RPN may not reflect the actual risk. A high RPN failure does not necessarily indicate a high risk for the process or product. Moreover, two failure modes with the same RPN value may not have the same risk level.

In the following example from the automotive industry, Failure Mode 1 should be provided a higher priority than Failure Mode 2 although they have the same RPN value because it has higher Severity value.

Failure ModeSeverityOccurrenceDetectionRPN
Failure Mode 1744112
Failure Mode 2447112

However, because they have the same RPN value, an inappropriate action plan for critical failure may be selected. For this reason, the RPN should not be the only index used to evaluate the risk of each failure mode. The team should also use Severity, Occurrence, and Detection of prioritizing risks.

5. How to evaluate the Risk Priority Number effectively?

5.1 Risk evaluation using the FMEA RPN with the consideration of the S, O, and D rankings

Along with RPN, the team should consider the S, O, and D rankings for prioritizing risks one by one through team discussion. However, the team will be overloaded if there are too many failure modes in the FMEA.

Moreover, teams can go through unending arguments to determine which failure requires corrective action.

# 1 FMEA Tool for Excel

Save hours of work

5.2 Risk Matrix (Priority Matrix)

Risk Prority Number - Risk Matrix RPN and Seveirty

The team can combine the criteria for the RPN and Severity, Occurrence, and Detection rankings by using a matrix. The following is an example of a risk matrix for the RPN and Severity ranking.

The following example of a risk matrix includes a combination of severity and occurrence.

Risk Prority Number - Risk Matrix Occurence and Seveirty

Color indicator:
• Red: The team must eliminate the risk or reduce its level.
• Yellow: The team should eliminate the risk or reduce its level.
• Green: Acceptable risk.

The team can use a three-dimensional matrix of Severity, Occurrence, and Detection, however, this kind of risk matrix is complicated to use.

The organization can create a matrix depending on their process characteristics and available resources. However, the team should apply the criteria consistently.

6. Conclusion

Using the RPN in FMEA is the most common and convenient method of evaluating risk because the FMEA RPN is easy to understand, whereas the entire FMEA methodology is complicated.

However, using only the RPN to determine the failure mode that requires corrective action can cause severe quality problems in an organization.

Companies that wish to avoid the limitations of the RPN should evaluate risk with a combination of indices, such as Severity, Occurrence, and Detection.

# 1 FMEA Tool for Excel

Save hours of work

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

More To Explore



DFMEA stands for Design Failure Mode and Effects Analysis and PFMEA stands for Process Failure Mode and Effects Analysis. They are both FMEA, use the

FMEA Automation Tool for Excel
Use FMEA Analysis tool to save hours of work

Download FMEA Analysis

And get the lastest news and supporting articles

An email with download link and installation instruction will be send to your email address in a minute.