At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, a setup time is required. The...

At a machine tool plant, five jobs must be completed each day. The time it takes to do each job depends on the machine used to do the job. If a machine is used at all, a setup time is required. The relevant times (in minutes) are given in the file P06_60.xlsx.

 a. Determine how to minimize the sum of the setup and machine operation times needed to complete all jobs.

 b. Use SolverTable to see how a change in the setup time for machine 4 changes the optimal solution.

c. Use SolverTable to see how a change in the required time for machine 1 to complete job 3 changes the optimal solution.