Question: PoyrazCo Foundry & Machine Tools has 14 machines and 13 jobs to be completed. The time (number of minutes) required to set up each machine
PoyrazCo Foundry & Machine Tools has 14 machines and 13 jobs to be completed. The time (number of minutes) required to set up each machine for completing each job is shown in PoyrazCo.xlsx. PoyrazCo wants to minimize the total setup time needed to complete all jobs, given that All jobs must be completed All machines must be used Job #11 must be completed by Machine #7 Machine #4 must not be assigned to Job #4 Two machines must be assigned to Job #13 Job #3 must be completed by either Machine #5 or Machine #8 Given above information, what is the minimum total setup time needed to complete all jobs?
A) 924.39 minutes B) 957.87 minutes C) 964.35 minutes D) 965.97 minutes E) 982.15 minutes F) 987.35 minutes G) 994.65 minutes H) 999.99 minutes I) 1,000.00 minutes J) Infeasible solution: model cannot be solved, one or more of the constraints cannot be satisfied.

Setup Times Machine #1 Machine #2 Machine #3 Machine #4 Machine #5 Machine #6 Machine #7 Machine #8 Machine #9 Machine #10 Machine #11 Machine #12 Machine #13 Machine #14 Job #1 Job #2 Job #3 Job #4 87.373835392494 74.42956348249595.464005336244 76.047597471245 82.519733426244 66.339393538746 71.193495504995 85.755801403744 82.51973342624492.227937358744 71.193495504995 87.373835392494 64.72135954999695.464005336244 82.519733426244 67.957427527495 82.519733426244 64.72135954999685.755801403744 85.755801403744 66.339393538746 71.19349550499597.082039324993 85.755801403744 76.04759747124593.845971347494 92.22793735874485.755801403744 87.373835392494 76.04759747124595.464005336244 85.755801403744 88.991869381244|79.283665448745 80.901699437495 79.283665448745 85.755801403744 87.37383539249476.047597471245 79.283665448745 77.66563145999566.33939353874688.991869381244 80.901699437495 79.283665448745 77.665631459995 | 66.339393538746 72.811529493745 66.33939353874690.609903369994 77.665631459995 69.575461516245 77.66563145999595.46400533624497.08203932499393.845971347494 Setup Times Machine #1 Machine #2 Machine #3 Machine #4 Machine #5 Machine #6 Machine #7 Machine #8 Machine #9 Machine #10 Machine #11 Machine #12 Machine #13 Machine #14 Job #1 Job #2 Job #3 Job #4 87.373835392494 74.42956348249595.464005336244 76.047597471245 82.519733426244 66.339393538746 71.193495504995 85.755801403744 82.51973342624492.227937358744 71.193495504995 87.373835392494 64.72135954999695.464005336244 82.519733426244 67.957427527495 82.519733426244 64.72135954999685.755801403744 85.755801403744 66.339393538746 71.19349550499597.082039324993 85.755801403744 76.04759747124593.845971347494 92.22793735874485.755801403744 87.373835392494 76.04759747124595.464005336244 85.755801403744 88.991869381244|79.283665448745 80.901699437495 79.283665448745 85.755801403744 87.37383539249476.047597471245 79.283665448745 77.66563145999566.33939353874688.991869381244 80.901699437495 79.283665448745 77.665631459995 | 66.339393538746 72.811529493745 66.33939353874690.609903369994 77.665631459995 69.575461516245 77.66563145999595.46400533624497.08203932499393.845971347494
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
