The MBA program at State University has approximately 260 incoming students each fall semester. These students are divided into cohorts of approximately 65 students each, and the students in each...

The MBA program at State University has approximately 260 incoming students each fall semester. These students are divided into cohorts of approximately 65 students each, and the students in each cohort sit through exactly the same set of fall courses together. Much of the work in these courses is done in teams. To ensure that the teams are comparable, the MBA Office tries to divide the students in each cohort into 14 teams so that each team has the following qualities:

■ Four or five members


■ At least one member with a CPA


■ At least one member with quantitative expertise


■ At least one female


■ At least one minority student


■ At least one international student

The file MBA Teams.xlsx indicates the characteristics of the students in a particular cohort of this year’s incoming class. Your job is to use the Evolutionary Solver to see if you can create teams that have all of the desired properties. It is not clear whether this will be possible—for example, there might not be enough minority students to go around—so you should create penalties for failing to meet the various goals, where the penalties can be different for different goals. ■