ridgeline
Civil/Environmental
- May 29, 2008
- 28
I am working on developing a product evaluation plan that rates a product based on five independent parameters with differing possible range of weights. The goal is to balance all the scores and weights so that the maximum total score is achieved when all the (weights x scores) are summed together (Total summed weights obviously cannot exceed 100%).
For example, consider the following scenario:
-----------------------------------------------
Parameter Weight Score
1 25%-35% 7/10
2 20%-30% 9/10
3 5%-10% 3/10
4 15%-25% 10/10
5 10%-30% 6/10
Find maximum score considering all parameters
-----------------------------------------------
Basically, I am struggling with determining how to develop the basic algorithm and need some assistance with someone that is much smarter and much better at math than I am.
Any help provided would be greatly appreciated!
For example, consider the following scenario:
-----------------------------------------------
Parameter Weight Score
1 25%-35% 7/10
2 20%-30% 9/10
3 5%-10% 3/10
4 15%-25% 10/10
5 10%-30% 6/10
Find maximum score considering all parameters
-----------------------------------------------
Basically, I am struggling with determining how to develop the basic algorithm and need some assistance with someone that is much smarter and much better at math than I am.
Any help provided would be greatly appreciated!