+ Reply to Thread
Results 1 to 2 of 2

Calculation of Productivity

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    India
    Posts
    1

    Calculation of Productivity

    Hi,
    I hope you would be able to answer my question, I work as a Team Leader in a data entry firm, I would like to know the best way to calculate the productivity of my agents, they process about 150 claims each in 7hours.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi, and welcome to the forum.

    If you're saying that the normal standard is 150 claims in 7 hours, (i.e. an average of 21.43 claims per hour), then one way is to simply divide the actual claims processed by the number of hours taken and express this result as a percentage of 21.43.

    A lot must depend however on how you choose to define productivity. I've simply taken a simple pro rata definition based on a laid down standard. However you might want to factor in the actual productivity achieved over the same period by other agents, and use this as the standard time to calculate a sort of relative productivity.

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculation settings with multiple workbooks open
    By winshent in forum Excel General
    Replies: 0
    Last Post: 09-04-2008, 05:44 AM
  2. run macros on calculation
    By inky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2008, 12:33 AM
  3. Calculation using Macro ( MS Excel 2007 )
    By hally in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-07-2008, 03:48 AM
  4. productivity calculation
    By Tanglefoot in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2006, 11:54 PM
  5. Disable calculation on selected sheets only
    By MikeTNT in forum Excel General
    Replies: 7
    Last Post: 11-12-2006, 01:41 PM

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