InClassCase2 - PeopleInvestNew

InClassCase2 - PeopleInvestNew - Microsoft Excel 10.0...

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

View Full Document Right Arrow Icon
Microsoft Excel 10.0 Answer Report Worksheet: [PeopleInvestNew.xls]PeopleInvest Model (with To (2) Report Created: 2/4/2004 12:08:45 PM Target Cell (Max) Cell Name Original Value Final Value $L$6 Objective Function: Total Return 0 61512.73 Adjustable Cells Cell Name Original Value Final Value $B$4 EZ 0 0 $C$4 EG 0 80000 $D$4 E/RF 0 60933.33 $E$4 DW 0 80000 $F$4 DZ 0 0 $G$4 DS 0 10000 $H$4 RG 0 80000 $I$4 MT 0 73066.67 $J$4 MM 0 1000 $K$4 MA 0 15000 Constraints Cell Name Cell Value Formula Status Slack $L$10 (1) Total Invest LHS 400000 $L$10<=$N$10 Binding 0 $L$11 (2) Avg. liquidity factor LHS 28428666.67 $L$11>=$N$11 Not Binding 2428666.67 $L$12 (3) Avg. risk LHS 16000000 $L$12<=$N$12 Binding 0 $L$13 (4) Equity category LHS 140933.33 $L$13<=$N$13 Not Binding 19066.67 $L$14 (5) Debt cateogry LHS 90000 $L$14<=$N$14 Not Binding 70000 $L$15 (6) RE category LHS 140933.33 $L$15<=$N$15 Not Binding 19066.67 $L$16 (7) MM cateory LHS 89066.67 $L$16<=$N$16 Not Binding 70933.33 $L$17 (8) Total Debt LHS 90000 $L$17<=$N$17 Binding 0 $L$18 (9) EZ LHS 0 $L$18<=$N$18 Not Binding 80000 $L$19 (10) EG LHS 80000 $L$19<=$N$19 Binding 0 $L$20 (11) E/RF LHS 60933.33 $L$20<=$N$20 Not Binding 19066.67 $L$21 (12) DW LHS 80000 $L$21<=$N$21 Binding 0 $L$22 (13) DZ LHS 0 $L$22<=$N$22 Not Binding 80000 $L$23 (14) DS LHS 10000 $L$23<=$N$23 Not Binding 70000 $L$24 (15) RG LHS 80000 $L$24<=$N$24 Binding 0 $L$25 (16) MT LHS 73066.67 $L$25<=$N$25 Not Binding 6933.33 $L$26 (17) MA LHS 15000 $L$26<=$N$26 Not Binding 65000 0 $L$27<=$N$27 Not Binding 60000 $L$28 (19) MM LHS 1000 $L$28>=$N$28 Binding 0 $L$29 (20) MA LHS 15000 $L$29<=$N$29 Binding 0 $L$30 (21) MT LHS 73066.67 $L$30>=$N$30 Not Binding 63066.67
Background image of page 1

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

View Full DocumentRight Arrow Icon
Worksheet: [PeopleInvestNew.xls]PeopleInvest Model (with To (2) Report Created: 2/4/2004 12:08:45 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$4 EZ 0 -0.01 0.15 0.01 $C$4 EG 80000 0 0.17 1.00E+030 $D$4 E/RF 60933.33 0 0.18 0 $E$4 DW 80000 0 0.12 1.00E+030 $F$4 DZ 0 -0.01 0.12 0.01 $G$4 DS 10000 0 0.12 0 $H$4 RG 80000 0 0.22 1.00E+030 $I$4 MT 73066.67 0 0.1 0 $J$4 MM 1000 0 0.11 0 $K$4 MA 15000 0 0.13 1.00E+030 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $L$10 (1) Total Invest LHS 400000 0.15 400000 38235.29 $L$11 (2) Avg. liquidity factor LHS 28428666.67 0 0 2428666.67 $L$12 (3) Avg. risk LHS 16000000 0 0 1430000 $L$13 (4) Equity category LHS 140933.33 0 0 1.00E+030 $L$14 (5) Debt cateogry LHS 90000 0 0 1.00E+030 $L$15 (6) RE category LHS 140933.33 0 0 1.00E+030 $L$16 (7) MM cateory LHS 89066.67 0 0 1.00E+030 $L$17 (8) Total Debt LHS 90000 0 0 70000 $L$18 (9) EZ LHS 0 0 0 1.00E+030 $L$19 (10) EG LHS 80000 0 0 65285.71 $L$20 (11) E/RF LHS 60933.33 0 0 1.00E+030 $L$21 (12) DW LHS 80000 0 0 10000 $L$22 (13) DZ LHS 0 0 0 1.00E+030 $L$23 (14) DS LHS 10000 0 0 1.00E+030 $L$24 (15) RG LHS 80000 0.07 0 26021.43 $L$25 (16) MT LHS 73066.67 0 0 1.00E+030 $L$26 (17) MA LHS 15000 0 0 1.00E+030 $L$27 (18) Zizzle S&B LHS 0 0 0 1.00E+030 $L$28 (19) MM LHS 1000 0 1000 72769.23 $L$29 (20) MA LHS
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/15/2011 for the course OSCM 230 taught by Professor Dong during the Spring '08 term at Washington University in St. Louis.

Page1 / 20

InClassCase2 - PeopleInvestNew - Microsoft Excel 10.0...

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