Hi,

I am trying to figure out a couple of linked items for weekly data
input.

1/ Method to highlight whether a Service Level is forecast to
violate/breach the target at the end of the month, based on the data
which has already been entered.
2/ If the SLA has not been breached - what is the max value that can be
entered to ensure the SLA is not breached over the remaining weeks in
the month.

Weekly data input will be averaged out at the end of the month to get
an overall monthly figure

i.e.
Target is for month is 90%
January has 4 weeks (1, 2, 3, 4)
wk 1 actual is 89
wk 2 actual is 99
wk 3 ? - what is max that can be achieved in this week to ensure the
target is not violated before wk4?

I do hope this is something you can help me with.

Thanks in advance.
Asim


--
asim
------------------------------------------------------------------------
asim's Profile: http://www.excelforum.com/member.php...o&userid=35530
View this thread: http://www.excelforum.com/showthread...hreadid=552972