Loan example for lab practice (1)

Loan example for lab practice (1) - 0.08 0.12 0.18...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Loan example for lab practice.xls]Sheet1 Target Cell (Min) Cell Name Original Value Final Value $B$13 Obj. value 0 12000 Adjustable Cells Cell Name Original Value Final Value $C$12 x1 0 33333.33 $D$12 x2 0 66666.67 Constraints Cell Name Cell Value Formula Status Slack $C$15 constr. 1 LHS 33333.33 $C$15<=$E$15 Not Binding 46666.67 $C$16 constr. 2 LHS 66666.67 $C$16<=$E$16 Not Binding 23333.33 $C$17 constr. 3 LHS 0 $C$17>=$E$17 Binding 0 $C$18 constr. 4 LHS 100000 $C$18>=$E$18 Binding 0
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 9.0 Sensitivity Report Worksheet: [Loan example for lab practice.xls]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$12 x1 33333.33 0 0.2 1.00E+030 0.12 $D$12 x2 66666.67
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: 0.08 0.12 0.18 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$15 constr. 1 LHS 33333.33 80000 1.00E+030 46666.67 $C$16 constr. 2 LHS 66666.67 90000 1.00E+030 23333.33 $C$17 constr. 3 LHS 0.04 140000 70000 $C$18 constr. 4 LHS 100000 0.12 100000 35000 100000 Loan Example DATA x1 x2 RHS constr. 1 1 80,000 constr. 2 1 90,000 constr. 3 2-1 constr. 4 1 1 100,000 obj. func. 0.2 0.08 MODEL Dec. var. x1 x2 33,333.33 66,666.67 Obj. value 12,000.00 LHS RHS constr. 1 33,333.33 &lt;= 80,000 constr. 2 66,666.67 &lt;= 90,000 constr. 3 0.00 &gt;= constr. 4 100,000.00 &gt;= 100,000...
View Full Document

This note was uploaded on 09/11/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Page1 / 3

Loan example for lab practice (1) - 0.08 0.12 0.18...

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