Question: 9. SunNet is a residential Internet Service Provider (ISP) in the central Florida area. Presently, the company operates one centralized facility that all of

 

9. SunNet is a residential Internet Service Provider (ISP) in the central

9. SunNet is a residential Internet Service Provider (ISP) in the central Florida area. Presently, the company operates one centralized facility that all of its clients call into for Internet access. To improve service, the company is planning to open three satel- lite offices in the cities of Pine Hills, Eustis, and Sanford. The company has identi- fied five different regions to be serviced by these three offices. The following table summarizes the number of customers in each region, the service capacity at each 214 Chapter 5 Network Modeling office, and the average monthly per customer cost of providing service to each region from each office. Table entries of n.a." indicate infeasible region-to-service- center combinations. SunNet would like to determine how many customers from each region to assign to each service center to minimize cost. Region Pine Hills Eustis Sanford Customers 1 $6.50 $7.50 n.a. 30,000 $7.00 $8.00 n.a. 40,000 3 $8.25 $7.25 $6.75 25,000 4 n.a. $7.75 $7.00 35,000 5 n.a. $7.50 $6.75 33,000 Capacity 60,000 70,000 40,000 a. Draw a network flow model to represent this problem. b. Implement your model in Excel and solve it. C. What is the optimal solution?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Draw a Network Flow Model Nodes Source Nodes Regions 5 regions 1 to 5 Destination Nodes Service Ce... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!