HFCV_Refueling_Example - Microsoft Excel 14.0 Answer Report Worksheet[HFCV_Refueling_Example]Location Prob No Binary Report Created 8:44:23 AM Result

HFCV_Refueling_Example - Microsoft Excel 14.0 Answer Report...

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

Microsoft Excel 14.0 Answer Report Worksheet: [HFCV_Refueling_Example.xlsx]Location Prob No Binary Report Created: 1/28/2013 8:44:23 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.047 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer Constraints Objective Cell (Min) Cell Name Original Value Final Value $K$21 Min N Value 0 2 Variable Cells Cell Name Original Value Final Value Integer $E$24 Value x0 0 0 Contin $F$24 Value x1 0 1 Contin $G$24 Value x2 0 0 Contin $H$24 Value x3 0 0 Contin $I$24 Value x4 0 1 Contin $J$24 Value x5 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $K$15 Value 1 $K$15>=$M$15 Binding 0 $K$16 Value 1 $K$16>=$M$16 Binding 0 $K$17 Value 1 $K$17>=$M$17 Binding 0 $K$18 Value 1 $K$18>=$M$18 Binding 0 $K$19 Value 1 $K$19>=$M$19 Binding 0 $E$24 Value x0 0 $E$24>=0 Binding 0 $F$24 Value x1 1 $F$24>=0 Not Binding 1 $G$24 Value x2 0 $G$24>=0 Binding 0 $H$24 Value x3 0 $H$24>=0 Binding 0 $I$24 Value x4 1 $I$24>=0 Not Binding 1 $J$24 Value x5 0 $J$24>=0 Binding 0
Image of page 1
Value =,<=,>=? Reqirement 1 1 1 >= 1 1 1 1 1 >= 1 1 1 1 1 >= 1 1 1 1 1 >= 1 1 1 1 >= 1 Min N 1 1 1 1 1 1 2 Value 0 1 0 0 1 0 x 0 x 1 x 2 x 3 x 4 x 5 x 0 x 1 x 2 x 3 x 4 x 5 A B C D E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Image of page 2
Microsoft Excel 14.0 Answer Report
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture