LPmodels - Microsoft Excel 14.0 Answer Report Worksheet:...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Answer Report Worksheet: [Workbook1]Sheet1 Report Created: 12/10/2011 5:28:00 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.636929 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06, Use Automatic Scaling Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $F$2 0 6650 Variable Cells Cell Name Original Value Final Value Integer $B$2 0 0 Contin $C$2 0 400 Contin $D$2 0 150 Contin $E$2 0 400 Contin Constraints Cell Name Cell Value Formula Status Slack $F$6 950 $F$6=$G$6 Binding 0 $F$7 400 $F$7>=$G$7 Binding 0 $F$8 4600 $F$8<=$G$8 Binding 0 $F$9 4750 $F$9<=$G$9 Not Binding 250 $B$2 0 $B$2>=0 Binding 0 $C$2 400 $C$2>=0 Not Binding 400 $D$2 150 $D$2>=0 Not Binding 150 $E$2 400 $E$2>=0 Not Binding 400
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Workbook1]Sheet1 Report Created: 12/10/2011 5:28:00 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 0 -1 4 1 1.00E+030 $C$2 400 0 6 0.6666666667 0.5 $D$2 150 0 7 1 0.5 $E$2 400 0 8 2 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$6 950 3 950 50 100 $F$7 400 -2 400 37.5 125 $F$8 4600 1 4600 250 150 $F$9 4750 0 5000 1.0000E+030 250
Background image of page 2
Microsoft Excel 14.0 Limits Report Worksheet: [Workbook1]Sheet1 Report Created: 12/10/2011 5:28:00 PM Objective Cell Name Value $F$2 6650 Variable Lower Objective Upper Objective Cell Name Value Limit Result Limit Result $B$2 0 0 6650 0 6650 $C$2 400 400 6650 400 6650 $D$2 150 150 6650 150 6650 $E$2 400 400 6650 400 6650
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 14.0 Answer Report Worksheet: [Workbook1]problem1 Report Created: 12/10/2011 5:46:03 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.500782 Seconds. Iterations:
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/09/2012 for the course IE 521 taught by Professor Zelihaakça during the Fall '11 term at Fatih Üniversitesi.

Page1 / 16

LPmodels - Microsoft Excel 14.0 Answer Report Worksheet:...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online