An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
Based on this ILP formulation of the problem what formulas should go in cells E5:E12 of the following Excel spreadsheet?
MAX: 6 X1 + 12 X2 + 9 X3
Subject to: 50 X1 + 90 X2 + 100 X3 ? 500
X1 ? 10
X2 ? 5
X3 ? 7
Xi ? 0 and integer
Correct Answer:
Verified
\begin{array} { l l }...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q49: A company wants to build a new
Q52: A company wants to build a new
Q53: A company wants to build a new
Q55: A sub-problem in a B & B
Q55: A company needs to hire workers
Q56: A small town wants to build
Q57: A cellular phone company wants to
Q58: An investor has $500,000 to invest
Q59: A cellular phone company wants to
Q84: A company has four projects, numbered 1
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents