Cost Benefit Analysis:Weighted Scores, Tradeoffs and Total Benefit

Cost Benefit Analysis

Decision Matrix
Criterion ACriterion BCriterion CCriterion DCriterion DCriterion E
Option 1
Option 2
Option 3
Criterion weight
Generic Decision Matrix: Weighted Scores, Tradeoffs and Total Benefit
Criterion ACriterion BCriterion CCriterion DCriterion DCriterion ETotal Benefit
Option 10000000
Option 20000000
Option 30000000
Green = HighOrange = MiddlingRed = LowWeighted score = raw score X importance weight
Total benefit = sum of weighted scores
Generic Cost-Benefit Calculation
Value = (Benefit/Cost)
Total BenefitCost ($)Benefit per $
Option 10$0ERROR:#DIV/0!
Option 20$0ERROR:#DIV/0!
Option 30$0ERROR:#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
find the cost of your paper