Lotus Point Condo Project will include both homes

and flats. Site can host up to $15,000$

Housing units. The project must include a recreation project:

either a swimming$-$tennis complex or a sailing marina, but

not both. Number of houses if a marina is built

The project must be at least three times the number of flats

In the project. A marina will cost $$1\mathrm{.}5$ million

The swimming$-$tennis complex will cost $$3\mathrm{.}0$ million.

developers believe that each apartment will bring income

Its NPV will be $$45,000$ and each home will generate income

Its NPV is $$40,000.$ Cost of each house $($or apartment$)$

Construction cost $$30,000.$ Formulate an IP that will help Lotus Point

maximizing profit and use EXCEL SOLVER to solve your IP$.$