The following method is a simple analysis for managing team of their productivity check.
1. Open Excel
2. Keep column as Employee, Tasks assigned, Task finished, Final Percentage
3.Enter the data as above and update Max Tasks assigned is same for all employee and Task finish as per employee on end of the report/month.
4.In Final percentage, calculate as below.
Example as below and update
