In building a simple spreadsheet to help prioritize, I am trying to use weighted scoring for Value, Effort, and Cost. Each initiative has a value between 1-5 for each measure, with 1 being the least and 5 being the highest.
The weighting for Value should affect the score positively, while the weighting for Effort and Cost should affect the score negatively.
Inititiave 1: Value = 2, Cost = 4, Effort = 5, Priority = ? Inititiave 2: Value = 3, Cost = 2, Effort = 1, Priority = ? Inititiave 3: Value = 2, Cost = 2, Effort = 3, Priority = ?
Any thoughts on how best to approach the positive and inverse negative scoring?