Please answer in excel.

A new airport being built will have three terminals and two baggage pickup areas. An automated baggage delivery system has been designed to transport the bageage from each terminal to the two baggage pickup areas. This system is depicted graphically the figure, where nodes 1,2 , and 3 represent the terminals, and nodes 7 and 8 represent the baggage pickup areas. The maximum number of bags per minute that can be handled by each part of the system is indicated by the value on each arc in the network. A. Formulate an LP model to determine the maximum number of bags per minute that can be delivered to the baggage pickup areas (node 7 and 8 ) by this system. Use Solver to find the optimal solution to this problem. B. If capacity leaving even numbered nodes (2,4, and 6) doubled, how does your solution change? C. Using the original input data from Part A, If transhipment Node 4 shut down for maintenance, what is the new optimal solution? Explain your findings in the Management Statement box