Please complete the sensitivity report only on excel !!

MyTrans, LLC MyTrans, LLC, a long-distance telephone company, uses a fiber-optic network to transmit phone calls and other information between locations. Calls are carried through cable lines and switching nodes. A portion of the company's transmission network appears below. The numbers above each are show the capacity of text messages that can be transmitted over that branch of the network per minute. Note that messages can be sent only in the direction of the arrowheads. For example, messages may be transmitted from node 2 to node 6, but not from node 6 to node 2. Given this network design, what is the maximum number of messages per hour that can be sent from node 1 to node 7? 1,614 1,877 1,445 131 2,575 MyTrans has 7 node constraints, 10 arc constraints, 11 DVs. Correctly solved, maximum messages per minute > 7220. Note data given in minutes and questions asked in hours. Be prepared to resolve the problem if a node or arc are closed. 3 1,250 1,741 700 2,041 3,245