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
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
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
d.NonNegative
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

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

Want to read all 11 pages?