Efficiency,Productivity & Utilization.

[pulsecoding]

Hi all,

Thanks for reading this post.

We have online cases to process on system.
There are SLA's for different cases.
This SLA is in terms of time taken to process one case say 2 min.
we have time tracking sheet where each processor logs in intime & outtime for each case.
I get excel time and normal time of each case processed.
I need to calculate Efficiency,Productivity & Utilization of each data processor.

pls let me know how to calculate.
I have two three formulas but not able to relate with what is found on net.

thanks
Abhijeet

 

[Ruddles]

Start by posting a representative sample of your data here. Select a nice small font and place a border around the cells, then copy-and-paste directly into a post.

Next you'll need to clarify in your own mind what you mean by the terms efficiency, productivity and utilisation. Do they all mean the same thing or are they all different? (I don't know.) Note that your management - or whoever will be looking at these figures - may have a different understanding of these words.

I think you're going to have to do that before anyone can write all the formulae you need.

 

[pulsecoding]

Hi,

Ruddles Thanks for your reply. Efficiency,Productivity & Utilization are different terms and they have different meanings and different formula's.
Below is the sample data. Time taken to process 5 cases is 8.5 and the SLA for one case is 2 minutes.

<table x:str="" style="border-collapse: collapse; width: 466px; height: 59px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" width="74"> <col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <col style="width: 64pt;" width="85" span="2"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 56pt;" width="74" height="17">Excel time</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">Count</td> <td class="xl25" style="border-left: medium none; width: 53pt;" width="70">efficiency
</td> <td class="xl25" style="border-left: medium none; width: 64pt;" width="85">Productivity</td> <td class="xl25" style="border-left: medium none; width: 64pt;" width="85">Utilization</td> <td class="xl25" style="border-left: medium none; width: 48pt;" width="64">SLA</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="border-top: medium none; height: 12.75pt; width: 56pt;" x:num="" width="74" height="17">8.5</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 48pt;" x:num="" width="64">5</td> <td class="xl27" style="border-top: medium none; border-left: medium none; width: 53pt;" width="70"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none; width: 64pt;" width="85"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none; width: 64pt;" width="85"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none; width: 48pt;" x:num="" width="64">2</td> </tr> </tbody></table>

thanks