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 increaser the capacity (in millions of dollars/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 requirements of 35 GB/s. Network Segment Total Capacity Existing capacity (GB/s) Maximum Additional Capacity (GB/s) New Max Capacity Cost/GB/s of additional capacity ($Million) From To Nodes Supply/Demand A B 11.66667 ≤ 13 6 19 $2.80 A 11.66667 11.66666667 A C 0 ≤ 6 4 10 $2.50 B 0 = 0 A D 0 ≤ 10 3 13 $2.80 C 0 = 0 B D 11.66667 ≤ 9 4 13 $2.50 D 0 = 0 B E 0 ≤ 5 5 10 $3.10 E 0 = 0 B F 0 ≤ 7 3 10 $1.60 F 0 = 0 C D 0 ≤ 8 5 13 $3.90 G -11.6667 11.66666667 D E 0 ≤ 3 2 5 $2.80 D G 11.66667 ≤ 12 5 17 $1.60 Cost of Max Bandwidth $571.67 E F 0 ≤ 4 2 6 $4.60 E G 0 ≤ 6 4 10 $2.90 F G 0 ≤ 9 5 14 $1.80 35 Cost of Additional capacity: $32.90 ≤ 35

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter15: Decision Analysis

Section: Chapter Questions

Problem 5P: Hudson Corporation is considering three options for managing its data warehouse: continuing with its...

See similar textbooks

Related questions

Question

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 increaser the capacity (in millions of dollars/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 requirements of 35 GB/s.

Network Segment	Total Capacity		Existing capacity (GB/s)	Maximum Additional Capacity (GB/s)	New Max Capacity		Cost/GB/s of additional capacity ($Million)
From	To			Nodes			Supply/Demand
A	B	11.66667	≤	13	6	19		$2.80	A	11.66667		11.66666667
A	C	0	≤	6	4	10		$2.50	B	0	=	0
A	D	0	≤	10	3	13		$2.80	C	0	=	0
B	D	11.66667	≤	9	4	13		$2.50	D	0	=	0
B	E	0	≤	5	5	10		$3.10	E	0	=	0
B	F	0	≤	7	3	10		$1.60	F	0	=	0
C	D	0	≤	8	5	13		$3.90	G	-11.6667		11.66666667
D	E	0	≤	3	2	5		$2.80
D	G	11.66667	≤	12	5	17		$1.60	Cost of Max Bandwidth	$571.67
E	F	0	≤	4	2	6		$4.60
E	G	0	≤	6	4	10		$2.90
F	G	0	≤	9	5	14		$1.80
		35					Cost of Additional capacity:	$32.90
		≤
		35

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here