bus 220 hw1 - Microsoft Excel 14.4 Answer Report Worksheet[bus 220 hw]Sheet1 Report Created 2:31:52 PM Result Solver found a solution All constraints

# bus 220 hw1 - Microsoft Excel 14.4 Answer Report...

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

Microsoft Excel 14.4 Answer ReportWorksheet: [bus 220 hw.xlsx]Sheet1Report Created: 2/18/2016 2:31:52 PMResult: Solver found a solution. All constraints and optimality conditions are satisfied.Solver Engine Engine: Simplex LP Solution Time: 0.705116 Seconds. Iterations: 0 Subproblems: 0Solver Options Max Time Unlimited , Iterations Unlimited , Precision 0.000001Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, SolveObjective Cell (Max)CellNameOriginal ValueFinal Value\$B\$13obje. Value(z)00Variable Cells CellNameOriginal ValueFinal ValueInteger \$C\$12Dec. var. x100 Contin \$D\$12Dec. var. x200 Contin ConstraintsCellNameCell ValueFormulaStatusSlack\$C\$15const1 LHS0 \$C\$15<=\$E\$15Not Binding8960\$C\$16const2 LHS0 \$C\$16<=\$E\$16Not Binding4160\$C\$17const3 LHS0 \$C\$17<=\$E\$17Not Binding3200
e Without Integer Constraints , Assume NonNegative
Microsoft Excel 14.4 Sensitivity ReportWorksheet: [bus 220 hw.xlsx]Sheet1Report Created: 2/18/2016 2:31:52 PMVariable Cells FinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease\$C\$12Dec. var. x10000 1.00E+030\$D\$12Dec. var. x20000 1.00E+030ConstraintsFinalShadowConstraintAllowableAllowableCellName

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

Want to read all 11 pages?

• Spring '08
• drexel
• LHS, Dec. Var