Solve in excel and show formulas

a. By utilizing the entire computer network, what is the maximum bandwidth available (in GB/s ) for transmission from the general site of the Olympic Games (node A) to the home studios (node G)? Set up and solve a linear programming spreadsheet model. b. WBC would like to expand the capacity of the network so it can handle the peak requirement of 35GB/s from the Olympics site (A) to the home studios (G). WBC can increase the capacity of each link of the computer network by installing additional fiber optic cables. The next table shows the existing capacity of each network segment (in GB/s), the maximum additional capacity that can be added (in GB/s), and the cost to increase the capacity (in millions of dollars per unit GB/s added). Make a copy of the spreadsheet model used to solve part a and make any revisions necessary to solve this new problem of handling the peak requirement of 35GB/s. Notc: This case will be continued in the next chapter (Case 7-4 ), so we suggest that you save your spreadsheet model from part b. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Network Segment } & \multirow{2}{*}{ExistingCapacity(GB/s)} & \multirow{2}{*}{MaximumAdditionalCapacity(GB/s)} & \multirow{2}{*}{CostperGB/sofAdditionalCapacity($million)} \\ \hline From & To & & & \\ \hline A & B & 13 & 6 & 2.8 \\ \hline A & C & 6 & 4 & 2.5 \\ \hline A & D & 10 & 3 & 2.8 \\ \hline B & D & 9 & 4 & 2.5 \\ \hline B & E & 5 & 5 & 3.1 \\ \hline B & F & 7 & 3 & 1.6 \\ \hline C & D & 8 & 5 & 3.9 \\ \hline D & E & 3 & 2 & 2.8 \\ \hline D & G & 12 & 5 & 1.6 \\ \hlineE & F & 4 & 2 & 4.6 \\ \hlineE & G & 6 & 4 & 2.9 \\ \hline F & G & 9 & 5 & 1.8 \\ \hline \end{tabular} Broadcasting the Olympic Games The management of the WBC television network has been celebrating for days. What a coup! After several unsuccessful attempts in recent decades, they finally have hit the big jackpot. They have won the bidding war to gain the rights to broadcast the next Summer Olympic Games! The price was enormous. However, the advertising income also will be huge. Even if the network loses some money in the process, the gain in prestige should make it all worthwhile. After all, the entire world follows these games closely every four years. Now the entire world receiving the feed of the broadcast from the WBC network will learn what a preeminent network it is. However, reality also is setting in for WBC management. Telecasting the entire Olympic Games will be an enormously complex task. Many different sporting events will be occurring simultaneously in far-flung venues. An unprecedented amount of live television and live-on-the-Internet coverage of the various sporting events needs to be planned. Due to the high amount of bandwidth that will be required to transmit the coverage of the games back to its home studios, WBC needs to upgrade its computer network. It operates a private computer network as shown in the network diagram below. The games will be held near node A. WBC's home studios are located at node G. At peak times, coverage of the games will require 35GB/s ( 35 gigabytes of data per second) to be sent through the network from node A to node G. The capacity of each link in the network is shown in the diagram below (in GB/s ). WBC can divide the transmission and route it through multiple paths of the network from A to G, so long as the total bandwidth required on each link does not exceed the capacity of that link. a. By utilizing the entire computer network, what is the maximum bandwidth available (in GB/s ) for transmission from the general site of the Olympic Games (node A) to the home studios (node G)? Set up and solve a linear programming spreadsheet model. b. WBC would like to expand the capacity of the network so it can handle the peak requirement of 35GB/s from the Olympics site (A) to the home studios (G). WBC can increase the capacity of each link of the computer network by installing additional fiber optic cables. The next table shows the existing capacity of each network segment (in GB/s), the maximum additional capacity that can be added (in GB/s), and the cost to increase the capacity (in millions of dollars per unit GB/s added). Make a copy of the spreadsheet model used to solve part a and make any revisions necessary to solve this new problem of handling the peak requirement of 35GB/s. Notc: This case will be continued in the next chapter (Case 7-4 ), so we suggest that you save your spreadsheet model from part b