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:
- The subjective values for each business partner are retrieved from the Questionnaire Results (tdpur8193m000) session.
- Percentage values, which are stated in the Vendor Rating Subjective Values (tdpur8192m000) session, are assigned to the corresponding subjective values.
- 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 |
-
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%
-
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%
-
Writing the ratings
After the calculation, LN writes the ratings to these sessions:
- Vendor Ratings by Period (tdpur8102m000)
- Vendor Ratings by Criterion (tdpur8102m100)