A medical supply company has customers in eight cities. It is trying to decide how many salespeople it needs to service these customers. Each salesperson needs to be located in one of the eight cities and needs to be assigned to a subset of the customers. For example, the company might base a salesperson in New York and have this person service customers in New York, Boston, and Philadelphia. Each salesperson receives an annual salary of $50,000 and can work as many as 230 days per year. This includes days working with customers and days traveling to and from customers. The file P06_90.xlsx contains data on the annual travel costs (for example, $15,900 for a salesperson based in New York traveling for customers in Orlando), the annual number of days of work required for the customers, and the annual number of days traveling to and from customers. Find an assignment that minimizes the total cost of salaries and traveling. The solution should indicate the number of salespeople to employ, where they should be based, and which cities they should serve. Assume that customers in a given city must be serviced by a single salesperson.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.