Question: I need immediate help with this problem. Thanks A real estate developer is considering four possible projects: a small apartment complex, a large apartment complex,

I need immediate help with this problem.

Thanks

I need immediate help with this problem. Thanks A

A real estate developer is considering four possible projects: a small apartment complex, a large apartment complex, a shopping center, and a warehouse. Each of these requires different funding over the next 2 years, and the net present values of the investments also vary. The following table provides the required investment amounts (in $1,000s) and the net present value (NPV) of each (also expressed in $1,000s): 23 Parameters NPV Requirement year 1 Requirement year 2 Small Apartment Large Apartment | Shopping Center | Warehouse 19 30 24 27 40 26 33 48 40 37 25 34 The company has $100,000 to invest in year 1 and $80,000 to invest in year 2. The developer wants to determine which of these projects to implement while meeting the requirements and maximize the net present value of the undertaken projects. (a) Define your decision variables. (0.25 points). (b) Write the mathematical model that can be used to solve this problem (must provide the objective function and constraints mathematically). Note that simply providing the Excel solver input will not earn any credit. (1 point) (c) Solve the problem using Excel Solver. Make sure that I can see the Excel Solver input for each question. Otherwise, you will not earn any credit. (0.75 points). (d) Write down a constraint enforcing that at least two projects must be undertaken. (0.2 points). (e) Write down a constraint enforcing that if the large apartment project is undertaken, then the shopping center project must be undertaken, as well. (0.2 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!