There is a portfolio of 7 possible investments to choose from, the net present value (NPV), of
Question:
There is a portfolio of 7 possible investments to choose from, the net present value (NPV), of the profit of each of the possible investments as well as the capital that you have to invest per year if you decide to participate, is found in the table that it shows. All values are in millions. An example of the interpretation of the table is the following; For the third possible investment, if you decide to invest in it, you have a profit of $5 million. For this, you need to invest $4 million in year 0, $5 million in year 1, and $1 million in year 2. The budget to invest in year 0 is a minimum of $8 million, while for years 1 and 2 it is a maximum of $10 and $9 million, respectively. Projects 2 and 4 are mutually exclusive.
It should also be considered that project 1 cannot be done without project 4 is done. With the information provided, formulate a mixed integer programming model that maximizes the profits from the investments. Write the binary mathematical model that maximizes revenue.
(Use the following variables Xi = 1 yes I invest in a project i; 0 I do not invest in a project i where i = 1, 2, 3, 4, 5, 6, 7).
Quantitative Methods for Business
ISBN: 978-0840062345
12th edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam