Sales Target Calculator
Track target achievement, remaining target, required daily sales and a projected finish.
KPI Performance Calculator
Build a weighted KPI scorecard in seconds. Set a weight, target and actual for each KPI, choose whether higher or lower is better, and get an overall score.
Use the KPI Performance Calculator
Loading tool…
How to use the KPI Performance Calculator
- Rename the example KPIs or add your own (up to 12).
- Give each KPI a weight, a target and whether higher or lower is better.
- Enter actual results. KPIs without an actual are left out.
- Review the weighted score, rating and per-KPI points. Adjust the cap if needed.
About this tool
Each KPI is scored against its target (actual ÷ target for higher-is-better, target ÷ actual for lower-is-better). Scores can be capped, so over-delivery on one KPI cannot fully mask a miss on another. The weighted sum of those scores gives the overall result. Agree the weights and caps with the team before the period starts.
Free to use. Your inputs are processed in your browser and are not sent to our servers. Results are estimates for general information; see the disclaimer.
Score your whole team in Excel
The Team KPI Scorecard template scores up to 50 people on up to 8 weighted KPIs, with ratings, rankings and a team summary that calculate automatically. It works in Excel 2010 or later.
Need a scorecard designed for your team? I design weighted KPI scorecards and hand them over in Excel. See services and request a quote.
How a weighted KPI score works
A weighted scorecard gives more influence to the KPIs that matter most. Each KPI gets a score, and each score counts according to its weight:
- Higher is better (such as sales): score = actual ÷ target × 100.
- Lower is better (such as complaints): score = target ÷ actual × 100.
- Points = score × weight ÷ 100. The final score is the sum of all points.
Worked KPI example
| KPI | Weight | Target | Actual | Score | Points |
|---|---|---|---|---|---|
| Sales achievement | 40% | 100 | 92 | 92% | 36.8 |
| Distribution / coverage | 25% | 100 | 105 | 105% | 26.25 |
| Collections | 20% | 100 | 88 | 88% | 17.6 |
| Returns / complaints | 15% | 5 | 6 | 83.3% | 12.5 |
| Total | 100% | 93.15 |
The total of about 93% falls in the tool's Close to target band. The returns figure shows why direction matters: actual returns of 6 against a target of 5 are worse than planned, so that KPI scores below 100%.
What the rating bands mean
| Weighted score | Rating in this tool |
|---|---|
| 100% or more | Target achieved or exceeded |
| 90% to under 100% | Close to target |
| 75% to under 90% | Below target |
| Under 75% | Significantly below target |
These are general labels. Use your own organisation's bands if it has them.
Why cap a KPI score?
Without a cap, a very high result on one KPI can hide poor results on others. The default cap of 120% limits how much any KPI can add. For example, a score of 150% on sales would count as 120%. Enter 0 to remove the cap.
Choosing good KPIs and weights
- Use a small number: four to seven KPIs are generally easier to manage than a long list.
- Pick what the person controls: a score feels unfair if it depends mainly on other teams.
- Agree on the source: decide in advance where each figure comes from.
- Weight by priority: make the weights reflect your real goals, and total them to 100%. The tool can rescale them if they don't add up.
- Balance your measures: pair volume with quality, so one isn't improved at the expense of the other.
Read our guide to building a weighted KPI scorecard for more detail. For monthly sales progress, use the Sales Target Calculator.
Frequently asked questions
What if my weights do not add up to 100?
Leave auto-normalise ticked and the tool rescales them to 100%. Untick it to use the weights exactly as typed.
How do I handle a KPI where lower is better?
Choose “Lower is better”, for example for returns, complaints or days outstanding. The score is target ÷ actual.
Why cap scores at 120%?
A cap stops one outlier result from dominating the total. Set it to 0 to remove the cap.
How do I calculate a weighted KPI score?
Divide actual by target to get each KPI's score, or target by actual if lower is better. Multiply each score by its weight, then add up the results.
What happens if my weights don't total 100%?
With auto-normalise on, the tool rescales the weights to 100%. With it off, the score is based on the weights you entered, and the tool shows a note.
Is this suitable for employee appraisals?
It works as a calculation aid, but your organisation's appraisal policy and manager judgement should decide any final rating.
Related tools
Percentage Calculator
Percentage of a number, percentage change, percentage difference and add/subtract a percentage.
Business Report Generator
Turn highlights, metrics and actions into a structured business report you can copy or download as PDF.
Related articles
How to Build a Weighted KPI Scorecard That Teams Trust
Step-by-step guidance on choosing KPIs, setting weights, handling lower-is-better metrics and avoiding common scorecard mistakes.
4 min read
What Does a Sales Operations Team Actually Do?
A plain-English guide to sales operations: planning, data, reporting, process and coordination, and why strong sales ops makes sales teams faster.
4 min read