Project Prioritization using Weighted Scoring



  • 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?



  • In case you will work with more than 10 initiatives such approach won't work. It has not so much variables and values.

    To build a good ranking system for your own situation: try to add more variables with wide range of values. As an example: number of affected users. So the final value for 5 users and 5 mln users could be dramatically different. Just make a small investigation of your domain field, competitors...which metrics are critical and valuable.

    Also, adding an importance factor for each variable will take a significant role as a defining part of the ranking system.

    And for

    Any thoughts on how best to approach the positive and inverse negative scoring?

    For example, you are prioritizing according to the final score number (bigger - more prioritized).

    In that situation you need to add more value for valuable (positive) variables (5 is the higher value) and less value for "negatives" (1 is the highest cost).

    Using such approach the max total score for the most valuable item with the highest cost will be 6.

    For the the same valuable but with lowest cost score will be 10. So it will have higher priority.


Log in to reply
 

Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2