The city of Six Mile, South Carolina, is considering making several of its streets one-way. What is the maximum number of cars per hour that can travel from east (node 1) to west (node 8)? The network is shown below.
Solve the given problem scenario to determine the maximum number of cars per hour that can travel from east (node 1) to west (node 8) by formulating and setting up the problem in Excel Solver.
Directions:
Provide the written formulation in a Word document. (Provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible.)
The Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.