VendaraLean Library
Calculator

FMEA Worksheet

Rank failure modes by RPN.

When to use it

Use it before launching or changing a process. Score each failure mode for severity, occurrence and detection, and it ranks them by risk priority number so you know what to fix first.

What you enter

  • Act when RPN is at least
  • One failure mode per line: process step, failure mode, effect, severity, cause, occurrence, current control, detection (scores 1-10)

Paste eight columns from Excel. 10 is worst for severity and occurrence. For detection, 10 means the failure is hardest to detect.

What you get

  • Result
  • Highest RPN
  • Worksheet

How it works

RPN = severity × occurrence × detection, from 1 to 1,000. Work the highest RPN first, and treat any severity of 9 or 10 as a priority whatever the RPN.

How to use the FMEA Worksheet

Failure Mode and Effects Analysis (FMEA) identifies how a process or product could fail, how bad that would be, and what controls are in place.

  1. List each process step and its potential failure modes.
  2. Rate Severity, Occurrence and Detection from 1 to 10.
  3. The sheet calculates the Risk Priority Number: RPN = S × O × D.
  4. Act on the highest risks first, especially any failure with a severity of 9 or 10, then re-rate after actions.

Worked example

A missing O-ring in a valve assembly has severity 8 (leak at customer), occurrence 4 and detection 6 (visual check only): RPN 192. Adding a fixture that will not close without the O-ring drops detection to 2 and the RPN to 64.

Common mistakes to avoid

Frequently asked questions

What is RPN in FMEA?

Risk Priority Number, the product of severity, occurrence and detection ratings. It ranks risks from 1 to 1,000.

What is the difference between PFMEA and DFMEA?

PFMEA looks at how a manufacturing or service process can fail. DFMEA looks at how a product design can fail.

Has RPN been replaced?

The AIAG-VDA FMEA handbook introduced Action Priority (high, medium, low) as an alternative to RPN. Many companies still use RPN for simple FMEAs.

Create your free accountUse the FMEA Worksheet online and download the Excel and print-ready PDF versions. Free, no credit card.

Related tools