{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Loan example for lab practice (1)

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

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

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

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

View Full Document
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
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 <= 80,000 constr. 2 66,666.67 <= 90,000 constr. 3 0.00 >= constr. 4 100,000.00 >= 100,000...
View Full Document

{[ snackBarMessage ]}