He/she must have strong knowledge in the below topics and in using the excel(solver, open solver,data tables ,decision trees...)to solve problems related to the below subjects. 1)Linear programming 2)Integer programming 3)Non linear programming 4)Simulation 5)Queuing 6)Decision making under uncertainty 7)Decision Trees
I am surveying different types of transportation trip analysis's. I need someone who is good with excel who can take my data I have surveyed and transform it into a relational model with a Unit Cost and then constraints. The constraints i have provided in the excel attachment
all the objectives, details and data are given in the uploaded files . the problem should be solved using GAMS only , any other solver such as matlab is not acceptable. the solution should be in word file with all the steps and constraints that used. good luck.