D E J3 51 52 35 30 J4 53 52 50 53 Range names used: Use these Assigns 71(15 points)$B$12:$E$15 Range names Colums = 1(15 points)$B16 SES16 (already RowSums - 1 (15 points. I$F$12 SF515 Times -1 (15 points58$5 SES TotTime 1(15 points58520 Four employees are to be assigned to particular farka at a job, Goronid by J1, 32, 33, 34. Their times for completing given task is in blue (85EB) Unfortunately, these tasks must be performed sequently and Sums Required only employee can perform a particular task and each pays cannot perform more than 1 task in total Set up and solve this assignment problem using the simples LP algorithm a) What is the minimum total time to complete all four tasi 1 347 Also state the sequence of work for the four employees te De Sean goes first, etc.) J3 c Assigning employees to tasks 3 Times in hours 4 J1 J2 5 Marlene 45 54 8 DeSean 51 80 7 Peyton 50 53 8 LeSean 29 54 9 10 Assignments 11 J1 J2 12 Marlene 13 De Sean 14 Peyton 15 LeSean 16 Sums 17 18 Required 19 20 Total time 21 22 23 24 25 28 27 J4 Fill in the light blue shaded cells b) of the 4 employees, who will complete the task the fastest and what task does that correspond to 7 For example, you answer could be "LeSean completes his tasks (1) the fastest, he does itin 45 hours