Integer Programming
Not what you're looking for?
Roblem 11-19: 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):
Investment
NPV Year 1 Year 2
Apartment 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?
Hint(use 0/1 integer).
Purchase this Solution
Solution Summary
Develops an integer programming model to maximize NPV for a real estate developer. Excel Solver is used to calculate the values.
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Lean your Process
This quiz will help you understand the basic concepts of Lean.