2. A map of a hypothetical water distribution system is attached. The map is neither to scale nor proportionally correct. The map depicts four different zoning areas. The acreage of each area and the average water demand per acre are presented in the table below. These values will be input values in the spreadsheet you will develop for this assignment. The output values will be a table displaying the water demands experienced at each node. Water Demand (gpm/ac) Area Number Area (acres) 1 5.6 120 2 4.2 180 3 4.8 200 4 6.2 100 Your assignment is to allocate water flows from the nodes of the water distribution system. You should explain your allocation scheme and how you did it. Input and output tables should be clearly labeled. Deliverables are the input and output tables for the water system and a narrative description of your allocation scheme. Grading will be based on technical correctness and clarity of methodology description. Area No. Area Water Demand (gpm/ac) Water Demand (gpm) (ac) 1 2 3 4 Total Water Distribution Node Flow Contribution (gpm) Area 2 Area 3 Total flow (gpm) Area 1 Area 4 1 2 3 4 5 6 7 8 9 Total 2. A map of a hypothetical water distribution system is attached. The map is neither to scale nor proportionally correct. The map depicts four different zoning areas. The acreage of each area and the average water demand per acre are presented in the table below. These values will be input values in the spreadsheet you will develop for this assignment. The output values will be a table displaying the water demands experienced at each node. Water Demand (gpm/ac) Area Number Area (acres) 1 5.6 120 2 4.2 180 3 4.8 200 4 6.2 100 Your assignment is to allocate water flows from the nodes of the water distribution system. You should explain your allocation scheme and how you did it. Input and output tables should be clearly labeled. Deliverables are the input and output tables for the water system and a narrative description of your allocation scheme. Grading will be based on technical correctness and clarity of methodology description. Area No. Area Water Demand (gpm/ac) Water Demand (gpm) (ac) 1 2 3 4 Total Water Distribution Node Flow Contribution (gpm) Area 2 Area 3 Total flow (gpm) Area 1 Area 4 1 2 3 4 5 6 7 8 9 Total