Solution 3 2 Total Profit Profit 600 700 320000 LHS Sign RHS Wiring hours 2 3

# Solution 3 2 total profit profit 600 700 320000 lhs

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

Solution 3 2 Total Profit Profit 600 700 \$ 3,200.00 LHS Sign RHS Wiring hours 2 3 12 <= 12 Assembly hours 6 5 28 <= 30 X1 (# of Chandeliers) X2 (# of Ceiling Fan)
Microsoft Excel 14.0 Answer Report Worksheet: [7_Integer_and_Binary_Programming Problems Alternate Solution.xls]Sheet4 Report Created: 9/24/2015 1:01:23 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.717 Seconds. Iterations: 13 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 NonNegat Objective Cell (Max) Cell Name Original Value Final Value \$Q\$5 Rating (max) Max rating 0 13.3 Variable Cells Cell Name Original Value Final Value Integer \$B\$3 Solution v11 0 0 Contin \$C\$3 Solution v12 0 0 Contin \$D\$3 Solution v13 0 1 Contin \$E\$3 Solution v14 0 0 Contin \$F\$3 Solution v21 0 0 Contin \$G\$3 Solution v22 0 0 Contin \$H\$3 Solution v23 0 0 Contin \$I\$3 Solution v24 0 1 Contin \$J\$3 Solution v31 0 0 Contin \$K\$3 Solution v32 0 1 Contin \$L\$3 Solution v33 0 0 Contin \$M\$3 Solution v34 0 0 Contin \$N\$3 Solution v41 0 1 Contin \$O\$3 Solution v42 0 0 Contin \$P\$3 Solution v43 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack \$Q\$8 Course to Prof A LHS 1 \$Q\$8=\$S\$8 Binding 0 \$Q\$9 Course to Prof B LHS 1 \$Q\$9=\$S\$9 Binding 0 \$Q\$10 Course to Prof C LHS 1 \$Q\$10=\$S\$10 Binding 0 \$Q\$11 Course to Prof D LHS 1 \$Q\$11=\$S\$11 Binding 0 \$Q\$12 Course A is assigned LHS 1 \$Q\$12=\$S\$12 Binding 0 \$Q\$13 Course B is assigned LHS 1 \$Q\$13=\$S\$13 Binding 0 \$Q\$14 Course C is assigned LHS 1 \$Q\$14=\$S\$14 Binding 0 \$Q\$15 Course D is assigned LHS 1 \$Q\$15=\$S\$15 Binding 0
tive
Microsoft Excel 14.0 Sensitivity Report Worksheet: [7_Integer_and_Binary_Programming Problems Alternate Solution.xls]Sheet4 Report Created: 9/24/2015 1:01:26 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 Solution v11 0 0 2.8 0.3 0 \$C\$3 Solution v12 0 -0.2 2.2 0.2 1.00E+030 \$D\$3 Solution v13 1 0 3.3 1.00E+030 0.3

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

Want to read all 14 pages?

• Summer '17
• Jasmin Manseau
• LHS