Weight indicates the relative importance of a question. It's used to help calculate each response's score and influences the overall average for each respondent.
Weights are required in the question set from the following assessments:
- Category segmentation assessments
- Business impact questions
- Supply risk questions
- Market dynamics
- Competitive rivalry questions
- Buyer power questions
- Supplier power questions
- Scope for new entrants questions
- Scope for substitutes questions
Category management administrators can assign an importance level to each question. The total for a set of questions must equal 100%.
Hint
If you have four questions, you can set them all to 25%. Q1 (25%) + Q2 (25%) + Q3 (25%) + Q4 (25%) = Total (100%). Alternatively, you can assign different percentages as long as the total sums to 100%.
A calculation method is necessary to determine the recommended strategy based on the category's business impact and supply market complexity. Category management administrators can select either the Direct or Inverse calculation method to compute scores, which are then used to update the category's position on the Kraljic matrix. Managers review the Category Segmentation assessments in their strategy and plan documents, considering the business impact and supply market scores when updating the category's placement on the Kraljic matrix.
When calculating the score for a set of questions, the lead category manager’s responses are determined by the response type. For Direct questions, the response matches the slider value.
For the set of inverse questions, SAP Ariba Category Management computes an adjusted value. For inverse questions, the category manager's response (slider value of 0 to 100) is subtracted from 100, resulting in the adjusted value:
Hint
100 - slider value = adjusted valueIf a category manager selects 70 on the slider for an inverse question, the adjusted value is 30. If they select 70 for a direct question, the response remains 70.
In a set of questions, the final score is calculated by:
- Determining a weighted value for each direct question in the group as follows: (response * (weight/100))
- Calculating a weighted value for each inverse question in the group as: ((100 - response) * (weight/100))
- Adding all the weighted responses together
- Dividing the total sum by the combined weight of the relevant questions
- If the category manager chooses to omit their response from an optional question, the weight assigned to that question is ignored
When a set of questions is marked as Mandatory and already has a total weight of 100%, dividing by the number of questions isn’t necessary to calculate the average. Instead, the values are divided by the sum of all weights.
((question1 * question1Weight) + (question2 * question2Weight) …. (questionN * questionNWeight)) / (sum of all weights)
If a question is set to Optional, the formula is divided by the sum of all weights while ignoring the optional questions.
Hint
| If all the questions are answered, then the total is divided by 1, keeping the value unchanged. | If an optional question isn't answered or excluded, then the total is divided by 0.75 to account for the ignored question. |
|---|
((70*.25) + (60*.25) + (40*.25) + (30*.25))/1 ((17.5) + (15) + (10) + (7.5))/1 50/1 50 = final score | ((70*.25) + (60*.25) + (40*.25))/0.75 ((17.5) + (15) + (10))/0.75 42.5/0.75 57 (rounded) = final score Scenario 2: ((70*.25) + (60*.25) + (20*.25))/0.75 ((17.5) + (15) + (4))/0.75 36.5/0.75 49 (rounded) = final score |
If you assign all questions as optional, lead category managers can choose to skip all answers, resulting in an assessment score of 0.