Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Reeves Corporation wants to assign each of its 13 corporate clients to exactly one of its 3 salespersons. The estimated annual sales potential (in
The Reeves Corporation wants to assign each of its 13 corporate clients to exactly one of its 3 salespersons. The estimated annual sales potential (in $1,000,000s)
4, The Reeves Corporation wants to assign each of their 13 corporate clients to exactly one of its three salespersons. The estimated annual sales potential {in $1,000,000s) for each of the clients is summarized in the following table: Client | A B C D E F G H | 1 K L M Est $67 '584 'ssz $70 '5?4 $62 | $94 '563 '5?3 $109 ' $77 | $36 '5114 Sales Reeves wants each salesperson to be assigned to 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. (Hint: There should be a goal for the estimated annual sales potential for each salesperson.) b. Assume the company wants to minimize the sum of the absolute deviations from each goal. Implement your model in a spreadsheet and solve itStep 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