Bierbaum BUSN625 Week Seven LP Model - LP_max Linear Integer and Mixed Integer Programming Signs < = > less than or equal to equals(You need to enter an

Bierbaum BUSN625 Week Seven LP Model - LP_max Linear...

This preview shows page 1 - 3 out of 11 pages.

LP_maxPage 1Linear, Integer and Mixed Integer ProgrammingSigns<less than or equal to=equals (You need to enter an apostrophe first.)>greater than or equal toDataResultsSMLLHSSlack/SurplusObjective$ 20.50 $ 34.00 $ 42.00 signRHS651221Min Demand for Small 1>1400016157.14 -2157.14Max Demand for Small 1<2100016157.14 4842.857Min Demand for Medium 1>620062000Max Demand for Medium 1<1250062006300Min Demand for Large 1 >260026000Max Demand for Large 1 <420026001600Bending/Forming Constraint0.40.70.8 <2340012882.86 10517.14Welding Constraint0.611.2 <2340019014.29 4385.714Painting Constraint1.42.63.1 <46800468000ResultsVariables16157.1462002600Objective$ 651,221.43
Background image
Microsoft Excel 14.0 Answer ReportWorksheet: [Solver.xlsx]LP_maxReport Created: 4/17/2015 7:35:26 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.046 Seconds.Iterations: 5 Subproblems: 0Solver OptionsMax Time 100 sec, Iterations 100, Precision 0.000001Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without IntegeObjective Cell (Max)CellNameOriginal ValueFinal Value$H$10RHS LHS0 651221.4285714Variable CellsCellNameOriginal ValueFinal ValueInteger$B$22Variables S0 16157.14285714 Contin$C$22Variables M06200 Contin$D$22Variables L02600 ContinConstraintsCellNameCell ValueFormulaStatusSlack$K$11> < constraints0 $K$11<=$L$11Binding0$K$12< < constraints16157.1428571 $K$12<=$L$12Not Binding4842.8571429$K$13> < constraints0 $K$13<=$L$13Binding0$K$14< < constraints6200 $K$14<=$L$14Not Binding6300$K$15> < constraints
Background image
Image of page 3

You've reached the end of your free preview.

Want to read all 11 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture