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...

• Homework Help
• 25
• 80% (5) 4 out of 5 people found this document helpful

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
5 60 72 68 70 75 Assigned 1 1 1 1 1
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
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
unds onNegative
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
5 60 72 68 70 75 Assigned 1 1 1 1 1
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.