Purchase Solution

Mixed Integer problem:Formulation and solution

Not what you're looking for?

Ask Custom Question

Lauren Moore has sold her business for $500,000 and wants to invest in condominium units ( which she intends to rent) and land ( which she will lease to a farmer). She estimates that she will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land is $30,000 per acre. A condominium will cost her $1,000 per unit, an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return.

A. Formulate a mixed integer programming model for this problem.

B. Solve this model using the computer.

Purchase this Solution

Solution Summary

This posting contains solution to following mixed integer programming problem using excel solver.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.