Solution 3 2 total profit profit 600 700 320000 lhs

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