PLEASE PROVIDE THE EXCEL SOLUTION USING SOLVER AND DESCRIBE THE OBJECTIVE FUNCTION, DECISION VARIABLES AND CONSTRAINTS.

It is a part of network flow models- management science

The traffic management office in Richmond is attempting to analyze the potential traffic flow from a new office complex under construction to an interstate highway interchange during the evening rush period. Cars leave the office complex via one of three exits, and then they travel through the city streets until they arrive at the interstate interchange. The following network shows the various street routes (branches) from the office complex (node 1) to the interstate interchange (node 9): 0 7 3 0 2 2 5 6 5 0 All intermediate nodes represent street intersections, and the values accompanying the branches emanating from the nodes represent the traffic capacities of each street, expressed in thousands of cars per hour. Determine the maximum flow of cars that the street system can absorb during the evening rush hour