LPmodels

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

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

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

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

View Full Document
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
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

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

View Full Document
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:
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
Ask a homework question - tutors are online