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
Image of page 1
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
Image of page 2
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
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '05
  • EL
  • Harshad number, LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture