Please submit your concern

Explanation:

From the final weighted rating , planning average rating and execution average rating we can calculate the departments to which they belong on the basis of weightage distribution.
Employee 1001 has a planning average rating of 9 and execution average rating of 3 and final rating is 4.2
Using weighted average method we can say than 20% weightage is given to planning and 80% weightage is given to execution average rating.

Similarly for other employees also we can calculate this Employees in department which gives 40% weight to planning 60% weightage to execution are 1001, 1002
Employees in department which gives 30% weight to planning 70% weightage to execution are 1003, 1004

Employees in department which gives 20% weight to planning 80% weightage to execution are 1007, 1008, 1005, 1006