Reqire Formula help

[sushantrao]

Hi All,


Days Target SLA Achieved SLA Req SLA
1 90% 50%
2 90% 30%
3 90% 50%
90% ?
90% ?
30 90% ?

Average 90.00% 43.33% ?


In above tabel in ? place i want the that % rate which help me to
achive 90% SLA target.

I want to prepre one tabel in which i know the % rate req for the achivement of SLA. for rest of the month days.

Eg : if I achive 43.33% Average SLA for first 3 days of the month
then what % rate needs to be maintain to achive target SLA for rest of 27 days.& that % rate will automatically come in Req SLA column in the place of ? ? .....


Regards,
Sushant.

 

[Joe Was]

I think it is:

( Days_Left x Target% ) / Actual% = Projected % to meet target at end period.

Using your data:


(27 x .9) / .43 = 56.51162 [x 100 = 565.162%]