Question: The question is in the first image , however my answer is wrong, can you show me what I should enter in excel solver, I

The question is in the first image , however my answer is wrong, can you show me what I should enter in excel solver, I believe the answer should be around 111562.5000
Question. Mackenzie Investments is deciding on future investment for the coming two years and is considering four bonds. The investment details for the next two years are given in the table below. Invactmont Danuiramante (\$) The net worth of these four bonds at maturity is $60,000,$40,000,$25,500, and $18,000, respectively. The firm plans to invest at most $40,000 and $65,000 in Year 1 and Year 2, respectively. In years 1 and 2, the firm can invest on different bonds. In order to invest on Bond B, the firm has to invest on Bond C. 1. Using Excel solver, develop and solve a binary integer programming model for maximizing the return on investment (in dollars). Which bonds should be invested in years 1 and 2? How much money is invested? What is the return on investment (in dollars)? Make Unconstrained Variables Non-Negative Select a Solving Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
