Formulate a Binary Integer Programming (BIP) model on a spreadsheet.
Formulate a Binary Integer Programming (BIP) model on a spreadsheet.
MGMT 430 Binary Integer Programming Assignment–Week 4–Dropbox 5
Consider a small Oil production firm with 6 competing oil production projects, A – F.
The table below shows the estimated long-term profit (Net Present Value) for each project as well as the amount of investment capital required to start the project.
You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million.
Production Projects
A
B
C
D
E
F
Estimated Profit ($million)
$26
$21
$18
$30
$28
$22
Capital required ($million)
$11
$8
$14
$19
$19
$13
1) Formulate a Binary Integer Programming (BIP) model on a spreadsheet.
2) Solver the model using Solver
LOOKING FOR THIS ASSIGNMENT OR A SIMILAR ONE? WE HAVE HAD A GOOD SUCCESS RATE ON THIS PAPER! ORDER WITH US TODAY FOR QUALITY WORK AND GET A DISCOUNT!
Disclaimer:
All types of paper that Discount Writers provides is only for the purpose of assistance! No text, paper, assignment, discussion would be similar with another student therefore guaranteeing Uniqueness and can be used with proper references only!
More tools: Better Grades: Choose your Homework Help:
Assignment Help: We would write your papers according to the instructions provided and guarantee you timely work
Entire Online Class Help: We are here for you and we would do your entire Class work from discussions, assignments, Replies, Exams and Quizzes at a Cost
Exam/ Quiz Help: We have a team of writers who specialize on exams from any specific field and we would give you an A+ Grade!
