Binary Integer ProgrammingAssignmentWeek 4Dropbox 5 Consider a small Oil product

Binary Integer ProgrammingAssignmentWeek 4Dropbox 5
Consider a small Oil production firm with 6competing oil production projects, A – F.
Thetable below shows the estimated long-term profit (Net Present Value) for eachproject as well as the amount of investment capital required to start theproject.
Youhave been contacted to help select the best combination of projects to maximizethe 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 IntegerProgramming (BIP) model on a spreadsheet.
2)     Solver the model usingSolver.

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *