Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 preselected 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 is French and another whose primary language is English. Finally, due to interpersonal conflict on previous committees it is deemed prudent that Candidate not be placed in the same group as Candidate The information required is provided in the table below. Candidate Language Faculty Performance French Science English Science English Telfer English Telfer French Engineering French Engineering English Engineering French Telfer French Science French Telfer English Engineering French Science 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 is to get the average age as close to the average age of all candidates.
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 preselected 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 is French and another whose primary language is English. Finally, due to interpersonal conflict on previous committees it is deemed prudent that Candidate not be placed in the same group as Candidate The information required is provided in the table below.
Candidate Language Faculty Performance
French Science
English Science
English Telfer
English Telfer
French Engineering
French Engineering
English Engineering
French Telfer
French Science
French Telfer
English Engineering
French Science
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 is 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started