homework 7.xlsx - Microsoft Excel 16.0 Answer Report Worksheet[Book1]Sheet1 Report Created 11:44:29 AM Result Solver found a solution All Constraints

homework 7.xlsx - Microsoft Excel 16.0 Answer Report...

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

Microsoft Excel 16.0 Answer Report Worksheet: [Book1.xlsx]Sheet1 Report Created: 9/30/2019 11:44:29 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.125 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNega Objective Cell (Max) Cell Name Original Value Final Value $D$6 Z 11 64.2857142857 Variable Cells Cell Name Original Value Final Value Integer $B$6 X1 1 7.71428571429 Contin $C$6 X2 1 4.28571428571 Contin Constraints Cell Name Cell Value Formula Status Slack $B$10 C1 LHS 12 $B$10<=$C$10 Binding 0 $B$11 C2 LHS 11.142857143 $B$11>=$C$11 Not Binding 7.1428571429 $B$12 C3 LHS 6 $B$12=$C$12 Binding 0
Image of page 1
ative
Image of page 2
Microsoft Excel 16.0 Answer Report Worksheet: [homework 7.xlsx]Sheet1 Report Created: 9/30/2019 2:54:08 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.11 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0.0000001%, Assume Objective Cell (Max) Cell Name Original Value Final Value $D$6 Z 64.285714286 64.2857142857 Variable Cells Cell Name Original Value Final Value Integer $B$6 X1 7.7142857143 7.71428571429 Contin $C$6 X2 4.2857142857 4.28571428571 Contin Constraints Cell Name Cell Value Formula Status Slack $B$10 C1 LHS 12 $B$10<=$C$10 Binding 0 $B$11 C2 LHS 11.142857143 $B$11>=$C$11 Not Binding 7.1428571429 $B$12 C3 LHS 6 $B$12=$C$12 Binding 0
Image of page 3
NonNegative
Image of page 4
Microsoft Excel 16.0 Answer Report
Image of page 5
Image of page 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture