Excel solver example

# Excel solver example - Objective Allowable Allowable Cell...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 3/31/2011 12:40:10 PM Target Cell (Max) Cell Name Original Value Final Value \$B\$7 optimal solution value 0 570 Adjustable Cells Cell Name Original Value Final Value \$C\$6 optimal solution x1 0 30 \$D\$6 optimal solution x2 0 60 Constraints Cell Name Cell Value Formula Status Slack \$C\$14 constraint 1 LHS 450 \$C\$14<=\$D\$14 Binding 0 \$C\$15 constraint 2 LHS 630 \$C\$15<=\$D\$15 Binding 0 \$C\$16 constraint 3 LHS 60 \$C\$16<=\$D\$16 Not Binding 50 \$C\$6 optimal solution x1 30 \$C\$6>=0 Not Binding 30 \$D\$6 optimal solution x2 60 \$D\$6>=0 Not Binding 60

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: 3/31/2011 12:40:10 PM Adjustable Cells Final Reduced
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$C\$6 optimal solution x1 30 7 2 4 \$D\$6 optimal solution x2 60 6 8 1.33 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$C\$14 constraint 1 LHS 450 0.33 450 180 150 \$C\$15 constraint 2 LHS 630 0.67 630 150 180 \$C\$16 constraint 3 LHS 60 110 1.00E+030 50 Variables x1 x2 Profit/unit 7 6 optimal solution 30 60 optimal solution value 570 RHS Constraint 1 3 6 < 450 constraint 2 9 6 < 630 constraint 3 2 < 110 LHS RHS constraint 1 450 450 constraint 2 630 630 constraint 3 60 110...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

Excel solver example - Objective Allowable Allowable Cell...

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

View Full Document
Ask a homework question - tutors are online