Concept: Scorecard Scoring Logic
Evaluations enable you to solicit feedback from your stakeholders on the performance of your suppliers. You can customize the weighted scoring for each question and section in your evaluation. Strategic Sourcing automatically calculates and aggregates results from all your stakeholders.
This scorecard scoring logic applies to performance reviews and sourcing events.
Calculating Total Scores
To calculate the total score, Strategic Sourcing:
- Adds all the weighted section scores, rounding the total score up to the first decimal place.
- Averages the total scores for each supplier to produce an overall score.
To calculate the weighted section score, Strategic Sourcing multiplies the section weight as a decimal by the total section score.
Section | Section Weight | Total Section Score | Weighted Section Score |
|---|---|---|---|
Pricing & Financials | 0.20 | 86.7% | 0.20 × 86.7% = 17.3% |
Quality & Level of Service | 0.25 | 97.5% | 0.25 × 97.5% = 24.4% |
Maintenance | 0.25 | 90% | 0.25 × 90% = 22.5% |
Account Management | 0.10 | 95% | 0.10 × 95% = 9.5% |
Innovation | 0.20 | 80% | 0.20 × 80% = 16% |
Calculating a Section Score with Equally Weighted Questions
To calculate the total section score of equally weighted questions, Strategic Sourcing:
- Averages all the question scores of each of your stakeholders, excluding any N/A answers and unanswered questions.
- Computes the average of the stakeholder average scores.
A section has 2 equally weighted questions. Your 4 stakeholders answer the questions with a numeric score of 1-5 out of 5:
Stakeholder | Question 1 Score | Question 2 Score |
|---|---|---|
Stakeholder 1 | No answer | 2 out of 5 |
Stakeholder 2 | 2 out of 5 | N/A |
Stakeholder 3 | 4 out of 5 | 5 out of 5 |
Stakeholder 4 | 3 out of 5 | 3 out of 5 |
Strategic Sourcing drops N/A answers and unanswered questions from calculations and averages each stakeholder score:
Stakeholder | Calculation |
|---|---|
Stakeholder 1 | (No Answer + (2 ÷ 5)) ÷ 2 = 2 ÷ 5 = 0.4 |
Stakeholder 2 | ((2 ÷ 5) + N/A) ÷ 2 = 2 ÷ 5 = 0.4 |
Stakeholder 3 | ((4 ÷ 5) + (5 ÷ 5)) ÷ 2 = 0.9 |
Stakeholder 4 | ((3 ÷ 5) + (3 ÷ 5)) ÷ 2 = 0.6 |
Strategic Sourcing averages all stakeholder scores together to get the percentage: ((0.4 + 0.4 + 0.9 + 0.6) ÷ 4) × 100% = 57.5%.
Calculating a Section Score with Differently Weighted Questions
To calculate the total section score with differently weighted questions, Strategic Sourcing:
- Averages all the question scores of each of your stakeholders and scales to 100%, excluding any N/A answers and unanswered questions.
- Computes the average of the stakeholder average scores.
A section has 2 questions, one weighted 25% and the other weighted 75%. Your 4 stakeholders answer the questions with a numeric score of 1-5 out of 5:
Stakeholder | Question 1 Score, Weighted 25% | Question 2 Score, Weighted 75% |
|---|---|---|
Stakeholder 1 | No answer | 2 out of 5 |
Stakeholder 2 | 2 out of 5 | N/A |
Stakeholder 3 | 4 out of 5 | 5 out of 5 |
Stakeholder 4 | 3 out of 5 | 3 out of 5 |
Strategic Sourcing drops N/A answers and unanswered questions from calculations and scales each stakeholder score to 100%:
Stakeholder | Calculation |
|---|---|
Stakeholder 1 | No Answer + (2 ÷ 5) × 100%= (2 ÷ 5) × 100% = 40% |
Stakeholder 2 | (2 ÷ 5) × 100% + N/A = (2 ÷ 5) × 100% = 40% |
Stakeholder 3 | (4 ÷ 5) × 25% + (5 ÷ 5) × 75% = 20% + 75% = 95% |
Stakeholder 4 | (3 ÷ 5) × 25% + (3 ÷ 5) × 75% = 15% + 45% = 60% |
Strategic Sourcing averages all stakeholder scores together to get the percentage: (40% + 40% + 95% + 60%) ÷ 4 = 58.8%.
Calculating Question Scores
To calculate a question score, Strategic Sourcing uses this formula: (Score of Stakeholders ÷ Number of Stakeholders That Answered) × Weight Percentage.
Of your 4 stakeholders, only 3 provide answers with a numeric score of 1-5 out of 5:
Stakeholder | Question Score |
|---|---|
Stakeholder 1 | 2 out of 5 |
Stakeholder 2 | N/A |
Stakeholder 3 | 4 out of 5 |
Stakeholder 4 | 3 out of 5 |
Strategic Sourcing averages scores by the number of stakeholders that answered: (((2 ÷ 5) + (5 ÷ 5) + (3 ÷ 5)) ÷ 3) x 100% = 66.7%.