I am trying to solve an LP problem in SQL(database language). I was not able to find the step by step solution for the same in order to implememt it in the computer. For example cosider the following
Maximize 25x1+ 30x2
Subject to (1/200)x1 + (1/140)x2 ≤ 40
x1 <= 6000;
X2 <= 4000;
I know the answer is x1=6000 and x2=1400;
But everywhere it is solved either by using some graphs or by some mothods that requires rational thinking.those are not useful for me as I cannot stimulate it in SQL. Can any body provide the step by step method for finding the value of x1 and x2.
Thanks in Adavnce,