The rise in the water tables in a certain coastal city due to global warming is causing geotechnical problems for structures on flat clay foundations. Specifically, the moisture saturation of the otherwise dry clay is causing rapid loss of strength and settlement at five critical civil engineering structures citywide. As the city engineer, you have been given $10 million to select the projects that maximize geotechnical retrofits for these structures. Your geotechnical engineer has reported the project costs and benefits of the geotechnical retrofits at these sites (see table below). The benefits are measured in terms of the value of the civil engineering system to the society (on a scale of 1- 10) Formulate this as a binary linear programming problem (Objective Function and All Constraints are linear expressions of the decision variable. The variable xi s Binary variable). Use Excel Solver to find the optimal solution (corresponding total benefit) The rise in the water tables in a certain coastal city due to global warming is causing geotechnical problems for structures on flat clay foundations. Specifically, the moisture saturation of the otherwise dry clay is causing rapid loss of strength and settlement at five critical civil engineering structures citywide. As the city engineer, you have been given $10 million to select the projects that maximize geotechnical retrofits for these structures. Your geotechnical engineer has reported the project costs and benefits of the geotechnical retrofits at these sites (see table below). The benefits are measured in terms of the value of the civil engineering system to the society (on a scale of 1- 10) Formulate this as a binary linear programming problem (Objective Function and All Constraints are linear expressions of the decision variable. The variable xi s Binary variable). Use Excel Solver to find the optimal solution (corresponding total benefit)