Weighted Scoring Matrix — Fictional Worked Example and Blank Worksheet¶
Version: 1.1.0 | Licence: CC BY 4.0
A weighted scoring matrix is a decision-support worksheet for comparing discretionary initiatives or options against explicit criteria, weights and evidence. Mandatory obligations must be identified separately and must not be traded off through scoring.
All weights and ratings in the worked example are fictional illustrative assumptions, not observed data or a real recommendation.
Step 1 — Identify mandatory obligations and reserve capacity¶
Before scoring discretionary initiatives, identify obligations that the organisation must meet. These may arise from law or regulation, safety, security, resilience, contractual commitments, formal decisions or time-critical service needs. Validate each obligation with the competent legal, risk, security, operational or contractual authority; do not classify an item as mandatory solely because it is considered important.
Record the minimum compliant or necessary scope, required date and consequences of delay. Estimate the capacity and specialist skills required, identify dependencies and the accountable owner, then reserve or explicitly plan that capacity. Where scope or timing is uncertain, record the uncertainty and the authority responsible for resolving it.
| Mandatory obligation | Source / authority | Required outcome and minimum scope | Required date | Consequence of delay / non-compliance | Capacity / skills required | Dependencies | Accountable owner |
|---|---|---|---|---|---|---|---|
Mandatory obligations are managed as a distinct, visible part of the portfolio. They are not assigned discretionary scores or given artificially high ratings. Where there is genuine choice over the means, sequencing or additional scope used to meet an obligation, assess those discretionary choices transparently without scoring the obligation itself.
After reserving the capacity required for obligations, make the remaining capacity visible by skill, period and material constraint. Use this residual capacity when assessing the feasibility, affordability and sequencing of discretionary initiatives. If the obligation load exceeds available capacity, escalate the gap for an explicit decision on scope, timing, resources or risk; do not conceal it by lowering discretionary scores.
Step 2 — Assess discretionary options¶
Use the criteria below only for discretionary initiatives or for genuine choices about how to deliver beyond the minimum mandatory baseline. Record the evidence and confidence for each rating. Confirm that the proposed option fits the residual capacity, skills, timing and dependency constraints before recommending a sequence.
Scoring criteria¶
The criteria below implement the Executive Playbook's prioritisation method. Outcome contribution combines strategic contribution with user or service value; feasibility and readiness includes delivery capacity; lifecycle cost captures affordability over the useful life; risk and dependency profile includes both risk reduction and exposure to material dependencies. Mandatory obligations remain outside discretionary scoring.
Rules¶
- Rate each criterion 1 (weak) to 5 (strong).
- Weighted total = sum of (rating × weight); weights sum to 100%, so result is on a 1–5 scale.
- Mandatory legal, regulatory, safety, security, resilience or contractual obligations are identified, validated and capacity-planned separately; they are never scored as discretionary initiatives.
- Score only the discretionary options and scope choices that remain after the mandatory baseline and capacity implications are visible.
- A score does not override affordability, residual capacity, assurance, risk appetite or decision authority.
Worked scoring example¶
| Criterion | Weight | Process clarification pilot | Targeted workflow tooling | Broad platform replacement |
|---|---|---|---|---|
| Outcome contribution | 25% | 4 | 4 | 4 |
| Feasibility and readiness | 20% | 5 | 4 | 2 |
| Time to useful evidence | 15% | 5 | 3 | 1 |
| Lifecycle cost | 15% | 5 | 3 | 1 |
| Risk and dependency profile | 15% | 4 | 3 | 2 |
| Reversibility | 10% | 5 | 3 | 1 |
| Weighted total | 100% | 4.60 / 5 | 3.45 / 5 | 2.10 / 5 |
Recalculation¶
The calculations below make the illustrative scores reproducible. The matrix is a decision-support tool for comparing discretionary technology and digital initiatives; mandatory obligations and their capacity requirements are identified separately. Weighted scores inform judgement but do not replace affordability, assurance or delegated decision authority.
- Process pilot: (4×0.25)+(5×0.20)+(5×0.15)+(5×0.15)+(4×0.15)+(5×0.10) = 4.60
- Targeted tooling: (4×0.25)+(4×0.20)+(3×0.15)+(3×0.15)+(3×0.15)+(3×0.10) = 3.45
- Broad replacement: (4×0.25)+(2×0.20)+(1×0.15)+(1×0.15)+(2×0.15)+(1×0.10) = 2.10
The process pilot ranks highest under these assumptions because it offers stronger readiness, faster evidence, lower lifecycle cost and reversibility. This supports a bounded pilot, not a claim that the intended benefit is proven. Validate baseline, service quality, user impact and operational feasibility before deciding whether to scale.
Blank worksheet¶
| Criterion | Weight | Option A (1–5) | Option B (1–5) | Option C (1–5) | Evidence / confidence |
|---|---|---|---|---|---|
| Outcome contribution | |||||
| Feasibility and readiness | |||||
| Time to useful evidence | |||||
| Lifecycle cost | |||||
| Risk and dependency profile | |||||
| Reversibility | |||||
| Weighted total | 100% |