As rush coordinator for the Alpha Beta Chil (ABC) sorority, Kim Grant asked each pledge to identify five

As rush coordinator for the Alpha Beta Chil (ABC) sorority, Kim Grant asked each pledge to identify five existing members of ABC whom she would most like to have as a big sister. Kim then asked the pledges to rank order these potential big sisters from 5 down to 1, where 5 represents the person they most want as a big sister, 4 represents the next best choice, and so on. These rankings are summarized in the following table:

Big Sisters
Pledges 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
1 5 3 1 2 4
2 5 2 1 4 3
3 2 3 4 5 1
4 5 4 1 2 3
5 3 5 2 4 1
Kim knows that every pledge must be assigned a big sister, and each potential big sister can be assigned to no more than one pledge. Ideally, Kim wants to assign each pledge to the sister to whom she gave a ranking on 5. The sum of the rankings for such an assignment is 25 because each of the 5 pledges would be assigned to the big sister they ranked as number 5. But in the previous table, that would involve assigning pledges 2 and 4 to the same big sister, which is not allowable. Kim figures that the next best strategy is to determine the assignment that maximizes the sum of the rankings.

a. Create a spreadsheet model for Kim’s problem and solve it.

b. Which pledges should be assigned to which big sisters?

c. Can you think of another objective that Kim might use to solve her problem?

Complete Answer:

Get Instant Help in Homework Asap
Get Instant Help in Homework Asap
Calculate your paper price
Pages (550 words)
Approximate price: -
Open chat
1
Hello 👋
Thank you for choosing our assignment help service!
How can I help you?