Excel solver example - Objective Allowable Allowable Cell...

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

View Full Document Right Arrow Icon
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
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 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 3/31/2011 12:40:10 PM Adjustable Cells Final Reduced
Background image of page 2
Background image of page 3
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 &lt; 450 constraint 2 9 6 &lt; 630 constraint 3 2 &lt; 110 LHS RHS constraint 1 450 450 constraint 2 630 630 constraint 3 60 110...
View Full Document

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 Right Arrow Icon
Ask a homework question - tutors are online