Part III: Cost-Benefit Analysis The City of Econopolis is curious about implementing green infrastructure - such as rain gardens, bioswales, and permeable pavement - as a nature-based solution to its growing stormwater management challenges. It is considering building the 5 projects described in the table on the following page, which utilize a few different types of green infrastructure practices Project Number of Acres Properties within a 50- foot radius Properties within a 750- foot radius 19 12 396 Initial Construction Cost $2,500,0XX0 $3,575,000 $1,750,000 $4.900,0XX $4,150,000 25 Project 1 Project 2 Project 3 Project 4 Project 5 Annual Expected Stormwater Capture (gallons / year) 13,000,000 26,500,000 15,500,000 29,000,000 12,500,000 9 117 90 17 5 33 11 17 308 510 10 Other Assumptions: Each project requires ongoing operations and maintenance, which costs about $3,700 per acre per year. The Econopolis Water Authority estimates that each gallon of stormwater captured by green infrastructure removes 0.01 pounds of sediment, O.XX08 pounds of nitrogen, and 0.0007 pounds of phosphorus from the wastewater system. Current treatment costs are about $1.00 per pound of seciment, $3.00 per porurid of nitrogen, and $4.50 per pound of phosphorus Econopolis has hired you to evaluate the green infrastructure projects, and respond to the tasks and questions provided 1. Construct a cost-benefit model in Excel for water quality outcomes (sediment, nitrogen, and phosphorus) from the projects, like the one we walked through for green roofs in class. Note: Not all parameters to conduct the cost-benefit analysis are provided. You will need to select your own- more points are given for justifications of your selection than picking the "right" answer. 1. Based on water quality outcomes alone, should Econopolis construct these projects b. From a cost-benefit perspective, which projects are better or worse