-
Team Average by FTE
I'm trying to work out if there's a formula or another way of doing my problem.
Basically, I have a team of people who perform "actions" as part of their job. An action being, basically, updating this, calling that person, and just keeping all these logged on the system.
I'm trying to calculate the performance between individuals and the team average based on full time equivalent (FTE) instead of physical bodies. I'm also trying to take into account the individuals' working days (Monday to Friday)
So, for the month of September 2003, I have 22 working days.
5 employees with a FTE of 1 worked all 22 days. 1 worked 9 days and another worked 19 days.
I have two other employees. One with a FTE of 0.6 who worked 9 days and the other with an FTE of 0.4 who worked all 22 days.
So, assuming the following test data, is there any way I can count the team average by FTE taking into account days worked, or is my thinking completely wrong regarding this?
Code:
Actions Days FTE
500 22 1
750 22 1
350 10 1
800 22 1
300 9 0.6
350 22 0.4
400 19 1
550 22 1
-
If I understand it right, an FTE of ! says this guy works full days, a FTE of 0.5 says he works only a half day.
And the actions are all "events" or whatever you logg per day. Correct?
So in your example the team does work for (4 *22) + 19 + 10 + (9* 0.6) + (22*0.4)= 131,2 days.
They have 4000 actions logged. I would divide that by the 131,2 day's to get the average actions/day.
-
An FTE of 1 indicates that a person works the fully contracted 35 hours a week.
Ergo a FTE of 0.6 indicates 21 hours of the contracted 35.
7 hours in a day.
-
Look's like I got it correct.
You can calculate the average action/day of the team, and of each individual. For those having a FTE other than 1, just divide the outcome by the FTE!
