Consider the following potential projects that you can select. Your budget for n

Question

Consider the following potential projects that you can select. Your budget for new projects is only $2,000,000 (i.e. total investment requirements for the selected projects should be less than equal to this budget level) and you have 50 staff in your team. Which projects would you select to maximize your total profit?

Which projects would you select to maximize your total profit? What is the resulting total profit?

(Profit = Revenue – Required Investment and is given to you for your convenience.)

PLEASE SLOVE in excel and send excel document to pdxsneakerhead@gmail.com

Explanation / Answer

Solving the problem using the solver:

Invest in projects - B ,D,F,G,H to maximize the profits.

Decision Varibles Xa Xb Xc Xd Xe Xf Xg Xh Xi Project ID A B C D E F G H I Changing Cells (CC) 0 1 0 1 0 1 1 1 0 Min Investments Req 140 280 520 430 140 500 290 430 350 Profit 240 550 570 450 150 790 430 680 420 Staff Requirments 4 12 8 9 3 10 7 12 7 Constraints LHS RHS Investment in A 0 <= 140 Investment in B 280 <= 280 Investment in C 0 <= 520 Investment in D 430 <= 430 Investment in E 0 <= 140 Investment in F 500 <= 500 Investment in G 290 <= 290 Investment in H 430 <= 430 Investment in I 0 <= 350 Total Investments 1930 <= 2000 Xa,Xb,Xc,Xd,Xe,Xf,Xg,Xh,Xi = 1/0 Staff Requirments 50 <= 50 Obj.Function - Profit ($000) 2900

Invest in projects - B ,D,F,G,H to maximize the profits.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---