Use the Excel Solver$/$WaterCAD to solve the problem: All pipes in the system $($as indicated in

Figure below$)$ are $1ft$ in diameter and assume $f=0\mathrm{.}015.$ Flow come in from $Q_A=10cfs,$ and flow

come out from $Q_F=10cfs(1)$ Determine the distribution of flow for the given system using

WaterCAD or Excel Solver $(2)$ Find the pressure at point $F$ if the gage pressure at source $A$ is $60$

psi by a manual solution $($Please use information of output from Excel$/$WaterCAD$).$