Question
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
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 Internet access. To improve service, the company is planning to open three satellite 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 summarizes 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 combinations. 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.
b. Implement your model in Excel and solve it. (50 points)
c. What is the optimal solution? (20 points)
I just need help with the steps on how to input the problems in the excel spreadsheet below and how to input the information into solver.
SunNet Flow From To Cost Node Net Flow Supply/Demand 1 6 $6.50 -30 $7.50 -40 6 $7.00 -25 $8.00 -35 6 $8.25 -33 $7.45 60 $6.75 70 $7.75 40 8 $7.00 7 $7.50 8 $6.75 Total Cost\fStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started