Because of excessive pollution on the Momiss River, the state of Momiss is going to build some pollution control stations. Three sites (1, 2, and 3) are under consideration. Momiss is interested in controlling the pollution levels of two pollutants (1 and 2). The state legislature requires that at least 80,000 tons of pollutant 1 and at least 50,000 tons of pollutant 2 be removed from the river. The relevant data for this problem are shown in the file P06_48.xlsx. (The last two rows indicate the number of tons of pollutants removed per ton treated.)

a. Determine how to minimize the cost of meeting the state legislature’s goals.

b. Use SolverTable to analyze how a change in the requirement for pollutant 1 changes the optimal solution. Do the same for pollutant 2.