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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

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