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.
