The pump in the system shown below is used to transport water from reservoir A to reservoir B. The elevation difference between the two reservoirs is Δz, and the piping has a 370 ft length of 16-in diameter. The flow is fully turbulent with Darcy-Weisbach friction factor of 0.0002. The minor losses in the system are negligible and can be ignored. Suppose the pump vendor has supplied the characteristics of the pump in a form of tabulated data (shown in the table below), answer the following: (a) Using an excel sheet, plot the pump supply and efficiency curves Vs volume flow rate using the data provided by the vendor. (b) For the given dimensions of the system, generate the general system curve equation (useful head as function of elevation and volume flow rate). (c) Plot two system curves, one with Δz = 0 ft and Δz = 50 ft, in the same figure of the plots generated in part ‘a’. (d) From part ‘c’, determine the operating points and the efficiencies corresponding to the operating points of the two different Δzs. (e) For the two operating points in part ‘d’, determine the power inputs required by the pump. Note: Please include any excel sheet, MATLAB or python script (if any) in addition to scanned hand calculations