he council wants toconstruct the facilities that will maximize expected daily usage bythe residents of the community subject to land and costllimitations. The usage, cost, and land data for each facility arelisted below. The community has $240,000 construction budget and 24arces of land. Because the swimming pool and tennis center must bebuilt on the same part ot the land parcel, however, only one ofthese two facilities can be constructed. Formulate an optimizationmode to assist the council in making its decision. Q1)Write out anyconstraints necessary for this problem in terms of the decisionvariables defined above. Q2) A very inluential citizens group hasmade it clear that it strongly prefers the athletic fielld to thegynnasim; thus the council will not approve the gymnasium unlessthe athletic field is also approved. How can the model be modifiedto incorporate this condition? Q3) The mayor has deicded that nomore than three of the facilities may be constructed wiht fundsfrom this year's budget. How can the model be modified toincorporate this comdition? Please use Solver(EXCEL) to define Q2and Q3
| expected usage | | |
| facility | people/day | cost($) | Land requirements (acres) |
| swimming pool | 600 | 70,000 | 8 |
| tennis center | 180 | 20,000 | 4 |
| athletic field | 800 | 50,000 | 14 |
| gymnassium | 300 | 180,000 | 6 |
