EN
Use a formula like =IF(AND(X>3.5, Y>3.5), "Strategic", IF(AND(X<3.5, Y>3.5), "Bottleneck"...)) to auto-color rows.
If you don't want to build manually, search within Excel for under File > New – some built-in or community templates exist. Otherwise, sites like Template.net or Smartsheet offer free Excel versions.
=D2="Strategic"
| Item | Profit Impact | Supply Risk | |------|---------------|-------------| | Steel | 9 | 8 | | Office Paper | 2 | 3 | | Custom Microchip | 8 | 9 | | Packaging | 6 | 4 |
Pro Tip: If you have too many items in the Strategic quadrant, you are over-classifying. Only 15-20% of spend should be here.