Weighted Decision Matrix
Compare options across weighted benefit and cost criteria, then test how sensitive the ranking is to each weight.
Criteria
| Name | Weight | Direction |
|---|
Options and scores
Import / export
Ranking
Weight sensitivity
Formula: Benefit normalized value = score ÷ scale maximum. Cost normalized value = (scale maximum − score) ÷ scale maximum, so lower cost scores rank better. Weighted total = Σ(weight × normalized value) ÷ Σ(included weights), then displayed as a percentage. With “ignore,” a missing cell is omitted from both sums for that option; with “zero,” it contributes zero while its weight remains in the denominator. Sensitivity varies one criterion from −N% through +N% in 20 equal steps while holding other weights constant, recalculating full ranks and flagging observed leader changes or ties. It is a scenario test, not proof that untested weight combinations preserve the ranking.