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: It should have four or five members. ● ● ● ● ● It should have at least one member with a CPA. It should have at least one member with quantitative expertise. It should have at least one woman. It should have at least one minority student. It should have at least one international student. The file 06 mba teams data.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.
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: It should have four or five members. ● ● ● ● ● It should have at least one member with a CPA. It should have at least one member with quantitative expertise. It should have at least one woman. It should have at least one minority student. It should have at least one international student. The file 06 mba teams data.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.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
The relevant excel data will be in a picture below.
Transcribed Image Text: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:
It should have four or five members.
It should have at least one member with a CPA.
It should have at least one member
It should have at least one woman.
It should have at least one minority student.
● It should have at least one international student.
●
●
●
●
with quantitative expertise.
The file 06 mba teams data.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.
Transcribed Image Text:0
z
「
天
7
to 0-1 variables
0
白河
00000
0-000
-25· no1040
224723
283
33444444444440004402034000000400408046
po己
81832888988
▬▬▬▬▬▬▬
2022320304044444
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 12 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education