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
Background image
e Without Integer Constraints , Assume NonNegative
Background image
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
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 11 pages?

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture