Solve using Excel 1) The following is the sewage pipeline in a small town. Many city populations

Solve using Excel

Transcribed Image Text:

1) The following is the sewage pipeline in a small town. Many city populations complain about sanitation and the awful smell of floating sewage in their neighborhood. The engineering at Mayer office estimated that the city could produce 25 tons per hour of sewage. The graph below represents various flows that can occur through a sewage treatment plant, with the numbers on the arcs representing the maximum flow (in tons of sewage per hour) that can be accommodated. Based on your analyses, the Mayer office should expand the sewage pipeline or not. Node number 8 is the Sewage Treatment Plant. (You must show all your calculations by the solver. You don't have to show the LP model) 1 00 10 2 5 3 9 9 4 7 12 00 5 5 сл S 6 7 10 6 3 8 1) The following is the sewage pipeline in a small town. Many city populations complain about sanitation and the awful smell of floating sewage in their neighborhood. The engineering at Mayer office estimated that the city could produce 25 tons per hour of sewage. The graph below represents various flows that can occur through a sewage treatment plant, with the numbers on the arcs representing the maximum flow (in tons of sewage per hour) that can be accommodated. Based on your analyses, the Mayer office should expand the sewage pipeline or not. Node number 8 is the Sewage Treatment Plant. (You must show all your calculations by the solver. You don't have to show the LP model) 1 00 10 2 5 3 9 9 4 7 12 00 5 5 сл S 6 7 10 6 3 8