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...

• 16

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
ative
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
NonNegative