I need help with part B the excel file. I do not know what formulas to use in each cell or in the solver. Please help me with the inputs. I have attached a picture of the excel file I was given.

The graph above 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.

$($a$)$ Formulate an LP 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$)$