Problem Set (3-3) (QSO-320) - Assigning Tasks Parameters Programmer Decisions(Assignments 1 2 3 4 5 Assigned Objective(Minimize Days 261 Task 1 2 3 4 5

Problem Set (3-3) (QSO-320) - Assigning Tasks Parameters...

This preview shows page 1 - 10 out of 25 pages.

Assigning Tasks Parameters Task 1 2 3 4 1 50 25 78 64 2 43 30 70 56 Programmer 3 60 28 80 66 4 54 29 75 60 5 45 32 70 62 Decisions (Assignments) 1 2 3 4 5 1 0 0 0 0 1 2 1 0 0 0 0 3 0 1 0 0 0 4 0 0 0 1 0 5 0 0 1 0 0 Assigned 1 1 1 1 1 Objective (Minimize Days) 261
Image of page 1
5 60 72 68 70 75 Assigned 1 1 1 1 1
Image of page 2
Microsoft Excel 14.5 Answer Report Worksheet: [Workbook7]Sheet1 Report Created: 10/9/2015 7:46:03 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 5.685988 Seconds. Iterations: 19 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001, Use Automatic Scaling Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward , Require Bou Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assume No Objective Cell (Min) Cell Name Original Value Final Value $B$20 Assigned 0 261 Variable Cells Cell Name Original Value Final Value Integer $C$12 Task 0 0 Contin $D$12 0 0 Contin $E$12 0 0 Contin $F$12 0 0 Contin $G$12 0 1 Contin $C$13 Task 0 1 Contin $D$13 0 0 Contin $E$13 0 0 Contin $F$13 0 0 Contin $G$13 0 0 Contin $C$14 Task 0 0 Contin $D$14 0 1 Contin $E$14 0 0 Contin $F$14 0 0 Contin $G$14 0 0 Contin $C$15 Task 0 0 Contin $D$15 0 0 Contin $E$15 0 0 Contin $F$15 0 1 Contin $G$15 0 0 Contin $C$16 Task 0 0 Contin $D$16 0 0 Contin $E$16 0 1 Contin $F$16 0 0 Contin $G$16 0 0 Contin
Image of page 3
Constraints Cell Name Cell Value Formula Status Slack $C$17 Assigned Task 1 $C$17>=1 Binding 0 $D$17 Assigned 1 $D$17>=1 Binding 0 $E$17 Assigned 1 $E$17>=1 Binding 0 $F$17 Assigned 1 $F$17>=1 Binding 0 $G$17 Assigned 1 $G$17>=1 Binding 0 $H$12 Assigned 1 $H$12<=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
Image of page 4
unds onNegative
Image of page 5
Image of page 6
Assigning Tasks Parameters Task 1 2 3 4 1 50 25 78 64 2 43 30 70 56 Programmer 3 60 28 80 66 4 54 29 75 60 5 45 32 70 62 Decisions (Assignments) 1 2 3 4 5 1 0 1 0 0 0 2 1 0 0 0 0 3 0 0 0 0 1 4 0 0 0 1 0 5 0 0 1 0 0 Assigned 1 1 1 1 1 Objective (Minimize Days) 266
Image of page 7
5 60 72 68 70 75 Assigned 1 1 1 1 1
Image of page 8
Microsoft Excel 14.5 Answer Report Worksheet: [Workbook7]3.2c Report Created: 10/9/2015 7:56:43 PM Result: Solver has converged to the current solution.
Image of page 9
Image of page 10

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture