Q2 (40 pts): Consider the water distribution network shown in the figure below and the different water demands assigned to each node given in the accompanying table. Assume all nodes

have the same elevation. Part A: Use the Darcy-Weisbach method to determine the discharge in each PVC ("smooth") pipe and the pressure head at each node. An example calculation for each step is required, but you can show the convergence of your solutions by presenting only the tables (from Excel) for each iteration. Please ensure your tables are legible, easy to follow, and organized. Submit the Excel file as part of your .zip folder. Part B: Solve the problem using EPANET. How do the results compare to your hand calculations? Please include a screenshot of your final results in the EPANET (i.e., showing flows and pressures) model to accompany your discussion. Submit the EPANET model as part of your .zip folder. Part C: Assume the total demand at node E is now 0.6 cfs and that the required minimum nodal pressure is 75 psi. Use EPANET to redesign the system by changing the diameter of one pipe and provide a brief justification for your choice. Note: only replace one pipe at a time. Do not replace multiple segments. Please include a screenshot of your final results in the EPANET (i.e., showing flows and pressures) model to accompany your discussion. Submit the EPANET model as part of your .zip folder. 1000 ft 12 in Water Users C Industrial Commercial Commercial Residential Residential Residential Commercial Fire flow demand 1250 ft 12 in. 1000 ft 8 in 1050 ft 8 in. 1100 ft 8 in. Figure 2: Diagram of the water distribution network, including the lengths and diameters of the pipes. 12 in. 1250 ft Table 1: Water demands for nodes in the water distribution network. 6.77 acres 2.90 acres 2.90 acres E 12 in. 600 ft 120 persons 502 persons 598 persons 3.30 acres Area or population Max. daily unit served consumption 21,000 gal/acre/day 45,000 gal/acre/day 45,000 gal/acre/day 270 gal/person/day 270 gal/person/day 270 gal/person/day 45,000 gal/acre/day 0.94 cfs Connecting Node B E E D D F D