The Reeves Corporation wants to assign each of their thirteen corporate clients to exactly one of their
Question:
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:
.png){kind=small}
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.
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may...
Step by Step Answer:
a b Assignments 1 2 3 Sum Revenue A 1 0 0 1 6700 B 0 0 1 1 8400 C 0 0 1 1 5200 D 0 1 0 1 7000 E 0 0 ...View the full answer
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
