Question: 2. Stacey is forming a team to develop a new product for her company. To ensure that her team incorporates a diverse range of

65710772. Stacey is forming a team to develop a new product for her company. To ensure that her teamincorporates a div

2. Stacey is forming a team to develop a new product for her company. To ensure that her team incorporates a diverse range of viewpoints, she has been allowed to select team members from across three departments. After speaking with several other managers, Stacey has identified 10 potential team members: Name Alvin Bernie Carlos Department Years Marketing Accounting 4 Engineering 5 Marketing Engineering 3 Marketing Accounting Accounting Marketing Engineering 6 Gender Male Female Male Commitment 6 5 9 6. Drew 10 Male Elena Female 7. Fiona 8 Female 10 Guillaume Male Hilda Isabel 7 Female 5 4 Female 7. Jing Female 9 The Commitment score for each person is Stacey's estimate, on a scale of 1-10, of how committed the person would be to the project. The "Years" column shows how many years of experience the person has. Using the three steps, formulate an optimization model using binary decision variables to help Stacey form a team that will maximize the total commitment level subject to the follow constraints: Make sure to include type of constraint (k out of n, conditional, etc.! The team must have exactly five members. The team must have at least one member from each of the three departments (Marketing, Engineering, and Accounting). The average of the number of years of experience of the team members must be at least 6. The team must have at least two women. The team must have at least two men. If Jling is chosen for the team, Guillaume must also be chosen. Bernie and Hilda can't both be chosen. Alvin and Drew must either both be chosen or both left off.

Step by Step Solution

3.40 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Step1 decide the decision variables J1 if person i selected for the team l0if person ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!