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

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
Image of page 3
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
Image of page 4
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
Image of page 5
Image of page 6
Image of page 7
Image of page 8

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture