Existing Network Segment Capacity From To (GB/s) A B 13 Maximum Additional Capacity (GB/s) 6 Cost per GB/s of Additional Capacity ($million) 2.8 A C 6 4 2.5 A D 10 B D 6 B E LO 5 B F 7 C D 00 8 D LL F E GEG 3 D E F 4 E 12 3 535 25 2 2.8 4 2.5 3.1 1.6 3.9 2.8 1.6 4.6 6 4 2.9 6 10 5 1.8 13 10 G 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 35 GB/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 35 GB/s. Note: This case will be continued in the next chapter (Case 7-4 ), so we suggest that you save your spreadsheet model from part b.