PROBLEM 2: In municipal water supply systems, engineers must…
PROBLEM 2: In municipal water supply systems, engineers must calculate flow rates in interconnected pipes to ensure adequate pressure and delivery. Consider a pipe network with four interconnected pipes with unknown flow rates Q1, Q2, Q3, and Q4. Conservation of mass and conservation of energy principles enforce the water supply system to satisfy the following set of linear equations: Use Excel to write the coefficient matrix and right hand side vector for these set of linear equations. Determine the inverse of the coefficient matrix. Find the solution for the flowrates Q1, Q2, Q3, and Q4 that satisfy the equations using the inverse matrix method. Use Solver to find the solution for the flowrates Q1, Q2, Q3, and Q4 that satisfy the equations. Select the last equation as Objective and the other three equations as constraints. Compare your solution to the one in part C. SAVE YOUR EXCEL FILE AND CONTINUE TO THE NEXT PROBLEM