. Confort Flow From 1 1 2 2 3 3 3 4 4 5 5 Te $ 2 5 7 5 7 3 7 3 7 . Cost $550 5750 $700 $300 $825 57 $8.75 ST. ST $750 Node Net Flow Supply Demand 1 30 2 40 3 -25 4 -35 5 30 6 50 7 70 8 40 Total Cost Type here to o C e 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 identified five different regions to be serviced by these three offices. The following table sum- marizes the number of customers in each region, the service capacity at each 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 combi- nations. SunNet would like to determine how many customers from each region to assign to each service center in order to minimize the cost of providing service to all customers. Sanford n.a n.a Region 1 2 3 4 5 Capacity Pine Hills $6.50 $7.00 58.25 n.a n.a 60,000 Eustis $7.50 $8.00 $7.25 $7.75 $7.50 70,000 Customers 30,000 40,000 25,000 35,000 33,000 $6.75 $7.00 $6.75 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