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 values of the investments also vary.

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

INVESTMENT

NPV YEAR 1 YEAR 2

Apartment complex 18 40 30

Shopping center 15 30 20

Mini - warehouse 14 20 20

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?

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 Mathematics Questions!

Area, Perimeter, and Circumference 1. A circle has a radius of 3 inches. A) What is the diameter? B) What is the area of the circle? C) What is the circumference of the circle? 2. A circle has a...

Assignment Questions Excel data entry and modeling is not introduced at this late stage of the course, so some of these questions involve only simple calculations and interpretation of Excel...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

How are the square numbers embedded in Pascals triangle?

When report cards are noisy, high quality sellers can sometimes receive low rankings. Sellers complain that this is unfair. But is it necessarily bad for the consumer?

The table lists different amounts (metric tons) of the explosive TNT and the corresponding value measured on the Richter scale resulting from explosions of the TNT. Construct a scatterplot and...

Who dropped out during the research? Were they different from those who completed the study?

Ronald Naquin, an employee of Air Engineered Systems & Services, Inc., owned one-third of its outstanding shares. After six years, he was fired and an offer was made to buy out his interest in Air...

13. The figure below is a partition curve for a heavy media cyclone processing coal. a) What is the d50 or separating gravity? b) What is the probable error or Ep? c) What is the normalized probable...

draw it's journal general 3.6A Enter the following transactions in the accounts: May 1 Started in business with f18,000 in the bank. " 2 Bought goods on credit from B Hind f1,455. ". 3 Bought goods...

Repeat Problem 92 for a diverging mirror. Comment on any similarities or differences with the two types of mirrors. Data from Problem 92 A converging mirror has a focal length of \(300...

A compound microscope consists of two converging lenses, the objective lens and the eyepiece lens, positioned on a common optical axis (Figure 33.47). The objective lens is positioned to form a real,...

An object that has a small aperture is placed between a light source and a screen, as shown in Figure 33.4. Which parts of the screen are in the shadow? Data from Figure 33.4 object screen (edge on)...

Two balls of identical size (ball 1 made up of nylon and ball 2 made up of rubber) were rubbed against each other so that they carry a uniformly distributed charge of magnitude $0.25 \mathrm{nC}$....

PH Ltd. furnishes the following information relating to budgeted sales and actual sales for April. Calculate the following variances: (1) Sales quantity variance, (2) Sales mix variance, (3) Sales...

Almost immediately after a server migration project, employees are complaining that they can't reach the Internet. You sit down at a machine and try to ping a well - known website using the host...

1. Firms may hold financial assets to earn returns. How the firm would classify financial assets? What treatment will such financial assets get in the financial statements in accordance with US GAAP...

Explain how profitability is measured in the property and casualty insurance industry.

Explain the following methods of merit rating: a. schedule rating b. experience rating

Based on the following information, determine the policyholders' surplus for XYZ Insurance Company: Total invested assets Loss reserves Total liabilities Bonds $50,000,000 40,000,000 70,000,000...