Linear programming, CPLEX OPL Model Case

profileMaryam44
WedPlanner_DateSet.xlsx

Input

number of guests 15
number of tables 3
table capacity 5
pref matrix guest1 guest2 guest3 guest4 guest5 guest6 guest7 guest8 guest9 guest10 guest11 guest12 guest13 guest14 guest15
guest1 I I I I A I X X I I X I X A I
guest2 I I A A X A A I A I I X I A I
guest3 I I I I A I I X A A I I I A I
guest4 I A I I I I A I A A I A A I A
guest5 A X X I I X I A I A I I A I A
guest6 I I X I I I I I X X A X A I I
guest7 X X I A I A I I X A I X X I X
guest8 I I I I A I A I A X I X A A A
guest9 I I A X I I X A I A A A I I X
guest10 I A I X I A X A I I A I I A I
guest11 A I X A I A A I I A I I X I A
guest12 A I A I A I I X A A A I A A X
guest13 I I X A I A I I I I A I I I I
guest14 A I X X A I X X A I I A I I A
guest15 I X X X A I I A I I I I I I I