Hi Rob, Thanks for your quick reply, Indeed I forgot to mention lot of things. Apologies for creating confusion. Here is the updated table mentioned below:- 1 2 3 S.No. Var1 Var2 Var3 Var4 Var5 Var6 SUM_P No_of_People Total Price 1 0 1 0 0.2000 0.2500 0.9900 0.2500 2 1 30 2 1 0 0 0.1000 0.2000 0.9000 0.1000 1 1 77 3 1 0 0 0.1500 0.2500 0.9500 0.1500 1 1 99 4 0 0 1 0.2500 0.3500 0.9500 0.9500 3 1 26 5 0 1 0 0.3500 0.4500 0.9900 0.4500 2 1 49 So column "No_of_people" is the sumproduct of var1,var2 & var3 with values 1,2 & 3. SUM_P is also the sumproduct between va1 , var2, var3 & var4,var5,var6. Now I mentioned about <=100, that is one of my constraint for column "No_of_people". So sum(No_of_people) <=100. I have mentioned corrected objective function below:- Maximize Objective function: SUMPRODUCT(SUM_P, Price)/SUM(Price) Constraint 1:- sum(No_of_people) <=100 Constraint 2: SUM of all the three decision variables (Total column) should be equal to 1 for each row. (e.g any one of the decision variable can take value as 1 rest decision vars have to be 0) Constraint 3: Var1,Var2 & Var3 can take only binary values. Var4,Var5 & Var6 are the constant values. I hope this time it is clear that objective functions depends on SUM_P which is the sumproduct between var1,var2,var3 & var4,var5,var6. Thanks! Kishore
... View more