calculating productivity

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi,

I have a team of people...I have an amount of time they are using a certain
tool, as well as the amount of tasks they manage in this time. This data is
is imported into XL from a db.....and is used to calculate their
productivity.

so far so good, now comes the bit that I cant get my head around....

some of my team have a second skill, that my db cannot track effectively. I
know how much time they spend on this second task.

The data I have is:

1:Their time using the tool,
2:Their time using the tool working on their second task.
3:The amount of tasks completed in the time frame mentioned in point 1
4:their productivity goal for task 1
5:their productivity goal for task 2

is their any way I can work out their productivity for the second task with
these 5 bits of data?

Tx, Adam
 
Really I think you need to have a 6th piece of information which would be

6.The amount of tasks completed in the time frame mentioned in point 2

this would then allow you to work the productivity out as you would for
their first task.

but this 6th piece of information is not available.

I had a similar experience a while back and because the systems could not
gather this information I had to rely on the team members to keep
track,manually, of the quantity of work that they completed.

This is not the ideal as it is open to cheating and stats that inadvertently
are not completed correctly. It will give you a guideline though of the
individuals performance and you should know your team members well enough to
know if they are adept enough to achieve the levels that there stats sheet
say they achieved.

Hope this helps

Alex
 
Productivity is not an absolute term and can be measured
in many ways. If you were for example measuring
productivity as time per completed task you would need to
know the number of completed tasks, which you do not have
(you did not indicate that you have that information only
the total of all tasks completed) and the time spent,
which you do have.

I guess the real question is why is someone who cannot
solve a simple formula (A/B) responsible for a team of
people. Is spinningplates.com a publicly traded company?
If it is I'm going short.

Jack Straw
 
Apparently not.......it seems you only have the Time spent working on the
Second task and the Productivity Goal for such, ......you need the amount of
tasks managed for the Second Task time spent.....

Vaya con Dios,
Chuck, CABGx3
 
Theres a saying......" There is no such thing as silly questions, only silly
answers"....

by the way, nice email address

Adam
 
Back
Top