Tool

Risk-based PM Prioritization Worksheet

Interactive worksheet to score and prioritize preventive maintenance (PM) for assets. Enter equipment details, rate consequence and failure frequency, record recommended PM tasks and spare parts, and use the included scoring guidance to focus work where it reduces the most production risk.

Interactive Tool

Risk-based PM Prioritization Worksheet

This worksheet helps you prioritize PM effort by scoring each asset on consequence and failure frequency so limited maintenance resources focus on the highest production risk. Fill one submission per asset (or per failure mode). Guidance below shows how to compute the risk score and how to map scores to suggested PM cadences. Use the 'Recommended PM cadence' field to capture your judgment or to follow the suggested mapping after calculating the score.

How to score

Risk score = Consequence ↑ x Failure frequency ↑ (numeric values shown in dropdowns). Example: Consequence 4 x Frequency 3 = Risk 12. Use the mapping below to suggest cadence.

Suggested risk -> PM cadence mapping (example)

  • Risk 16–25: Critical — Continuous monitoring / daily or weekly inspections; consider redundancy or redesign
  • Risk 9–15: High — Monthly to biweekly PM and pre-position critical spares
  • Risk 5–8: Medium — Quarterly PM and condition checks
  • Risk 2–4: Low — Semi-annual or annual PM; focus on operator checks
  • Risk 1: Negligible — No scheduled PM beyond routine inspection
Short name or tag (e.g., 'Press #2', 'Conveyor A - Line 1').
Plant tag, serial number, CMMS asset ID or barcode. Helpful for later linking to CMMS.
Where the equipment is located (plant/line/zone).
Describe the common failure mode this PM is intended to address (e.g., bearing seizure, hydraulic leak, electrical fault).
Select the worst reasonable consequence for the failure in production, safety, quality, environment, or cost terms.
Rate how often this failure is expected to occur if not actively mitigated. Use historical data when available.
1 = Hard to detect until failure; 5 = Easily detected early by routine checks or sensors.
1.0 10.0
Calculate consequence x frequency and enter the numeric result. The form does not calculate automatically. Example: Consequence 4 x Frequency 3 = 12.
Choose an appropriate cadence. Use the suggested mapping in the guidance to map from Risk score to cadence, then record your chosen cadence here.
Capture the key PM actions to reduce this failure risk (e.g., 'lubricate bearings, check belt tension, replace seal every 6 months'). Keep tasks concise and actionable.
List critical spare parts to hold (part number, qty recommended, lead time note). This helps planning and spare provisioning.
Short estimate (e.g., '8 hours', '2 shifts', '3 days'). Useful to prioritize impact on scheduling.
Any supporting data, references to failure history, CMMS work orders, or decisions used to justify scores and cadence.
You can explore this tool now. Sign in or create an account to save your responses and return to them later.
Sign In to Save Create an Account
Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.
Discuss Ask the Librarian

Discussion

Comments and conversation will live here.