Seven cities are being considered as potential locations for the construction of at most four wastewater treatment plants. The table below provides the data for the situation. Missing entries indicate that a pipeline cannot be constructed
The capacity of a pipeline (in gallons per hour) is a direct function of the amount of wastewater generated, which is a function of the population. Approximately 500 gallons per 1000 residents are discharged in the sewer system per hour. The maximum plant capacity is 100,000 gal/hour. Further, we impose the requirement that all wastewater produced in any given city is treated in a single wastewater treatment plant 1. Write a mathematical program to determine the set of treatment plants that minimize total cost 2. Solve this problem with Excel
