Calculating ratings for subjective criteria

When you do a full update of the vendor ratings in the Update Vendor Rating (tdpur8850m000) session, the calculation of the ratings for the subjective criteria is the third stage in the calculate/update vendor rating procedure.

To calculate the subjective criteria ratings:

  1. The subjective values for each business partner are retrieved from the Questionnaire Results (tdpur8193m000) session.
  2. Percentage values, which are stated in the Vendor Rating Subjective Values (tdpur8192m000) session, are assigned to the corresponding subjective values.
  3. The average rating for each subjective criterion is calculated per business partner.

The overall rating of a business partner/subjective criterion combination is calculated as follows:

Overall rating per criterion = SUM / OCC 
SUM All percentage values that are assigned to one business partner/subjective criterion combination.
OCC The number of times that percentage values are assigned for the business partner/subjective criterion combination. A not applicable value is not taken into account.

Example 1

A business partner is rated on two subjective criteria by several employees:

  • CS = Customer service
  • DS = Delivery service
Subjective Criterion Subjective Value % value Employee
CS Average 50 Arthur
DS Excellent 80 Arthur
CS Good 60 Bob
DS Good 60 Bob
CS Poor 40 Carol
DS Not applicable ** Carol

The overall ratings for the business partner/subjective criterion combination are:

  • CS = (50 + 60 + 40) / 3 = 50%
  • DS = (80 + 60 ) / 2 = 70%

After the calculation, the ratings are displayed in these sessions:

  • Vendor Ratings by Period (tdpur8102m000)
  • Vendor Ratings by Criterion (tdpur8102m100)

Example 2

The same example is used as stated above, but this time the subjective criterion CS contains three subcriteria. The subcriteria have the following weightings:

Subcriteria Weighting
Flexibility 0.4
Call Handling 0.2
Support 0.4

These percentage values are assigned:

Subjective Criterion Subjective Value % Value Employee
Flexibility Average 50 Arthur
Call Handling Excellent 80 Arthur
Support Poor 40 Arthur
DS Excellent 80 Arthur
Flexibility Good 60 Bob
Call Handling Average 50 Bob
Support Good 60 Bob
DS Good 60 Bob
Flexibility Poor 40 Carol
Call Handling Excellent 80 Carol
Support (not appl.) 0 Carol
DS (not appl.) 0 Carol

  1. Calculating the overall ratings

    LN calculates the overall ratings for the business partner/subjective criterion combination.
    • Flexibility = (50+60+40)/3 = 50%
    • Call Handling = (80+50+80)/3 = 70%
    • Support = (40+60)/2 = 50%
    • DS = (80+60)/2 = 70%
  2. Calculating the rating of the parent subjective criteria

    Parent criteria rating = sum (child criteria % values * weightings)
    • Flexibility = 50% * 0.4 = 20
    • Call handling = 70% * 0.2 = 14
    • Support = 50% * 0.4 = 20
    • CS rating = 20 + 14 + 20 = 54%
  3. Writing the ratings

    After the calculation, LN writes the ratings to these sessions:

    • Vendor Ratings by Period (tdpur8102m000)
    • Vendor Ratings by Criterion (tdpur8102m100)