Steel 9 8 =IF(AND(B2>=5,C2>=5),"Strategic",IF(AND(B2>=5,C2<5),"Leverage",IF(AND(B2<5,C2>=5),"Bottleneck","Non-Critical")))
In this comprehensive guide, we will break down the Kraljic Matrix, explain how to use it, and—most importantly—show you why a purpose-built Excel template is the secret weapon you need to transform your procurement strategy.
You have two options: Build or Buy.
: Use weighted averages to calculate a final score for each dimension.
: These are routine purchases like office supplies. Focus on administrative efficiency and product standardization. How to Build the Excel Template kraljic matrix excel template
While you can find downloadable templates online, building your own ensures it is tailored to your organization’s specific data fields. Here is how to construct a professional-grade tool.
Select column D > Conditional Formatting > New Rule > Use formula: : These are routine purchases like office supplies
While the model itself is decades old, its application remains cutting-edge. However, the true power of this model is unlocked not through theoretical discussion, but through practical application. A well-designed serves as the bridge between raw purchasing data and strategic decision-making.