columngeneration

# columngeneration - Increase Decrease \$H\$5 50 25 25...

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

Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 1/4/2012 09:34:40 Adjustable Cells Final Reduced Cell Name Value Gradient \$B\$3 x1 0 1 \$C\$3 x2 0 0.5 \$D\$3 x3 10 0 \$E\$3 x4 15 0 Constraints Final Lagrange Cell Name Value Multiplier \$H\$5 50 0 \$H\$6 20 0.5 \$H\$7 15 1

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 1/4/2012 09:41:28 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 x1 0 1 1 1.00E+030 1 \$C\$3 x2 0 0.5 1 1.00E+030 0.5 \$D\$3 x3 10 0 1 1 1 \$E\$3 x4 15 0 1 1.00E+030 1 \$F\$3 x5 0 0 0 1.00E+030 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$H\$5 50 0 25 25 1.00E+030 \$H\$6 20 0.5 20 1.00E+030 20 \$H\$7 15 1 15 1.00E+030 12.5
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 1/4/2012 09:42:09 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 x1 0 1 1 1.00E+030 1 \$C\$3 x2 0 0.5 1 1.00E+030 0.5 \$D\$3 x3 10 0 1 1 1 \$E\$3 x4 15 0 1 1.00E+030 1 \$F\$3 x5 0 0 0 1.00E+030 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Increase Decrease \$H\$5 50 25 25 1.00E+030 \$H\$6 20 0.5 20 1.00E+030 20 \$H\$7 15 1 15 1.00E+030 12.5 Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 1/4/2012 09:43:18 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 x1 1 1 1.00E+030 1 \$C\$3 x2 0 0.6666666666 1 1.00E+030 0.6666666666 \$D\$3 x3 0 0.3333333333 1 1.00E+030 0.3333333333 \$E\$3 x4 15 1 1.00E+030 1 \$F\$3 x5 6.666666667 1 0.5 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$H\$5 30 25 5 1.0000E+030 \$H\$6 20 0.3333333333 20 1.00E+030 20 \$H\$7 15 1 15 1.00E+030 2.5 x1 x2 x3 x4 x5 1 1 1 1 1 15 6.666667 21.66667 5 4 2 2 30 25 1 2 3 1 20 20 1 1 15 15 a1 a2 a3 0 -0.333333-1 1 1-1.333333 3 5 9 14 17...
View Full 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 / 5

columngeneration - Increase Decrease \$H\$5 50 25 25...

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

View Full Document
Ask a homework question - tutors are online