Overdue
1
Due in 14 days
3
Maintenance spend
$2,875
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.
SpreadsheetManufacturing & OperationsFree
Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.
Shown with sample data
Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.
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.
RPN = Severity × Occurrence × Detection, each rated 1–10, so it ranges from 1 to 1,000.
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.
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.
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.
Download a copy
Downloads need a free account.