Hello all.
I'm trying to find the best formula to measure the productivity and efficiency of each worker in a group.
The gathered data includes:
Worker, Task 1s Performed, T1 Units Processed, T1 Time (per unit, per task, or total time)
- There are multiple tasks, each with their own unit and time columns: Task 2, Task 3, etc.
- Likely, I will establish a "standard" time for how long each task should take, or how long it should take to process each unit. This will allow me to calculate the efficiency of the worker, which I consider the +/- of the standard. I was going to use the average (for all workers), but that allows workers the opportunity to control the standard.
- From a productivity standpoint, it gets more complicated. Task 1s are not all created equal. Some may demand many more units, while others can be just 1 unit. I need to consider the "workload" of each worker using both Task 1s performed and T1 Units processed. So Worker A may have processed 15% of all Task 1s, but only 10% of Task 1 Units.
Other tasks (say, Task 2, Task 3) ARE all created equal, and these tasks will have a 1/1 ratio task/units.
I included a sample sheet w/ a bunch of related columns. What I need is the best way to come up w/ a rating for each task (considering task load, unit load and efficiency), but also a total rating with all tasks considered. Also, should I have two efficiency columns -- one for per-task and one for per-unit?
I'll be around to respond to any comments/questions.
Thanks much!
