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:

KPI Objectives	weightage (%)	Target	Target	Actual Achievement	KPI Score (%)	Actual Score (weightage)
		Base	Stretch
1. New business	90	8	5	6	78%	8%
2. Get agreement signed	10	12	11	12	50%	8%

<tbody>
</tbody>

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