Question: A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these requires different

A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these requires different funding over the next two years, and the net present value of the investments also varies.

The following table provides the required investment amounts (in $1,000s) and the net present value (NPV) of each (also expressed in $1,000s):

The company has $80,000 to invest in year 1 and $50,000 to invest in year 2.
(a) Develop an integer programming model to maximize the NPV in this situation.
(b) Solve the problem in part (a) using computer software. Which of the three projects would be undertaken if NPV is maximized? How much money would be used each year?

INVESTMENT NPV YEAR YEAR 2 Apartment Shopping center Mini-warehouse 18 15 14 40 30 20 30 20 20

Step by Step Solution

★★★★★

3.39 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Let X 1 1 if apartment project is undertaken 0 otherwi... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

162-M-S-L-P (83).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

A real estate developer is planning a new mini apartment complex. Three types of units can be built: one-bedroom apartments, two-bedroom apartments, and three-bedroom apartments. Each one-bedroom...

A clothing store manager is considering three possible locations for a new branch. Following are important factors and factor scores that resulted from her analysis. Which location would you...

A real estate developer is considering investing in a shopping mall on the outskirts of Atlanta, Georgia. Three parcels of land are being evaluated. Of particular importance is the income in the area...

=10-17 A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these requires different funding over the next...

Scel 14.0 Sensitivity Report SP-22423. Good to Go Suitcase Company GRAMMING SENSITIVITY ANALYSIS sly. 1 hour of Surs of cul ectively se sunt packaging Cell Table Cells Final Reduced Objective...

4. A real estate developer is considering four possible projects: a small apartment complex, a small shopping center, a mini-warehouse, and a medium-size gas station. Each of these requires different...

\ What is the answer for the last letter d. ? A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these...

10-17 A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these requires different funding over the next...

A real estate developer is considering three possible projects: a small apartment complex, a small shopping center, and a mini-warehouse. Each of these requires different funding over the next two...

Define yield (internal rate of return). When is it appropriate to use yield rather than the HPR to measure the return on an investment?

Explain why an individual with a deficiency of pyruvate dehydrogenase phosphatase (PDP) is unable to tolerate exercise.

When evaluating the cash flows from an investment, a reduction in cash outflows is treated as the same as an increase in cash inflows. Question content area bottom Part 1 True False

31. Engines One measure of the size of an automobile engine is its displacement, the total volume (in liters or cubic inches) of its cylinders. Summary statistics for several models of new cars are...

How do the three types of integer programming problems differ? Which do you think is most common and why?

A marketing firm is developing a new Web-based media campaign for a client. The following table describes the relationships among the activities that need to be completed. (a) Develop a project...

The Laurenster Corporation is getting into the construction business. A list of activities and their optimistic, most likely, and pessimistic completion times are given in the following table for the...

Assume Gillette Corporation will pay an annual dividend of $0.64 one year from now. Analysts expect this dividend to grow at 12.1\% per year thereafter until the 5 th year. Thereafter, growth will...

After about 10 months of saving $500 a month, Mary has achieved her goal of saving $ 5,000 that she will use as a down payment on a new car. Marys new car is priced at $25,000 plus 8.75% sales tax....

FaceBook will deposit $130 every week to your retirement account. You plan to retire 30 years from now. The interest you can earn in this investment is 12 percent. How much is this investment worth...