| Quadrant | Profit Impact | Supply Risk | Strategy | |----------|---------------|-------------|----------| | | High | Low | Negotiate, tender, substitute | | Strategic | High | High | Long-term partnerships, risk management | | Non-Critical | Low | Low | Simplify, automate, e-procurement | | Bottleneck | Low | High | Secure supply, buffer stock, find alternatives | Excel Template Step-by-Step Step 1: Set Up Worksheet Structure Create 4 columns:
Item Profit Impact Supply Risk Quadrant
=D2="Strategic" Set format → Fill → Red. kraljic matrix excel template
| 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: | Quadrant | Profit Impact | Supply Risk
=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: Create a pivot table or simple COUNTIF formulas:
Repeat for other quadrants. Create a pivot table or simple COUNTIF formulas:
Have a question, need a quote or want to check out some samples? Click on the form below.
© 2024 Premium Label & Packaging Solutions | PLPS Sales Terms and Conditions
