| | | | Decision Matrix |
| | Criterion A | Criterion B | Criterion C | Criterion D | Criterion D | Criterion E |
| Option 1 |
| Option 2 |
| Option 3 |
| Criterion weight |
| | | Generic Decision Matrix: Weighted Scores, Tradeoffs and Total Benefit |
| | Criterion A | Criterion B | Criterion C | Criterion D | Criterion D | Criterion E | Total Benefit |
| Option 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Option 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Option 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| | Green = High | Orange = Middling | | Red = Low | | Weighted score = raw score X importance weight |
| | | | | | | Total benefit = sum of weighted scores |
| | Generic Cost-Benefit Calculation |
| | Value = (Benefit/Cost) |
| | Total Benefit | Cost ($) | Benefit per $ |
| Option 1 | 0 | $0 | ERROR:#DIV/0! |
| Option 2 | 0 | $0 | ERROR:#DIV/0! |
| Option 3 | 0 | $0 | ERROR:#DIV/0! |
| Step 1: Add your criteria: B3:G3 |
| Step 2: Add your options: A4:A6 |
| Step 3: Add criteria weights: B8 - G8 |
| Step 4: Rate how well the options contribute to each criterion: B4:G8 |
| Step 5: View weighted results andand tradeoffs: B13:G15 |
| Step 6: View the Total Benefit of each options: H13:H15 |
| Step 7: Add the cost of each option. |
| Step 8: Make a decision! |
| Note: Obviously, you may need more rows for options and columns for criteria. Just add them within the framework provided. |
| © 2014, Sean Brady, Prism Decision Systems, LLC |
qwerty54321
Cost-benefitmatrixtemplate1.xlsx
