The Reeves Corporation wants to assign each of their thirteen corporate clients to exactly one of their three salespersons. The estimated annual sales potential (in $1,000,000s) for each of the clients is summarized in the following table:

Reeves wants to each salesperson to be assigned at least three customers and no more than six customers. The company wants to assign customers to the sales force in such a way that the estimated annual sales potential for each salesperson’s set of customers is as equal as possible.
a. Formulate a GP model for this problem. (There should be a goal for the estimated annual sales potential for each salesperson.)
b. Assume that the company wants to minimize the sum of the absolute deviations from each goal. Implement your model in a spreadsheet and solveit.

Transcribed Image Text:

Client A B C D E , GHI,KIM Est. Sales $67 $84 $52 $70 $74 $62 $94 $63 $73 $109 $77 $36 $114