Refinement of Suggested Approach to Calculate the Relevance of a Problem
ANUJ KUMAR SHRIVASTAVA, Manager, India
Ratings on the basis of 1-5 may easily differ from person to person. The technique you suggest is useful, but you need to to work on the variability point here.
You can do this by using some formulas or techniques which give it a common base. So rather than just a rating, give weights to each point you consider and multiply them to obtain the score which would be a percentage.
For example, if you have 3 positive points and Quality is one among them, you might give it a weight of 40% and then calculate: (Norm Quantity/Actual Quantity).
Say your next positive point has a weight of 35% and the next 25%. Do the same calculation for each. Then calculate the cumulative results to arrive at the numerator.
Do it similar for the negative points (=denominator).
After doing that, you can divide the numerator by the denominator.
Please note the weights can change easily as per the requirements, and the type of method you are working on.