Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed
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 it

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Equations and Linear Algebra

Authors: Jerry Farlow, James E. Hall, Jean Marie McDill, Beverly H. West

2nd edition

131860615, 978-0131860612

More Books

Students also viewed these Mathematics questions