Question: Homework 6 The graph above represents various flows that can occur through a sewage treatment plant with the numbers on the ares representing the maximum

Homework 6 The graph above represents various flows that can occur through a sewage treatment plant with the numbers on the ares representing the maximum flow (in tons of sewage per hour) that can be accommodated. (a) Formulate an L.P model to determine the maximum tons of sewage per hour that can be processed by this plant. (30 points)(b) Implement your model in Excel and solve it.(50 points)(c) What is the optimal solution? (20 points)\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|}\hline & A & B & C & D & E & F & G & H & 1\\\hline 4 & & of Flow & From & To & Bound & & Node & Net Flow & \\\hline 5 & & & 1 & 2 & 8 & & 1 & & \\\hline 6 & & & 1 & 3 & 9 & & 2 & & \\\hline 7 & & & 1 & 4 & 7 & & 3 & & \\\hline B & & & 2 & 3 & 7 & & 4 & & \\\hline 9 & & & 2 & 5 & 10 & & 5 & & \\\hline 10 & & & 3 & 5 & 8 & & 6 & & \\\hline 11 & & & 3 & 6 & 7 & & 7 & & \\\hline 12 & & & 3 & 7 & 9 & & & & \\\hline 13 & & & 4 & 3 & 6 & & & & \\\hline 14 & & & 4 & 6 & 9 & & & & \\\hline 15 & & & 5 & 7 & 9 & & & & \\\hline 16 & & & 6 & 7 & 11 & & & & \\\hline 17 & & & 7 & 1 & 1E+06 & & & & \\\hline 18 & & & = Maxim & Flow & & & & & \\\hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!