Formulate and solve the four$-$reservoir optimization problem $($see below figure.$)$

for $12$ periods. using an EXCEL SOLVER.

Constraints on the maximum Storages: S$1,$ S$2,$ S;S

Upper limit on Releases: R;R$2,$ R ;R;

Constant Inflows: I $1$ and I$2=2$; and $3$ respectively for all the time intervals.

Initial Storages for all the reservoirs: $5$

Comment on the solution. Plot the storage variations for all the reservoirs in all

time intervals.

Unit Benefits $($benefit per unit of water released$)$ for reservoirs $1-4$ for each time

interval.

can you solved this problem using excel solver and make a formulation