Solver Engine Engine Simplex LP Solution Time 0125 Seconds Iterations 4

Solver engine engine simplex lp solution time 0125

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture