a. Assume that Caro-Life wants to maximize the average sales potential of its ten offices. Where should

Question:

a. Assume that Caro-Life wants to maximize the average sales potential of its ten offices. Where should it locate offices and what is the population and geographic area associated with each office?

b. Assume that Caro-Life wants to minimize the average geographic area covered by each of its ten offices. Where should it locate offices and what is the population and geographic area associated with each office?

c. Determine the solution that minimizes the maximum percentage deviation from the optimal objective function values identified in parts a and b. According to this solution, where should Caro-Life locate its offices and what is the population and geographic area associated with each office?

d. Suppose that Caro-Life considers maximizing average sales potential of its territories to be twice as important as minimizing the average geographic size of its territories. Find the solution that minimizes the maximum weighted percentage deviations. According to this solution, where should Caro-Life locate its offices and what is the population and geographic area associated with each office?

Caro-Life is a financial services firm that specializes in selling life, auto, and home insurance to residential consumers in North Carolina. The company is planning to expand and offer its services in South Carolina. The company wants to open ten offices throughout the state to ensure that all residents of the state can access at least one office in either their county of residence or an adjacent county. The set of counties adjacent to the county containing each office will be regarded as the sales territory for that office. (A county is considered to be adjacent to itself.) Figure (and the file Fig on your data disk) shows a portion of an Excel spreadsheet with a matrix indicating county adjacencies throughout the state, and the estimated population and geographic size (in square miles) for each potential sales territory. (Values of 1 in the matrix indicate counties that are adjacent to one another.)

Sales of insurance products in a given area tend to be highly correlated with the number of people living in the area. As a result, agents assigned to the various offices want their sales territories to contain as many people as possible (to maximize sales potential). On the other hand, territories containing large amounts of people also may consist of a large geographic area that might require agents to travel a lot. So the goal of having a territory with lots of people sometimes conflicts with the goal of having a territory that is compact in size. It is important for Caro-Life to design its sales territories in as equitable a manner as possible (i.e., where the territories are similar in terms of geographic size and salespotential).