|
Hi ! Who Knows How To Use The Solver Tool From Excel ?
|
View this Thread in Original format
| djzero2k |
Hi !!! Guys !!! :D
How's all ?. Hope that fine...
Wanted to know how to use the solver tool to solve some symplex method problems... I have been looking for ages some instructions... But they don't seem to be on the web or that's what I think...
Well If u know... Pls Let me know !!! :=)
Love Electronic & Gospel ! |
|
|
| butterfly |
| i used the solver when i was in college... what is the problem? |
|
|
| djzero2k |
| Maybe I don't know how to input the objective function and all the restrictions but... I am seeing right now... I'll let u know coz this seems difficult ! :=) |
|
|
| djzero2k |
| It's seems pretty easy... The problem is that the pc doesn't have the solver tool... So I'll have to wait another time when I go to another cyber... Thankx !!! |
|
|
| Kaz |
| quote: | Originally posted by djzero2k
It's seems pretty easy... The problem is that the pc doesn't have the solver tool... |
Yeah that could be a problem. LOL |
|
|
| djzero2k |
Ok !!! It doesn't seem too easy !! :D
Here are some doubts...
1> When I have a symplex problem and all the restrictions are =<, how I can minimize it ?. Coz the Cj-Zj spaces have only negative values...
2> When I have:
Min Z: 2x + 3y
Am I suposse to multiply the objective function by -1 ?.
Can u show me how would it be graphically in a table ?.
3> How do u interpret an not limited problem ?. The one that the variable decision can assume unlimited values, as long as the difference between the values is 2 for ex ?.
OOOOH By the way... I have the exam tomorrow !!! :(
"Operative Investigation" !!! :( |
|
|
| djzero2k |
Ok... I have just gave my written exam...
You are let say a consultor and you have to recommend a company it's production level... The objective function and the restrictions are these:
Objective Function => Max Z: 1205X1 + 2545X2
Restrictions => X1 + X2 =< 750
=> 24X1 + 18X2 =< 24400
And Ooops what a dumb !!! I forgot it !!!
:(
I'll try to remember ! |
|
|
| paranoik0 |
i'm taking that class too hehe
sounds like a fairly easy problem though?
last year (i reproved) my teacher talked about this program that solved all the stuff automatically called LINDO. try searching for it. |
|
|
| djzero2k |
Hi Guys !!! At last, my professor lent me the page with the problem... The thing is, that it is in Spanish... So... It's very difficult to translate it for me... Sorry.... Anyway here is it...
A La Gerencia De Planeamiento...
Se pide el plan de produccion para optimizar el beneficio neto obtenido en base a la fabricación de bombas hidraúlicas y neumáticas, sabiendo que el precio de venta de cada una de estas es de $1900 y $2350 respectivamente. En cada una de estas, se utiliza un cilindro de succión, disponiéndose en total de 650 cilindros costando $75 cada uno. La cantidad de horas de montaje necesarias para cada bomba es de 0.3 y de 0.4 respectivamente, costando $250 la hora y habiendo 1700 horas de montaje. Por otro lado, es necesario salir al mercado con por lo menos 20 embarques, pudiendo cada embarque armarse con 12 bombas hidraúlicas o 18 bombas naumáticas. El resto de los costos de materia prima para cada una es de $350 para las bombas hidraúlicas y y $190 para las bombas naumáticas...
Proporcionar un informa y el plan de producción...
Hope someone knows english, if no Ii'll try to translate (:eyes: ) |
|
|
|
|
