Based on Taylor and Keown (1984). Gotham City is trying to determine the type and location of recreational facilities to build during the next decade. Four types of facilities are under consideration: golf courses, swimming pools, gymnasiums, and tennis courts. Six sites are under consideration. If a golf course is built, it must be built at either site 1 or site 6. Other facilities can be built at sites 2 through 5. The amounts of available land (in thousands of square feet) at sites 2 through 5 are given in the file P16_13.xlsx. The cost of building each facility (in thousands of dollars), the annual maintenance cost (in thousands of dollars) for each facility, and the land (in thousands of square feet) required for each facility are also given in the same file. The number of user-days (in thousands) for each type of facility, also shown in this file, depends on where it is built.
a. Consider the following set of priorities:
■ Priority 1: The amount of land used at each site should be no greater than the amount of land available.
■ Priority 2: Construction costs should not exceed $1.2 million.
■ Priority 3: User-days should exceed 200,000.
■ Priority 4: Annual maintenance costs should not exceed $200,000. For this set of priorities, use goal programming to determine the type and location of recreation facilities in Gotham City.
b. Consider the following set of priorities:
■ Priority 1: The amount of land used at each site should be no greater than the amount of land available.
■ Priority 2: User-days should exceed 200,000.
■ Priority 3: Construction costs should not exceed $1.2 million.
■ Priority 4: Annual maintenance costs should not exceed $200,000.
For this set of priorities, use goal programming to determine the type and location of recreation facilities in Gotham City.