# Efficiency,Productivity & Utilization.

1. ## Efficiency,Productivity & Utilization.

Hi all,

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

2. ## Re: Efficiency,Productivity & Utilization.

I get excel time and normal time of each case processed.
What are "excel time" and "normal time"?

I need to calculate Efficiency,Productivity & Utilization of each data processor.
To give an Excel solution you need to define what you mean by each of these.

Efficiency and productivity are closely related. Productivity is generally measured by how much work is done per time period. How are you measuring work done--number of cases? What time period do you want to use? You might measure efficiency as work per utilized time.

Utilization is how much of a processor's time is spent doing work (regardless of how much work actually gets accomplished).

So you might have one processor that handles 10 cases in 2 hours and is idle for 30 minutes during that time, productivity would be 5 cases per hour and utilization would be 75%. Efficiency is 6.7 cases per utilized hour.

Another processor that handles 8 cases in two hours and is idle for 12 minutes has lower productivity of 4 cases per hour but higher utilization of 90%. Efficiency is onlhy 4.4 cases per utilized hour.

These are just my own ideas, you have to decide from a business standpoint what information you really need then it will be straightforward to describe how to implement it in Excel.

3. ## Re: Efficiency,Productivity & Utilization.

Last I have taken below formula.

Efficiency = Time earned / productive time

Time earned = SLA * no of cases processed

Productive time = office hours - ( break time + non productive time)

4. ## Re: Efficiency,Productivity & Utilization.

Two years later....

Once you have defined your formulas and units, the implementation in Excel is trivial, if you know the basics of Excel. See attached for an example.

Enter your data in the shaded columns. The other columns have formulas to calculate your results. Efficiency is a dimensionless metric. 1 means efficiency is exactly on target, <1 means it's lower than expected, >1 means it's greater than expected.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1