Assignment2_Solution(1) - Microsoft Excel 12.0 Answer Report Worksheet[Assignment2_Solution]Problem 1 Report Created 10:09:08 PM Target Cell(Max Cell

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

This preview shows page 1 - 4 out of 6 pages.

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

#### You've reached the end of your free preview.

Want to read all 6 pages?

• Fall '05
• EL