Choosing KPIs

Selecting the vital few metrics and weighting them into a composite scorecard

Budgeting & FP&AKPIs & DashboardsFree preview

⏱️ About 15 min

A business can measure a thousand things. The job of FP&A is to resist that urge - to pick the vital few KPIs that actually move the business and combine them into one weighted score.

💡

The big idea: A good scorecard holds the list to a vital few KPIs and weights each by importance. Each KPI is expressed as an attainment, actual divided by target as a percent, so very different metrics become comparable on one scale. The composite is the weighted average of those attainments: Composite = w1 a1 + w2 a2 + w3 a3, where the weights w1, w2, w3 are normalized to sum to 1.

🎯 By the end, you'll be able to

Express each KPI as an attainment (actual divided by target).
Compute a composite scorecard as the weighted average of attainments.
Explain why FP&A tracks only a vital few KPIs.

📎 Helpful to know first

Comfort with basic arithmetic and percentages; no finance background required.

From many metrics to the vital few

A good scorecard resists the urge to track everything. FP&A teams deliberately hold the list to a vital few KPIs - the metrics that actually move the business - and weight each by importance. Each KPI is expressed as an attainment, actual divided by target, so very different metrics share one comparable scale. The composite score is the weighted average of those attainments: $Composite = w_1 a_1 + w_2 a_2 + w_3 a_3$, where the weights $w_1, w_2, w_3$ sum to 1.

\[ Composite = w_1 a_1 + w_2 a_2 + w_3 a_3 \]

Reading the formula

Suppose three KPIs carry weights $0.5, 0.3, 0.2$ (which sum to 1) and post attainments of $105\%, 90\%, 120\%$. The composite is $0.5 \times 105 + 0.3 \times 90 + 0.2 \times 120 = 52.5 + 27 + 24 = 103.5\%$. A composite above $100\%$ means the business is, on balance, beating plan across its weighted priorities.

⚠️ Weights must sum to 1

The weights express the leadership view of relative importance, and they are normalized to sum to 1 so the composite is a true weighted average. If your raw importance scores are 5, 3, and 2, divide each by their total of 10 to obtain weights 0.5, 0.3, and 0.2.

🎮 Weighted KPI Scorecard LIVE

Predict first: Predict first: weights 0.5/0.3/0.2 on attainments 105%/90%/120% - what is the composite attainment?

Move the three weights and three attainments to watch the composite marker settle on the weighted average.

📝 Worked example: A scorecard has three KPIs with weights 0.5, 0.3, and 0.2 and attainments of 105%, 90%, and 120%. Compute the composite attainment.

1. Multiply each weight by its attainment: 0.5 x 105 = 52.5.
2. 0.3 x 90 = 27.
3. 0.2 x 120 = 24.
4. Composite = 52.5 + 27 + 24 = 103.5%.

✓ Composite attainment = 103.5%

✏️ Practice: Three KPIs have weights 0.4, 0.4, and 0.2 and attainments of 110%, 95%, and 80%. Compute the composite attainment.

💡 Hint

Composite = w1 x a1 + w2 x a2 + w3 x a3; the weights sum to 1.

Answer

Composite = 0.4 x 110 + 0.4 x 95 + 0.2 x 80 = 44 + 38 + 16 = 98%

Check your understanding

1. Why do FP&A teams deliberately track only a vital few KPIs?

A focused set of vital-few KPIs channels attention to the drivers of performance; tracking too many dilutes focus and buries the signal.

2. Weights 0.5/0.3/0.2 on attainments 105%/90%/120% give a composite of?

0.5 x 105 + 0.3 x 90 + 0.2 x 120 = 52.5 + 27 + 24 = 103.5%.

✅ Key takeaways

Composite attainment = w1 a1 + w2 a2 + w3 a3 is the weighted average of KPI attainments.
Each KPI is actual/target as a percent, so different metrics share one scale.
Weights express relative importance and are normalized to sum to 1.

➡️ We can combine KPIs into one weighted score. Next we put each KPI on a dashboard tile that flags status at a glance.

Ready for the next step? Back to the course outline →