# Lecture3(Duality).xlsx - Decision Objective Constraints...

• No School
• AA 1
• 8

This preview shows page 1 - 5 out of 8 pages.

x1 x2 x3 Decision 132.00 0 60.00 Objective 10 12 11 1,980.00 Maximize Constraints LHS RHS First 7 4 5 1,224.00 <= 1,224.00 Second 5 7 6 1,020.00 <= 1,020.00
Microsoft Excel 16.0 Answer Report Worksheet: [Lecture3(Duality).xlsx]Primal Report Created: 10/2/2019 9:30:10 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativ Objective Cell (Max) Cell Name Original Value Final Value \$E\$3 Objective 0.00 1,980.00 Variable Cells Cell Name Original Value Final Value Integer \$B\$2 Decision x1 0.00 132.00 Contin \$C\$2 Decision x2 0 0 Contin \$D\$2 Decision x3 0.00 60.00 Contin Constraints Cell Name Cell Value Formula Status Slack \$E\$6 First LHS 1,224.00 \$E\$6<=\$G\$6 Binding 0 \$E\$7 Second LHS 1,020.00 \$E\$7<=\$G\$7 Binding 0
ve
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Lecture3(Duality).xlsx]Primal Report Created: 10/2/2019 8:09:36 PM