Week 7.Integer and Binary Programming Problems Solution - Microsoft Excel 14.0 Answer Report Worksheet[7_Integer_and_Binary_Programming Problems

Week 7.Integer and Binary Programming Problems Solution -...

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

Microsoft Excel 14.0 Answer Report Worksheet: [7_Integer_and_Binary_Programming Problems Alternate Solution.xls]IP_Harrison_Elec Report Created: 9/24/2015 12:49:22 PM Result: Solver found an integer solution within tolerance. All Constraints are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.094 Seconds. Iterations: 1 Subproblems: 2 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $D$5 Profit Total Profit 3300 3200 Variable Cells Cell Name Original Value Final Value $B$3 Solution X1 (# of Chandeliers) 3.75 3 $C$3 Solution X2 (# of Ceiling Fan) 1.5 2 Constraints Cell Name Cell Value Formula $D$8 Wiring hours LHS 12 $D$8<=$F$8 $D$9 Assembly hours LHS 28 $D$9<=$F$9 $B$3:$C$3=Integer
Image of page 1
ctric1 Integer Integer Integer Status Slack Binding 0 Not Binding 2
Image of page 2
Microsoft Excel 16.0 Answer Report Worksheet: [7_Integer_and_Binary_Programming Problems Solution.xlsx]IP_Harrison_Electric Report Created: 11/6/2016 10:36:11 PM Result: Solver found an integer solution within tolerance. All Constraints are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 1 Subproblems: 4 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0.05%, Assume NonNegat Objective Cell (Max) Cell Name Original Value Final Value $D$5 Profit Total Profit $ - $ 3,200.00 Variable Cells Cell Name Original Value Final Value $B$3 Solution X1 (# of Chandeliers) 0 3 $C$3 Solution X2 (# of Ceiling Fan) 0 2 Constraints Cell Name Cell Value Formula $D$8 Wiring hours LHS 12 $D$8<=$F$8 $D$9 Assembly hours LHS 28 $D$9<=$F$9 $B$3:$C$3=Integer
Image of page 3
tive Integer Integer Integer Status Slack Binding 0 Not Binding 2
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 14 pages?

  • Summer '17
  • Jasmin Manseau
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture