SOLVE IN EXCEL USING SOLVER SHOW THE SOLVER AND ALL FORMULAS USED

P06_48.xlsx

Because of excessive pollution on the Momiss River, the state of Momiss is going to build some pollution control stations. Three sites are under consideration. Momiss is interested in controlling the pollution levels of two pollutants. The state legislature requires that at least 100,000 tons of pollutant 1 and at least 80,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. A B D 1 Momiss River data 2 3 Data on possible sites 4 5 Cost of building 6 Cost/ton of treatment 7 Amt of pollutant 1 removed 8 Amt of pollutant 2 removed Site 1 Site 2 Site 3 $2,500,000 $2,200,000 $1,400,000 $50 $45 $35 0.50 0.40 0.25 0.35 0.30 0.25