Assignment2_Solution(1) - Microsoft Excel 12.0 Answer...

Microsoft Excel 12.0 Answer Report
Worksheet: [Assignment2_Solution.xlsx]Problem 1
Report Created: 1/21/2013 10:09:08 PM
Target Cell (Max)
Cell Name Original Value Final Value
$F$5 Profit Totals $0.00 $1,840.00
Adjustable Cells
Cell Name Original Value Final Value
$B$3 Solution Day-Phone (x1) 0 200
$C$3 Solution Day-Personal (x2) 0 0
$D$3 Solution Night-Phone (x3) 0 480
$E$3 Solution Night-Personal (x4) 0 0
Constraints
Cell Name Cell Value Formula Status Slack
$F$8 Day_Volunteer minutes LHS 1,200 $F$8<=$H$8 Binding 0
$F$9 Day_Volunteer minutes LHS 2,400 $F$9<=$H$9 Binding 0
$F$10 LHS 0 $F$10<=$H$10 Not Binding 300

Day-Phone (x1) Day-Personal (x2) Night-Phone (x3) Night-Personal (x4)
Solution 200 0 480 0
Totals
Profit $2.00 $4.00 $3.00 $7.00 $1,840.00
LHS RHS
Day_Volunteer minutes
6.0 15.0 1,200 <= 1200
Day_Volunteer minutes
5.0 12.0 2,400 <= 2400
1.0 1.0 0 <= 300

Microsoft Excel 14.0 Answer Report
Worksheet: [Assignment2_Solution.xlsx]Problem 2
Report Created: 1/22/2013 11:08:42 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.047 Seconds.
Iterations: 11 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
Objective Cell (Max)
Cell Name Original Value Final Value
$N$8 Profit Totals $0.00 $1,296.00
Variable Cells
Cell Name Original Value Final Value Integer
$B$5 Solution xbs 0 0 Contin
$C$5