Please Help-Urgent! How to calculate KPI score with target range?

[zuhal]

Hi, i'm in the midst of developing KPI dashboard. My table is as follow:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]KPI Objectives[/TD]
[TD]weightage (%)[/TD]
[TD]Target[/TD]
[TD]Target[/TD]
[TD]Actual Achievement[/TD]
[TD]KPI Score (%)[/TD]
[TD]Actual Score (weightage)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Base[/TD]
[TD]Stretch[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1. New business[/TD]
[TD]90
[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]78%[/TD]
[TD]8%[/TD]
[/TR]
[TR]
[TD]2. Get agreement signed[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]50%[/TD]
[TD]8%[/TD]
[/TR]
</tbody>[/TABLE]

My questions are as follow:
1. How to automate the KPI Score (%) column? what suppose the formula looks like?
2. the KPI Score should change accordingly when i change the data in 'actual achievement' column.
3. the 'actual achievement' is compared against the range of base-stretch target, e.g. if i got new business at month 8, i should achieve 50% and if at month 5, it should be 100%.

Need the expert assistance on this

 

[Kaper]

Have a look into Microsoft tutorial Walkthrough: Calculate normalized scores for KPIs - PerformancePoint Server