Excel mixed integer programming
Not what you're looking for?
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 farmer). she estimates that she will receive an annual return of $8000 for each condominium and $6000 for each acre of land. a condominium unit costs $70,000 and land costs $30,000 per acre. a condominium will cost her $1000 per unit and acre of land will cost $2000 for maintenance and upkeep and $14000 has been budgeted for these annual expense. 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 unit model by using the computer.
Purchase this Solution
Solution Summary
Excel mixed integer programming is formulated for investing in condominiums and land to maximize annual returns.
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.