Kraljic Matrix
Aggregate purchasing categories, score supply risk, and map each category into a procurement strategy quadrant.
1. Data Import
Drag & drop your Excel (.xlsx, .xls) or CSV here
Or click to browse files from your computer
Item List
| Name | Suppliers | Annual Spend | Supply Risk | Profit Impact | Delete |
|---|
Matrix Output
About Kraljic Matrix Analysis
The Kraljic Matrix is a procurement planning method that helps teams decide how much attention, control, and supplier management effort different purchases need. It compares each item against two practical questions: how much the item affects business performance, and how difficult or risky it is to secure supply.
In this tool, profit impact is plotted from left to right and supply risk is plotted from bottom to top. The resulting position places each item into one of four categories, giving procurement teams a clear way to prioritise sourcing strategy, supplier conversations, and risk mitigation.
How to Use This Tool
- Upload a CSV or Excel file that includes category, supplier, and annual spend fields.
- Map the imported columns so the tool can aggregate annual spend by category.
- Review the calculated profit impact score, which is based on each category's annual spend.
- Set supply risk manually for each category using your procurement judgement.
- Export the table or matrix image when you want to share the analysis with stakeholders.
Category Guidance
High impact and high risk. Build close supplier relationships, plan early, monitor risk, and consider long-term agreements.
High impact and lower risk. Use competition, volume consolidation, and negotiation to improve value without overcomplicating supply.
Lower impact but high risk. Focus on availability, backup options, specifications, and practical ways to reduce supply exposure.
Lower impact and lower risk. Keep the buying process simple with standard terms, catalogues, automation, or reduced administration.
Methodology, Assumptions, and Limitations
The tool aggregates annual spend by category, converts relative spend into a profit impact score, and combines that score with a user-entered supply risk rating.
Use category, supplier, and annual spend fields for the import. Supply risk is intentionally entered by the user because it depends on market knowledge and operational judgement.
Annual spend is used as a practical proxy for profit impact. This is useful for screening categories, but it may not fully capture margin, customer impact, or production criticality.
The matrix should support procurement discussion, not replace supplier due diligence. Review strategic or bottleneck items with additional risk, quality, and continuity information.
FAQ
How should I score supply risk?
Consider the number of suitable suppliers, switching effort, lead-time volatility, technical constraints, and exposure to disruption.
How should I score profit impact?
The tool calculates profit impact from annual spend after aggregating the imported data by category. Higher annual spend produces a higher impact score.
Should every item be reviewed at the same level of detail?
No. The matrix is useful because it separates routine purchases from items that deserve deeper supplier and risk management work.