A Н K Caution: 3 100 points 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 4 #2. Problem #48 (30 points) a. (20 points) Data on possible sites Site 1 Site 2 9. Cost of building 2500000 2200000 1400000 slightly to accommodate proper formatting, Cost/ton of treatment 35 but changing the widths in a significant manner is prohibited. 0.25 Not following these instructions can result in serious loss of points. 10 50 45 11 Tons of pollutant 1 removed/ton treated 0.5 0.4 12 Tons of pollutant 2 removed/ton treated 0.35 0.3 0.25 All cells in all sheets must be properly formatted. These include aligning contents, using: number format and decimal 13 14 Upper bound for Pollutant 1 15 Upper bound for Pollutant 2 16 Upper bound for the site places for numerical contents, use of bolding, italics, borders, etc. in an 17 appropriate fashion so that the readability of the content is enhanced. 18 Select sites to build (1 if built, 0 if not) Site 1 Site 2 Site 3 19 Build sites? 20 Logical treatment capacity is based on 21 Amounts of water treated the maximum number of tons that needs 22 to be to be treated at a given site to 23 Logical treatment capacity remove required pollutants. 24 25 Constraints on pollutants removed 26 Removed Required 27 Pollutant 1 28 Pollutant 2 29 Summary of costs Cost of building stations 30 31 Answer key: 32 Cost of treating water C32 = 13928571.43 33 Total cost B 35 36 b. Discuss the result of SolverTable for pollutant 1 below. (5 pints) Use Justify and make sure the text is within the box below. 37 38 39 40 41 42 43 44 45 Discuss the result of SolverTable for pollutant 2 below. (5 pints) Use Justify and make sure the text is within the box below. 46 47 48 49 50 51 52 53 54