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 $70,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 indicatethe 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.
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 $70,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 indicatethe 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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
