Kraljic Matrix Excel Template (2024)
| Item | Profit Impact | Supply Risk | |------|---------------|-------------| | Steel | 9 | 8 | | Office Paper | 2 | 3 | | Custom Microchip | 8 | 9 | | Packaging | 6 | 4 | In column D (Quadrant), enter this formula:
=D2="Strategic" Set format → Fill → Red. kraljic matrix excel template
=COUNTIF(D2:D100, "Strategic") =COUNTIF(D2:D100, "Leverage") =COUNTIF(D2:D100, "Bottleneck") =COUNTIF(D2:D100, "Non-Critical") Add recommended actions next to each count. Row 1: | Item | Profit Impact | Supply Risk

Bike Trials
Moto X3M 4 Winter
Moto X3M Spooky Land
Motor Ninja
Offroad