Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Problem 6 A typical large oil and gas company operates many explorations and production projects, which involve several billion dollars every year. These companies are
Problem A typical large oil and gas company operates many explorations and production projects, which involve several billion dollars every year. These companies are annually faced with the problem of where the capital should be spent and which combination of projects should be selected from several possible project mixes. They have the difficult task of portfolio selection from a large number of competing projects for immediate or future operation under a limited amount of investments. Consider a small firm with competing oil production projects. Table presents the production, capital, and the net present value for these projects. They contact you to help select the best combination of projects under a certain amount of investment, while fulfilling the firms goals. a Formulate an integer program to maximize the net present value NPV subject to a capital limit stating the firm can spend no more than $ million M$ and a production level stating the firm must produce at least million barrels Mbbl b Suppose that there are the following additional constraints: i If Project A is selected, then Project B is also selected; ii Either Project A is selected or Project C selected, but not both; iii At least one of Projects A B and D is selected. Extend your integer program to satisfy theses constraints. Table : Portfolio optimization problem Data Project NPV M$ Capital M$ Production Mbbl A B C D Table : Budget limitation and production level over the next years Year Budget M$ Production Mbbl c Now assume that the selection must satisfy the production level required production output as well as the budget limit over each of the next years as indicated in Table The production output and capital required for each project during the next years are given in Table Write an integer program to determine the most profitable selection. Table : Portfolio optimization problem data over the next years Project first year second year third year Capital M$ A B C D Production Mbbl A B C D please solve by excel solver ASAP
Problem
A typical large oil and gas company operates many explorations and production projects, which involve several billion dollars every year. These companies are annually faced with the problem of where the capital should be spent and which combination of projects should be selected from several possible project mixes. They have the difficult task of portfolio selection from a large number of competing projects for immediate or future operation under a limited amount of investments.
Consider a small firm with competing oil production projects. Table presents the production, capital, and the net present value for these projects. They contact you to help select the best combination of projects under a certain amount of investment, while fulfilling the firms goals.
a Formulate an integer program to maximize the net present value NPV subject to a capital limit stating the firm can spend no more than $ million M$ and a production level stating the firm must produce at least million barrels Mbbl
b Suppose that there are the following additional constraints:
i If Project A is selected, then Project B is also selected;
ii Either Project A is selected or Project C selected, but not both; iii At least one of Projects A B and D is selected.
Extend your integer program to satisfy theses constraints. Table : Portfolio optimization problem Data
Project NPV M$ Capital M$ Production Mbbl
A B C D
Table : Budget limitation and production level over the next years
Year Budget M$ Production Mbbl
c Now assume that the selection must satisfy the production level required production output as well as the budget limit over each of the next years as indicated in Table The production output and capital required for each project during the next years are given in Table Write an integer program to determine the most profitable selection.
Table : Portfolio optimization problem data over the next years
Project first year second year third year
Capital M$
A B C D
Production Mbbl
A B C D please solve by excel solver ASAP
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started