Solver Engine Engine Simplex LP Solution Time 0125 Seconds Iterations 4

# Solver engine engine simplex lp solution time 0125

• 32

This preview shows page 30 - 32 out of 32 pages.

Solver Engine Engine: Simplex LP Solution Time: 0.125 Seconds. Iterations: 4 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 NonNegative Objective Cell (Max) Cell Name Original Value Final Value \$D\$6 Z x1 340 340 Variable Cells Cell Name Original Value Final Value Integer \$D\$5 Solutions x1 10 10 Contin \$E\$5 Solutions x2 0 0 Contin \$F\$5 Solutions x3 40 40 Contin Constraints Cell Name Cell Value Formula Status Slack \$D\$14 C1 LHS 50 \$D\$14<=\$F\$14 Not Binding 10 \$D\$15 C2 LHS 40 \$D\$15<=\$F\$15 Binding 0 \$D\$16 C3 LHS 10 \$D\$16>=\$F\$16 Binding 0 \$D\$17 C4 LHS 10 \$D\$17>=\$F\$17 Not Binding 10
Microsoft Excel 16.0 Limits Report Worksheet: [Decision ana.xlsx]Sheet1 Report Created: 3/7/2018 12:03:02 PM Objective Cell Name Value \$D\$6 Z x1 340 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result \$D\$5 Solutions x1 10 10 340 10 340 \$E\$5 Solutions x2 0 0 340 0 340 \$F\$5 Solutions x3 40 0 20 40 340
Variables x1 x2 x3 Coeffecients 2 3 8 Solutions 10 0 40 Z 340 C1 1 1 1 <= 60 C2 2 3 0.5 <= 40 C3 1 0 0 >= 10 C4 1 -3 0 >= 0 LHS Relation RHS C1 50 <= 60 C2 40 <= 40 C3 10 >= 10 C4 10 >= 0