Lauren Moore has sold her business for $720,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 $8000 for each condo and $6000 for each acre of land. A condo cost $65000 and land is $28000 per acre. A condo will cost her $2000 per unit, an acre of land will cost $1500 for maintenance and upkeep and $14000 has been budgeted for these annual expenses. There are a total of 8 condos and 10 acres of land available for purchase. Lauren wants to know how much to invest in condos and land to maximize her return.
a) Identify the type of integer programming modeling framework that will be appropriate for this problem.
b) Solve it using Excel.