0 Contin C17 0 Contin D17 0 Contin E17 Task 1 1 Contin F17 0 Contin G17 0

# 0 contin c17 0 contin d17 0 contin e17 task 1 1

• Homework Help
• 10
• 100% (4) 4 out of 4 people found this document helpful

This preview shows page 3 - 8 out of 10 pages.

0 Contin \$C\$17 0 0 Contin \$D\$17 0 0 Contin \$E\$17 Task 1 1 Contin \$F\$17 0 0 Contin \$G\$17 0 0 Contin Constraints
Cell Name Cell Value Formula Status Slack \$C\$18 Assigned 1 \$C\$18>=1 Binding 0 \$D\$18 Assigned 1 \$D\$18>=1 Binding 0 \$E\$18 Assigned Task 1 \$E\$18>=1 Binding 0 \$F\$18 Assigned 1 \$F\$18>=1 Binding 0 \$G\$18 Assigned 1 \$G\$18>=1 Binding 0 \$H\$13 Assigned 1 \$H\$13<=1 Binding 0 \$H\$14 Assigned 1 \$H\$14<=1 Binding 0 \$H\$15 Assigned 1 \$H\$15<=1 Binding 0 \$H\$16 Assigned 1 \$H\$16<=1 Binding 0 \$H\$17 Assigned 1 \$H\$17<=1 Binding 0 \$D\$15 0 \$D\$15=0 Binding 0 \$F\$15 0 \$F\$15=0 Binding 0
Exercise 3.2 Parameters Task 1 2 3 4 5 1 50 25 78 64 60 2 43 30 70 56 72 Programer 3 60 28 80 66 68 4 54 29 75 60 70 5 45 32 70 62 75 Decisions 1 2 3 4 5 Assigned 1 0 0 0 0 1 1 2 1 0 0 0 0 1 3 0 1 0 0 0 1 4 0 0 0 1 0 1 5 0 0 1 0 0 1 Assigned 1 1 1 1 1 Objective Total Hours 261 c.How would your solution change if programmer 3 could not be assigned to tasks 2 or 4? Prog 1 Task 2 Prog 2 Task 1 Total Hours 266 Prog 3 Task 5 Prog 4 Task 4 It would require an additional 5 hours to complete all tasks. Prog 5 Task 3