Q. Lauren Moore has sold her business for $720,000 also wants to invest in condominium units (which she intends to rent) also land (which she will lease to a farmer). She estimates that she will receive an annual return of $8000 for each condo also $6000 for each acre of land. A condo cost $65000 also land is $28000 every acre. A condo will cost her $2000 every unit, an acre of land will cost $1500 for maintenance also upkeep also $14000 has been budgeted for these annual expenses. There are a total of 8 condos also 10 acres of land available for purchase. Lauren wants to know Elucidate how much to invest in condos also 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.