Task:

Determine the optimum $($best$)$ pipe and tank combination $($Figure $1)$ to supply drinking water to a community. The optimum combination is the lowest combined pipe and storage cost that does not violate anv rnnetrainte

a$)$ Project Part A:

$[$Total $=5$ marks$]$

Submit the algorithm $($hand$-$sketched or computer generated$)$ for Project Part B on one A$4$ or A$3$ page.

On the page, provide a legend where each variable in the algorithm is described.

b$)$ Project Part B:

$[$Total$=15$ marks$]$

Submit one $(1)$ Excel$$ Macro$-$Enabled Workbook that contains the provided Data worksheet with the given input data. Do not rearrange the data.

Place one Optimise button on the Data worksheet. This button is to call the VBA code that will:

i$.$ Create the worksheet named Balancing storage calculations and compute Pipe supply, $Q(\frac{m^3}{s})$ for each Diameter $(D)$ and Tank volume $(m^3)$ at each hour. The below steps$/$formulae are to be employed:

To calculate Pipe supply, $Q(\frac{m^3}{s})$ :

Step $1$: Assume Velocity, $v_1(\frac{m}{s})=1$ and Velocity, $v_2(\frac{m}{s})=1$

Step $2$: Calculate Reynolds Number, $Re=v_1*D/$

Step $3$: Calculate pipe headloss coefficient Lambda, $$ using the

Swamee$-$Jain formula $=(\frac{1}{(-2*lo{g}_{10}(\frac{5\mathrm{.}74}{R{e}^{0\mathrm{.}9}}+\frac{K}{3\mathrm{.}7*D}))}{)}^2$

Step $4$: Calculate new Velocity, $v_2=\sqrt[\phantom{2}]{\frac{2*g*D*h_{\text{f}\text{m}\text{a}\text{x}}}{*l}}$

Step $5$:

$If{v}_1{v}_2,$ Then $v_1=v_2$; Repeat Steps $2to4$

$If{v}_1=v_2$ Then $Q=v_2^{**}$ Area $of$ pipe, $A(m^2).$ End

To calculate Tank volume $(m^3)$ :

Tank volume at $T_2=$ Tank volume at $T_1+$ Pipe supply during $T_1-$ Volume

demanded during $T_1$

ii$.$ Create the worksheet named Optimization and compute the following for each

pipe Diameter $(D)$ :

Pipe unit cost $($Rand$/$m$)$: $-$ Transfer from the Data worksheet

Pipe diameter, $D(m)$: $-$Transfer from the Data worksheet

Pipe supply, $Q(\frac{m^3}{s})-$ Transfer from the Balancing storage calculations worksheet

Pipe headloss, $h_f(m)=\frac{**l**v^2}{2**g**D}$

Pipe cost $($Rand$=$ Pipe length $*$ Pipe unit cost $($Rand$/$m$)[1/2]$

Balancing storage $(m^3)=$ absolute value of the Highest cumulative surplus$+$absolute value of the Highest cumulative deficit.

Extra storage $(m^3)=$ Emergency storage $+$ Fire storage $+$ Bottom storage.

Total storage $(m^3)=$ Balancing storage $+$ Extra Storage.

Storage cost $($Rand$)=$ Total storage $*$ Storage unit cost.

Total cost $($Rand$)=$ Storage cost $+$ Pipe cost.

Can you please do a complete flow chart algorithm with the appropriate shapes for the above question $($Project part B$).$