Each variable and solution must be clearly indicated on the excel worksheet, do not just solve the question, clearly define each variable and comment on the objective function and sensitivity analysis (explain each resulting sensitivity analysis page). Sensitivity analysis pages without your comments will not be graded.

4. Piri Reis Yap naat owns 800 acres of undeveloped land on a scenic lake in the heart of the Ozark Mountains. In the past, little or no regulation was imposed upon new developments around the lake. The lake shores are now dotted with vacation homes, and septic tanks, most of them improperly installed, are in extensive use. Over the years, seepage from the septic tanks led to severe water pollution. To curb further degradation of the lake, county officials have approved stringent ordinances applicable to all future developments: (1) Only single-, double-, and triple-family homes can be constructed, with single-family homes accounting for at least 50% of the total. (2) To limit the number of septic tanks, minimum lot sizes of 2,3 , and 4 acres are required for single-, double-, and triple-family homes, respectively. (3) Recreation areas of 1 acre each must be established at the rate of one area per 200 families. (4) To preserve the ecology of the lake, underground water may not be pumped out for house or garden use. The president of Piri Reis Yap naat is studying the possibility of developing the 800-acre property. The new development will include single, double, and triple-family homes. It is estimated that 15% of the acreage will be allocated to streets and utility easements. Piri Reis Yap naat estimates the returns from the different housing units as follows: The cost of connecting water service to the area is proportionate to the number of units constructed. However, the county charges a minimum of $100,000 for the project. Additionally, the expansion of the water system beyond its present capacity is limited to 200,000 gallons per day during peak periods. The following data summarize the water service connection cost as well as the water consumption, assuming an average size family