Optimization Modeling questions

Homework Set #4 Due March , 2017 CSE 273 (15) Problem #1 Formulate the following problem using the following steps a. Define the decision variables. b. Specify the objective function. c. Specify the constraints and simplify them so that the left hand side of each constraint only contains terms involving the decision variables. A trust officer at the Blackburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return . The information is given in the following table: Annual Return (%) Bond RiskTax Free Maturity Long Short Long Long Short High Low Low High High Yes Yes No Yes No 8.0 9.0 The officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high risk issues. At least 30% of the funds should go in tax-free investments and at least 40% of the total return should be tax free. Extra Credit (10 Points) Solve Problem #1 using Excel's Solver