Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsFailure Mode and Effects Analysis (FMEA)

SpreadsheetManufacturing & OperationsFree

Failure Mode and Effects Analysis (FMEA)

Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.

Shown with sample data

Colour

Failure Mode and Effects Analysis (FMEA)

Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.

Failure modes
8
High priority
1
Highest RPN
175
Risk reduced by actions
35%
Total RPN, before vs after
Open actions
4
Overdue actions
1
RPN by failure mode
  • 20.1175
  • 10.1168
  • 60.1168
  • 20.2144
  • 30.1108
  • 50.1108
  • 40.196
  • 40.260
Revised RPN after actions
  • 10.1168
  • 20.2144
  • 40.196
  • 20.184
  • 50.172
  • 30.154
  • 60.128
  • 40.220

How to use it

  1. 1Use the Rating guide sheet so everyone scores severity, occurrence and detection the same way.
  2. 2On Analysis, list each process step with its failure modes, effects, causes and current controls.
  3. 3Score S, O and D for each line as a team; RPN and action priority calculate for you.
  4. 4For every High (and most Medium) line, add an action on the Actions sheet with the same ID, an owner and due date.
  5. 5When an action is done, re-score S, O and D on the Actions sheet; the revised RPN flows back to Analysis.
  6. 6Review the FMEA whenever the process changes or a failure occurs that it did not predict.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A working process FMEA. List each process step, how it can fail, the effect and the cause, then rate severity, occurrence and detection from 1 to 10 using the rating guide. The sheet calculates the risk priority number (RPN) and an action priority, and the Actions sheet records recommended actions, owners and due dates with re-rated scores, so the analysis shows revised RPN and how much risk each action removed.

Who it’s for

  • Process FMEA for a new or changed process
  • APQP and PPAP submissions
  • Prioritising improvement work by risk
  • Design reviews when adapted for DFMEA

What’s included

  • Analysis sheet: Failure modes with S, O, D, RPN, action priority and revised RPN after actions.
  • Actions sheet: Actions for each failure mode, with re-rated S, O and D.
  • Rating guide sheet: How to score S, O and D from 1 to 10.

How to use it

  1. 1Use the Rating guide sheet so everyone scores severity, occurrence and detection the same way.
  2. 2On Analysis, list each process step with its failure modes, effects, causes and current controls.
  3. 3Score S, O and D for each line as a team; RPN and action priority calculate for you.
  4. 4For every High (and most Medium) line, add an action on the Actions sheet with the same ID, an owner and due date.
  5. 5When an action is done, re-score S, O and D on the Actions sheet; the revised RPN flows back to Analysis.
  6. 6Review the FMEA whenever the process changes or a failure occurs that it did not predict.

Tips

  • Do not rank by RPN alone: a severity of 9 or 10 needs action even if occurrence and detection are low.
  • Severity rarely changes after an action unless the design changes; most actions lower occurrence or detection.
  • Prevention controls lower occurrence; detection controls (inspection, error-proofing that detects) lower detection.
  • Keep scoring consistent across the team by agreeing two or three anchor examples before you start.

Questions

How is RPN calculated?

RPN = Severity × Occurrence × Detection, each rated 1–10, so it ranges from 1 to 1,000.

What is action priority (AP)?

The AIAG-VDA FMEA handbook (2019) replaced RPN thresholds with an action priority of High, Medium or Low that weights severity first. This sheet uses a simplified version: High when S ≥ 9 with O ≥ 4, S ≥ 7 with O ≥ 6, or RPN ≥ 200; Medium when S ≥ 9 with O ≥ 2, S ≥ 5 with O ≥ 4 and D ≥ 5, or RPN ≥ 100. Use the official AP tables for automotive customer submissions.

What RPN is acceptable?

There is no universal threshold. Many companies act on anything over 100 to 125, but severity-first rules are better practice than a single RPN cut-off.

What is the difference between DFMEA and PFMEA?

A design FMEA looks at how the product can fail to meet its function; a process FMEA looks at how manufacturing or assembly can produce a defect. This template is laid out for PFMEA.

Related searchesfmea templatepfmea excelfailure mode and effects analysisrpn calculatorrisk priority numberprocess fmea

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
3
Setup
60 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

Failure Mode and Effects Analysis (FMEA)

Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
3
Setup
60 min
Level
Advanced
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
Weekly Production Schedule3 sheets

Attainment

100%

Yield

99%

Downtime

160

ABCD
1DateLineOrder #Product
2Nov 5Line 1MO-871Sourdough loaf 800g
3Nov 5Line 2MO-872Granola bar 40g
4Nov 5Line 3MO-873Oat cookies 12pk
5Nov 6Line 1MO-874Seeded rolls 6pk
Schedule
SpreadsheetManufacturing & Operations

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

10 min setupPreview
OEE Calculator2 sheets

Average OEE

79%

Availability

90%

Performance

90%

ABCD
1DateLineShiftPlanned minutes
2Nov 3Line 1Day450
3Nov 3Line 1Night450
4Nov 3Line 2Day450
5Nov 3Line 2Night450
Shifts
SpreadsheetManufacturing & Operations

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ