The amounts of available land (in thousands of square feet) at sites 2 through 5 are given
Question:
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.
Step by Step Answer:
Practical Management Science
ISBN: 9781111531317
4th Edition
Authors: Wayne L. Winston, S. Christian Albright