What this template is for
A 5×5 risk assessment matrix with P×I scoring, automatic heat mapping, and supplier risk ranking for supply chain risk management. This downloadable template helps procurement professionals streamline their risk assessment process — no need to build complex spreadsheets from scratch.
What's included
- 5×5 risk matrix with automatic Probability × Impact calculation
- Color-coded heat map (green/yellow/orange/red) with conditional formatting
- 5 risk categories: Financial, Operational, Geopolitical, Compliance, Cyber
- Supplier risk ranking with total score and criticality level
- Risk mitigation action plan template with owner and deadline
Who should use this
- Supply chain risk managers performing periodic supplier risk assessments.
- Procurement directors preparing supply chain risk reports for executive review.
How to use it
- Enter supplier name and assessment date
- Score each of the 5 risk categories for Probability (1-4) and Impact (1-4)
- Review the auto-generated heat map — cells turn red for high-risk areas
- Check the Risk Ranking table to prioritize suppliers by total score
- Complete the Mitigation Plan for any supplier scoring High or Critical