xlsxProb 2 Report Created 1172011 95729 PM Engine Gurobi Solver Objective Cell

Xlsxprob 2 report created 1172011 95729 pm engine

This preview shows page 3 - 5 out of 5 pages.

Worksheet: [Chapter 4 My Extra problems - spreadsheets with sensitivity reports.xlsx]Prob 2Report Created: 11/7/2011 9:57:29 PMEngine: Gurobi SolverObjective Cell (Max)CellNameFinal Value$B$20Total Profit: Mixed fruit180Decision Variable CellsFinal Reduced ObjectiveAllowableCellNameValueCostCoefficientIncrease$B$18Lots produced: Mixed fruit0-8108$C$18Lots produced: Fruit cocktail0-363$D$18Lots produced: Fruit delight20091.00E+100ConstraintsFinalShadowConstraintAllowableCellNameValuePriceR.H. SideIncrease$B$23Pears, lb Amount Used (LHS)32003401.00E+100$B$24Peaches, lb Amount Used (LHS)32004001.00E+100$B$25Mixing, hr Amount Used (LHS)400431.00E+100$B$26Canning, hr Amount Used (LHS)200601.00E+100$B$27Packaging, hr Amount Used (LHS)209201.25
Background image
AllowableDecrease1.00E+1001.00E+1003AllowableDecrease208034020
Background image
Sunshine Food Processing CompanyDecision Variables$ Profit$10.00$6.00$9.00Used Per Unit ProducedR-H-SPears, lb201016£340Peaches, lb102016£400Mixing, hr122£43Canning, hr111£60Packaging, hr211£20ModelDecision VariablesLots produced:0020Total Profit: $ 180.00 ConstraintsPears, lb320£340Peaches, lb320£400Mixing, hr40£43Canning, hr20£60Packaging, hr20£20Mixed fruitFruit cocktailFruit delightMixed fruitFruit cocktailFruit delightAmount Used (LHS)Amount Available (RHS)
Background image

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '08
  • STAFF
  • Peaches, LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture