Question: Question 1 The university is putting together three task forces to consider various changes to the governance structure of three faculties. A handful of members

Question 1 The university is putting together
Question 1 The university is putting together three task forces to consider various changes to the governance structure of three faculties. A handful of members have been pre- selected to form these teams and the university has tasked you with putting these three teams together. Each team should have each faculty represented and should be about equal in the average age of the group. In addition, each group must contain at least one member whose primary language 1s French and another whose primary language 1s English. Finally, due to interpersonal conflict on previous committees it is deemed prudent that Candidate 1 not be placed in the same group as Candidate 7. The information required is provided in the table below. Performance || [French [Science [33 | _ 6 [French | Engincering [62 | |7 |Bnglish |Engineering [35 | 8 | 54 English Provide the LP formulation for this problem and solve to provide the optimal solution. Submit an Excel file with your formulation together with an answer report. (Hint: try creating the objective as a goal program where the goal for each task force 1s to get the average age as close to the average age of all candidates.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 General Management Questions!