Answered step by step
Verified Expert Solution
Question
1 Approved Answer
+ A recent MBA graduate, Dara, has gained control over custodial accounts that her parents had established for her. Currently, her money is invested in
+ A recent MBA graduate, Dara, has gained control over custodial accounts that her parents had established for her. Currently, her money is invested in four funds, but she has identified several other funds as options for investment. She has $99,700 to invest with certain restrictions. A linear optimization model to maximize the net retum was created and the Solver Sensitivity Report of the model is provided. Use the Solver Sensitivity Report to make recommendations that Dara might consider for her portfolio. Click the icon view the Solver Sensitivity Analysis Interpret the value of the Shadow Price for Total Amount Invested. Select the correct choice below and fill in the answer box to complete your choice. (Type integers or decimals rounded to the nearest cent as needed.) A Dara should invest up to $13,000 more because the retum will increase by $268.20 for each additional $1000 invested. Dara should decrease the total amount invested by up to $ because the return will decrease by $ for each $1000 invested Interpret the value of the Shadow Price for Cument Holdings Amount Invested. Select the correct choice below and fill in the answer box to complete your choice. (Type integers or decimals rounded to the nearest cent as needed.) A Dara should decrease the current holdings amount invested by up to $13,000 because the return will increase by $ 65.40 for each $1000 that the current holding amount invested lowered Dara should increase the current holdings amount invested by up to $ raised more because the retum will increase by $ for each additional $1000 that the current holding amount investe Solver Sensitivity Analysis A B C 35 Dara's Investments Sensitivity Report 36 37 Variable Cells 38 Final Reduced Objective Allowable Allowable 39 Cell Name Value Cost Coefficient Increase Decrease 40 $B$17 41 $B$18 1 Large cap blend Amount Invested 2 Small cap growth Amount Invested 0 -0.0359 0.1625 0.0355 1E+30 14800 0 0.1992 0.0575 0.0357 42 $B$19 3 Green fund Amount Invested 20000 0.0581 0.2539 1E+30 0.0576 43 $B$20 4 Growth & income Amount Invested 0 -0.0521 0.1462 0.0516 1E+30 44 $B$21 5 Multi-cap growth Amount Invested 0 -0.0801 0.1896 0.0804 1E+30 45 $B$22 6 Mid-cap index Amount Invested 0 -0.0506 0.2197 0.0507 1E+30 46 $B$23 7 Multi-cap core Amount Invested 6300 0 0.2709 0.0755 0.0504 47 $B$24 8 Small cap international Amount Invested 19600 0.0749 0.3447 1E+30 0.0758 48 $B$25 49 $B$26 50 $B$27 9 Emerging international Amount Invested 10 Money market fund Amount Invested 11 Savings account Amount Invested 19800 0.0804 0.3507 1E+30 0.0805 14200 -0.2218 0.0486 0.2238 1E+30 5300 -0.2571 0.0104 0.2615 1E+30 511 52 Constraints 53 Final 54 Cell Name: Value Shadow Price Constraint Allowable Allowable R.H. Side Increase Decrease 55 $E$15 Total Amount Invested 100000 0.2539 100000 13500 6000 56 $E$16 Total International Amount Invested 39400 0 16000 23400 1E+30 57 SE$17 Current Holdings Amount Invested 34800 -0.0668 34800 5400 13500 58 $E$18 New Investments Amount Invested 65200 0 30000 34800 1E+30 more help Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started