There are 15 jobs that must be done by 10 employees. Each job must be done by a single employee, and each employee can do at most two jobs. The times (in minutes) for the employees to do the jobs are...

There are 15 jobs that must be done by 10 employees. Each job must be done by a single employee, and each employee can do at most two jobs. The times (in minutes) for the employees to do the jobs are listed in the file P05_70.xlsx, where blanks indicate disallowed assignments.

a. Assuming that not all employees have to be assigned, find the assignments that minimize the total time to complete all jobs.

b. How much longer does it take to complete all jobs if every employee must be assigned to at least one job? With this modified model, use SolverTable to see how the total time to complete all jobs varies as the maximum number of jobs per employee is allowed to vary from 2 to 5 in increments of 1.