Take home 2-2 MS - Microsoft Excel 14.4 Answer Report Worksheet[Take home 2-2 MS]Sheet1 Report Created 3:44:13 PM Result Solver found a solution All

Take home 2-2 MS - Microsoft Excel 14.4 Answer Report...

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

Microsoft Excel 14.4 Answer Report Worksheet: [Take home 2-2 MS.xlsx]Sheet1 Report Created: 2/27/2017 3:44:13 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.632402 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001 Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, So Objective Cell (Min) Cell Name Original Value Final Value $E$10 Min. z = $0 $230,000 Variable Cells Cell Name Original Value Final Value Integer $B$16 x1 >= 0 1 Binary $B$17 x2 >= 0 1 Binary $B$18 x3 >= 0 0 Binary $B$19 x4 >= 0 0 Binary Constraints Cell Name Cell Value Formula Status Slack $A$11 LHS 1 $A$11>=$C$11 Binding 0 $A$12 LHS 1 $A$12>=$C$12 Binding 0 $A$13 LHS 2 $A$13>=$C$13 Not Binding 1 $A$14 LHS 1 $A$14>=$C$14 Binding 0 $B$16:$B$19= Binary
Image of page 1
olve Without Integer Constraints ,
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture