Just need to find the total system head at the different flow rates specified. Thank you. Will upvote.

(30 points) As an engineer with WonderWater Engineering, you are sizing a pump to supply a city with water from a nearby river. Water usage by the residents varies with the time of day (and time of year), and you want to pick a pump that will function effectively all year long. The anticipated municipal water demand is 3,000gpm, but it may peak as high as 10,000gpm. The pump will fill an open reservoir that is 80ft higher than the river. The pipeline is 1,000ft of 16 nominal schedule 40 standard steel and contains a series of valves and fittings as shown in the table below. You also need to account for skin friction, the contraction at the pipe entrance, and expansion at its exit. a. Begin by drawing a diagram of the system, and label the appropriate details. b. Plot a system curve. Using Excel, calculate the total system head at flowrates from 0 to 10,000 gpm. I did mine in 1,000gpm increments. Plot the result as a H vs. Q graph. Be sure to label your