Search TipsSubcontractor Ratings Mobile - Ratings Calculations
As shown above, there are 4 types of ratings for subcontractors and vendors. These ratings are all weighted averages, with higher level (overall) ratings based on lower level ratings and weights.
The way in which these weighted averages are calculated is the way weighted averages are typically calculated, as shown by the following example.
NOTE: Ratings are not required for each question. Therefore, if a rating is null, it is skipped and does not impact the calculation.
Example of Weighted Average Calculation
In this example, the Subcontractor Rating is calculated for a subcontractor based on the subcontractor’s Subcontractor Category Ratings (weighted averages calculated earlier) and weights assigned to the 3 sample Categories.
| Category | Weight | Max # of Stars | Weight X Max # of Stars | Subcontractor Category Ratings | Rating x Weight |
|---|---|---|---|---|---|
| Quality | 1 | 5 | 1 x 5 = 5 | 3.5 stars | 3.5 x 1 = 3.5 |
| Experience | 0.5 | 5 | 0.5 x 5 = 2.5 | 2 stars | 0.5 x 2 = 1 |
| Teamwork | 2 | 5 | 2 x 5 = 10 | 4 stars | 2 x 4 = 8 |
| TOTAL | 7.5 | TOTAL | 12.5 |
As calculated above in the blue columns, based on the weight and maximum number of stars for each category, a perfect overall rating would be 17.5. In the green columns, based on the subcontractor category ratings and the category weights, the overall rating for the subcontractor is 12.5. So, the subcontractor’s percentage of a perfect score is: 12.5/17.5 = 71.4% Out of 5 stars, the subcontractor’s overall rating (subcontractor rating) then is: 5 x 0.714 ≈ 3.6 stars
Review Category Ratings
The rating for each category is a weighted average based on the rating for each category question and the weights assigned to the category questions.
Category question weights are set up in the Subcontractor Rating Questionnaire Setup screen:
Review Rating
The overall rating for a review is a weighted average based on the review category ratings (calculated previously) and the weights assigned to the categories.
Question weights are set up in the Subcontractor Rating Questionnaire Setup screen:
Subcontractor Category Ratings
A subcontractor’s overall rating for a category is a weighted average based on the ratings for each category from all reviews and the PM role weights of the reviews.
PM role weights are set up in the Project Roles screen of CMiC Field:
NOTE: CMiC Field is formerly known as xProjects/Project Management.
Subcontractor Rating
The overall rating for a subcontractor is a weighted average based on the subcontractor category ratings (weighted averages calculated earlier) and the weights assigned to the categories.
Category weights are set up in the Subcontractor Rating Questionnaire Setup screen: