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
ctric1 Integer Integer Integer Status Slack Binding 0 Not Binding 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
tive Integer Integer Integer Status Slack Binding 0 Not Binding 2

#### You've reached the end of your free preview.

Want to read all 14 pages?

• Summer '17
• Jasmin Manseau
• LHS