Distribute work among the people

I need to distribute work among the people. We have employee master in that we have list of employee and benchmark for every employee.
In Daily Task Received table we have total no. of task for day and that total task. we need to distribute between the employee in Work Allocation between employee table
E.g. In Total Task1 received for day is 100 count that distributed in employee 1 40 as per benchmark employee2 40 & balance in employee 3 20 total 100.
I have managed to automate table 1(Daily Task Received) but need help in table 2 (Work Allocation between employee).

Thank You....