Answer 3a and 3b.

Problem 3: Union Bank 1 2 3 4 Microsoft Excel 16.0 Sensitivity Report Worksheet: [EXAM 1 excel.xisx]Union Bank Report Created: 6/25/2017 10:15:01 PM Engine: Standard LP/Quadratic Cell 3-a. How will raising the investment of car loans to Cell Name Final Value 8 SC$9 Total $ Return 66.625 its allowable increase affect the objection function total? 0 Decision Variable Cells 2 Cell 13 SDS5 Bonds Amnt Invested in $1000s 4 SDS6 Mortgages Amnt Invested in $1000s 5 SD$7 Car Loans Amnt Invested in $1000s 6 SD58 Personal Loans Amnt Invested in $1000s Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase rase3-b. If personal loans constraint were loosened, 325.000 0.000 162.500 0.000 Name 0.1 0.00500005 0.0050001 0.085 0.0150001 0.0100001 1E+30 E430 0.0100001 how will the current solution be affected? 0.000 -0.005 0.095 0.005 Analyze and Explain 162.500 0.000 0.125 8 Constraints Final Shadow Constraint Allowable Allowable Value Price Cell SFSS Bonds Personal Loans Name R.H. Side ncreaseDecrease 2 $FS8 Personal Loans Personal Loans 3 SF$11 Personal Loans 4 SDS9 Total $ Amnt Invested in $1000s 162.500 0000 162.5 0.015 0.01 650.00 0.10 E+30 162.5 162.5 54.16666667 E 30 162.5 162.5 162.5 650