Please include Excel formulas and Solver formulation :)

d. Once the president releases the number of planes, ships, and trucks that will travel between the United States and the Russian Federation, Tabitha Neal contacts each of the American cities and NATO countries to indicate the number of planes to expect at the airfields, the number of ships to expect at the docks, and the number of trucks to expect traveling across the roads Unfortunately, Tabitha learns that several additional restrictions exist that cannot be immediately eliminated. Because of airfield congestion and unalterable flight schedules, only a limited number of planes may be sent between any two cities. These plane limitations are given below. In addition, because some countries fear that citizens will Tabitha learns that all shipping lanes have no capacity limits become alarmed if too many military trucks travel the pubdue to the American control of the Atlantic Ocean. lic highways, they object to a large number of trucks traveling The president realizes that due to all the restrictions, he through their countries. These objections mean that a limited will not be able to satisfy all the reinforcement requirements number of trucks are able to travel between certain ports and of the three Russian cities. He decides to disregard the cost Russian cities. These limitations are listed below. issue and instead to maximize the total amount of cargo he can get to the Russian cities. How does the president maximize the total amount of cargo that reaches the Russian Federation? Highlight the path(s) used between the United States and the Russian Federation on the network. =W