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)
Image of page 5
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
Image of page 6
tive
Image of page 7
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
Image of page 8
Image of page 9

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