Enter Sales Inputs
Use weighted targets to blend volume, efficiency, quality, and retention into a single score.
Example Data Table
This sample shows how a weighted scorecard can combine quota, efficiency, and quality metrics.
| KPI | Actual | Target | Weight | Attainment |
|---|---|---|---|---|
| Revenue | 182,000 | 160,000 | 22 | 113.75% |
| Closed Deals | 26 | 24 | 12 | 108.33% |
| Win Rate | 31% | 28% | 10 | 110.71% |
| Renewal Rate | 92% | 90% | 10 | 102.22% |
| Illustrative Final SPI | 113.84 | |||
Formula Used
Attainment for each KPI = (Actual ÷ Target) × 100
Normalized Attainment = min(max(Attainment, Floor), Cap)
Weighted KPI Score = Normalized Attainment × KPI Weight
Base SPI = Sum of Weighted KPI Scores ÷ Sum of KPI Weights
Consistency Bonus = (KPIs meeting target ÷ Active KPIs) × Bonus Max
Final SPI = Base SPI + Consistency Bonus
How to Use This Calculator
- Enter the review period, salesperson name, and team.
- Set the cap, floor, and consistency bonus rules.
- Fill in actual values, targets, and weights for active KPIs.
- Click the calculate button to show the result above the form.
- Review the KPI table to find strengths, gaps, and coaching priorities.
- Use the CSV or PDF buttons to export the result summary.
FAQs
1. What does the Sales Performance Index measure?
It combines several sales KPIs into one weighted score. This helps compare performance more fairly than using revenue alone, especially when quality, retention, and pipeline health also matter.
2. Why use KPI weights?
Weights let you reflect business priorities. Revenue may deserve more importance than activity count, while retention or margin may deserve extra weight in account management or profitability-focused roles.
3. Why is there an overachievement cap?
A cap prevents one exceptional metric from hiding weak results elsewhere. It keeps the index balanced and makes the scorecard more useful for coaching, planning, and compensation reviews.
4. What does the floor percentage do?
The floor sets the lowest normalized attainment allowed in the score. Teams use it when they want to soften extreme underperformance or stabilize results across very volatile sales cycles.
5. When should I use a consistency bonus?
Use it when balanced execution matters. A salesperson meeting many targets may deserve recognition beyond one headline metric, especially in roles requiring prospecting, closing, retention, and profitability together.
6. Can this calculator compare different salespeople?
Yes, if they use comparable KPIs, targets, and weighting logic. Standardized inputs make the index useful for benchmarking individual reps, territories, or periods within one sales model.
7. Which KPIs should I keep active?
Keep only KPIs tied to the role. New business reps may emphasize pipeline and wins, while account managers may prioritize renewal rate, margin, expansion revenue, and client retention.
8. Is a higher SPI always better?
Generally yes, but context matters. A very high score with aggressive caps or unusual weights may look stronger than it should, so always review the KPI mix and assumptions.