Discrete ManufacturingFree worksheetPDF, Excel, Word export

KPI Target Setting Worksheet

A target pulled from the air gets ignored. This worksheet anchors each target to what the plant has actually done, using a 12-month baseline and its best month, then shows how large a jump you are asking for.

Download:

Gap to target	Change vs baseline (%)	Share of baseline-to-best gap
6	7%	85.7%
0.6	14.3%	66.7%
1.5	1.6%	60%
-5	-9.6%	62.5%
10	12.8%	83.3%

For KPIs where lower is better (days, ppm), the gap is negative. That is expected. A target that sits between baseline and best month is usually achievable; one beyond the best month needs a named change, such as new equipment or a process fix.

Pull 12 months of KPI history automatically

Optional expert help to extract baseline KPI data from your ERP without manual exports.

Optional. The tool and every export work without this. No spam.

How to use it

Pull twelve months of each KPI from your ERP or reporting layer. Enter the average as baseline and the best single month as best. Type your proposed target and read the gap, the percent change versus baseline, and how much of the baseline-to-best distance you are claiming. Export to Excel for the planning meeting. Revise the target, not the data, when the ratio looks unrealistic.

The method behind the columns

The best month is proof that the process can reach that level at least once. A target at 50 to 80 percent of the distance from baseline to best is usually a fair commitment for a year. Targets beyond the best month need a specific improvement project behind them. For lower-is-better KPIs the same logic holds with the sign reversed.

Gap to target: target minus baseline
Change vs baseline: gap divided by baseline
Share of distance: how far toward your best month the target sits
Use medians if one-off events distort the average

Common mistakes

Do not set targets from budget percentages alone, and do not copy industry benchmarks without checking the definition: on-time delivery to request date and to promise date are very different measures. Avoid changing the definition mid-year, since the trend becomes meaningless. Record any known one-off event, such as a plant shutdown or an ERP cutover, beside the baseline so the next reader knows why a month looks odd.

Frequently Asked Questions

Should targets be the same every year?

Not usually. Once a target is met for several months, either raise it or move attention to a weaker KPI. A target that never moves tends to become a ceiling rather than a goal.

What baseline period is best?

Twelve months smooths seasonality. If the process changed recently, such as a new ERP or routing, use only the months since the change and note the shorter window beside the KPI.

How do I handle lower-is-better KPIs?

Enter values as usual. The gap will be negative, which is correct. Read the share-of-distance column the same way, since both baseline-to-best and baseline-to-target move in the same direction.

Are benchmark values useful?

They help as a sanity check but only when the definitions match yours. Your own best month is a safer anchor because it is measured the way your ERP measures.

If pulling twelve months of KPI history takes a week, Netray can help automate the extraction from your ERP while keeping the data on your own systems.

Talk to an Expert Explore More Free Tools

Related Tools

Costing & Finance

More Discrete Manufacturing tools

See all

Back to All Tools