The branching pipe$-$pump transmission system shown below has elevations $E_A=100ft$ and $E_D=150ft.$ All pipes share a friction factor of $0\mathrm{.}020.$ The section from A to B is $4,000ft$ in length with a diameter of $3$ ft $,$ and the section from C to D is $1,140ft$ with the same $3$ ft diameter. Two branches split off between B and C: branch B$-1-$C$,$ which is $100$ ft long with a $2$ ft diameter, and branch B$-2-$C$,$ extending $500$ ft with a diameter of $1$ ft $.$ The pump's performance data $($pump curve$)$ is provided in the table below. Find the total flow rate being transferred between the reservoirs in $f\frac{t^3}{s}.$ Minor losses are negligible.

NOTE: To simplify, save time, and successfully solve this system, reduce the design to a single pipe and pump system problem. In other words, you will need an equivalent pipe to replace the pipes B$-1-$C and B$-2-$C in parallel. Use an Excel spreadsheet to aid your calculations. You must submit the pump curve and system curve graphs as part of your solution.

$\backslash$table$[[Q(cfs),H_p(ft)$