ATTENTION***!I INTEND TO LEAVE A THUMBS UP NO MATTER WHAT! I AM JUST HAPPY FOR A RESPONSE! ****ATTENTION

48.

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 legislatures 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.

ATTENTION***! I INTEND TO LEAVE A THUMBS UP NO MATTER WHAT! I AM JUST HAPPY FOR A RESPONSE! ****ATTENTION

ATTENTION***! I INTEND TO LEAVE A THUMBS UP NO MATTER WHAT! I AM JUST HAPPY FOR A RESPONSE! ****ATTENTION

J K 3 100 points #2. Problem #48 (30 points) Site 1 2500000 a. (20 points) Data on possible sites Cost of building Cost/ton of treatment Tons of pollutant 1 removed/ton treated Tons of pollutant 2 removed/ton treated Site 2 2200000 45 Caution: Do not alter the structure of this Excel file like adding/deleting columns/rows, moving contents from their cells, or renaming sheet names. Use the specified output cell range. You may change the column widths slightly to accommodate proper formatting, . Site 3 but changing the widths in a significant manner is prohibited 1400000 slightly to accommodate proper formatting, 35 but changing the widths in a significant manner is prohibited. 5 Not following these instructions can result in serious loss of points. 0.25 All cells in all sheets must be properly formatted. These include aligning contents, using appropriate number format and decimal places for numerical contents, use of bolding, italics, borders, etc. in an appropriate fashion so that the readability of the content is enhanced. Site 3 0.5 0.35 0.3 Upper bound for Pollutant 1 Upper bound for Pollutant 2 Upper bound for the site Site 1 Site 2 Select sites to build (1 if built, o if not) Build sites? Amounts of water treated Logical treatment capacity is based on the maximum number of tons that needs to be to be treated at a given site to remove required pollutants. Logical treatment capacity Constraints on pollutants removed Removed Required Pollutant 1 Pollutant 2 Summary of costs Cost of building stations Cost of treating water Total cost Answer key: C32 = 13928571.43 36 b. 37 Discuss the result of Solver Table for pollutant 1 below. (5 pints) Use Justify and make sure the text is within the box below. Discuss the result of SolverTable for pollutant 2 below. (5 pints) Use Justify and make sure the text is within the box below. J K 3 100 points #2. Problem #48 (30 points) Site 1 2500000 a. (20 points) Data on possible sites Cost of building Cost/ton of treatment Tons of pollutant 1 removed/ton treated Tons of pollutant 2 removed/ton treated Site 2 2200000 45 Caution: Do not alter the structure of this Excel file like adding/deleting columns/rows, moving contents from their cells, or renaming sheet names. Use the specified output cell range. You may change the column widths slightly to accommodate proper formatting, . Site 3 but changing the widths in a significant manner is prohibited 1400000 slightly to accommodate proper formatting, 35 but changing the widths in a significant manner is prohibited. 5 Not following these instructions can result in serious loss of points. 0.25 All cells in all sheets must be properly formatted. These include aligning contents, using appropriate number format and decimal places for numerical contents, use of bolding, italics, borders, etc. in an appropriate fashion so that the readability of the content is enhanced. Site 3 0.5 0.35 0.3 Upper bound for Pollutant 1 Upper bound for Pollutant 2 Upper bound for the site Site 1 Site 2 Select sites to build (1 if built, o if not) Build sites? Amounts of water treated Logical treatment capacity is based on the maximum number of tons that needs to be to be treated at a given site to remove required pollutants. Logical treatment capacity Constraints on pollutants removed Removed Required Pollutant 1 Pollutant 2 Summary of costs Cost of building stations Cost of treating water Total cost Answer key: C32 = 13928571.43 36 b. 37 Discuss the result of Solver Table for pollutant 1 below. (5 pints) Use Justify and make sure the text is within the box below. Discuss the result of SolverTable for pollutant 2 below. (5 pints) Use Justify and make sure the text is within the box below