Question: QUESTION 3 ( Discrete - variable Optimization, Unconstrained ) . Tool to use: Knapsack or binary programming. As most sewer pipes in developed countries approach
QUESTION Discretevariable Optimization, Unconstrained Tool to use: Knapsack or binary
programming.
As most sewer pipes in developed countries approach the end of their service lives, there is increasing
danger of pipe failures, leakages, and violent explosions due to methane gas accumulations. Therefore,
there exists an urgent need to carry out rehabilitation in order to extend sewer pipe service lives.
However, most cities are finding that budgets are limited and therefore not all sewer pipes can be
rehabilitated with available budgets.
The sewerage system for the City of Fort Wayne in Indiana Figure consists of major
connecting pipe sections along the streets shown in the figure. It is planned to carry out rehabilitation in
on the connector pipes in order to extend their service life, and to improve their condition and
performance. However, due to budgetary limitations not all the connector pipes can be rehabilitated.
The table insert in Figure shows, for each connector, the anticipated overall benefits in terms
of enhanced pipe durability and condition, customer satisfaction, etc. and costs in millions of dollars if
the rehabilitation is carried out. The rehabilitation budget for that year is $ie units of cost and
the city's mayor seeks to maximize the total benefits, under the given budget, to be earned due to the
rehabilitation projects selected in that year.
As a consultant for the City of Fort Wayne, you are advising the city to identify the optimal
solution ie which pipes must be rehabilitated and which must not, in order to satisfy the objective and
constraints
a Write the stated objective in mathematical notation.
b Write all the constraints in mathematical notation. Don't forget the binary choice constraints!
c Use Solver to solve this problem ie find the optimal solution
d Adding a political constraint: Now assume that the city mayor requests that rehabilitation work on the
Sherman Road Connector should definitely be among those to be carried out, irrespective of its costs or
benefits. Write this additional constraint in mathematical notation.
e Use Solver to determine the new optimal solution due to the addition of this political constraint and
discuss how the solution changed compared to that in c
f For each of c and e attach a page output printout of the Solver output solution
Figure City of Fort Wayne showing locations of the pipe connectors its sewerage system
Box insert presents the expected benefits and costs of candidate rehabilitation actions in the given year
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
