I am very new to LP, Goal Seek, Decision Models etc and I have a multiple-objective decision making problem that may or may not require a mix of techniques although I am trying to solve it purely using LP + Excel Solver. I do not know where to begin.
I cross-posted it in math
Would it be easiest to sum each category first and then use that data? e.g. 22 females, 23 males, 20 Chinese, 13 British etc.
Is it correct to say the objective functions are to
maximise the diversity of members within groups and
minimise the average differences between groups? And the constraints are 1,2,3,4 below?
Students are often allocated into syndicate groups to work together on various projects, which are subsequently assessed as a group work. The groups formed should maximise the diversity of members within groups and minimise the average differences between groups.
The data provided contains the records for 45 students with the relevant characteristics for each one of them given through the five columns: Student ID (S), Nationality (N), Cultural Background (C), Gender (G) and Quantitative Background (Q).
Using any resources available to you, prepare a model that will be able to perform automatic allocation of students into groups while satisfying as much as possible these ideal targets:
- Groups should be of the same size if possible. The ideal size is 5 members per group.
- Groups should be balanced with respect to gender (G).
- Groups should be balanced with respect to quantitative background (Q).
- Groups should be balanced with respect to ethnic background in a very specific way. According to the most up-to-date research on harnessing cultural diversity: