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

• Notes
• 8
• 100% (1) 1 out of 1 people found this document helpful

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