+ Reply to Thread
Results 1 to 4 of 4

Efficiency,Productivity & Utilization.

  1. #1
    Registered User
    Join Date
    09-04-2010
    Location
    pune, india
    MS-Off Ver
    excel xp
    Posts
    11

    Efficiency,Productivity & Utilization.

    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

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,464

    Re: Efficiency,Productivity & Utilization.

    Quote Originally Posted by abhijeetkadam View Post
    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.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-04-2010
    Location
    pune, india
    MS-Off Ver
    excel xp
    Posts
    11

    Re: Efficiency,Productivity & Utilization.

    Thanks for your answer 6StringJazzer!

    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. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,464

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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