Lower Objective Upper Objective Cell Name Value Limit Result Limit Result

Lower objective upper objective cell name value limit

This preview shows page 5 - 10 out of 11 pages.

Lower ObjectiveUpperObjectiveCellNameValueLimitResultLimitResult$B$22Variables S16157.14291400060700016157.1429 651221.429$C$22Variables M62006200 651221.4296200 651221.429$D$22Variables L26002600 651221.4292600 651221.429
Background image
MaximizeZ =651221By Changing,S =16157.1M =6200L = 2600Subject to,Min Demand for Small 16157.1 >=14,000.00 Max Demand for Small 16157.1 <=21,000.00 Min Demand for Medium 6200 >=6,200.00 Max Demand for Medium 6200 <=12,500.00 Min Demand for Large 2600 >=2,600.00 Max Demand for Large 2600 <=4,200.00 Bending/Forming Constrain12882.9 <=23,400.00 Welding Constraint19014.3 <=23,400.00 Painting Constraint46800 <=46,800.00
Background image
Microsoft Excel 14.0 Answer ReportWorksheet: [Solver.xlsx]Question 2Report Created: 2/19/2016 3:35:49 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfiedSolver EngineEngine: Simplex LPSolution Time: 0.031 Seconds.Iterations: 5 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NObjective Cell (Max)CellNameOriginal Value Final Value$D$3Z =0 651221.4286Variable CellsCellNameOriginal Value Final ValueInteger$D$5S =0 16157.14286 Contin$D$6M =06200 Contin$D$7L = 02600 ContinConstraintsCellNameCell ValueFormulaStatusSlack$C$10Min Demand for Small L = 16157.14286 $C$10>=$E$1Not Binding 2157.14286$C$11Max Demand for Small L = 16157.14286 $C$11<=$E$1Not Binding 4842.85714$C$12Min Demand for Medium L = 6200 $C$12>=$E$1Binding0$C$13Max Demand for Medium L = 6200 $C$13<=$E$1Not Binding6300$C$14Min Demand for Large L = 2600 $C$14>=$E$1Binding0$C$15Max Demand for Large L = 2600 $C$15<=$E$1Not Binding1600$C$16Bending/Forming Constraint L =12882.85714 $C$16<=$E$1Not Binding 10517.1429$C$17Welding Constraint L = 19014.28571 $C$17<=$E$1Not Binding 4385.71429$C$18Painting Constraint L = 46800 $C$18<=$E$1Binding0
Background image
d.NonNegative
Background image
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Solver.xlsx]Question 2Report Created: 2/19/2016 3:35:49 PMVariable CellsFinalReducedObjectiveAllowableCellNameValueCostCoefficientIncrease$D$5S =16157.1429020.51.00E+030$D$6M =6200034 4.07142857$D$7L = 2600042 3.39285714ConstraintsFinalShadowConstraint AllowableCellNameValuePriceR.H. SideIncrease$C$10Min Demand for Small L = 16157.1429014000 2157.14286$C$11Max Demand for Small L = 16157.14290210001.00E+030$C$12Min Demand for Medium L = 6200 -4.07142857
Background image
Image of page 10

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