excell solver!!!!

[mavi]

I need ımmedıate help about excell solver. i have to solve a problem usıng excell solver but i dont have any idea how to use it . i have 45 minutes to solve a simple problem. is there any one who can help me?
ı would really appreciate!!!!

 

[patrickmuldoon99]

What is the problem you are trying to solve?

 

[Oaktree]

Hmm. You're not expecting us to take a test for you, are you?

 

[mavi]

i am tryıng to solve a mınımızatıon problem

 

[mavi]

i have the values but i can't put them into the formula and solve it by using solver.

 

[patrickmuldoon99]

right, is this for a test?

if not, post the minimization problem, and the variables along with conditions.

For guidance, you want to basically have a cell as your target cell, and in that replicate the formula for minimization by using cell references as variables. You can then tell solver to change these cell references that are acting as variables within certain conditions so as to optimize the minimum output generated by your formula....

make sense?

 

[mavi]

ok i am sending the title that the problem is written.

http://karagoz.ie.boun.edu.tr/moodle/file.php/48/capacited_loc.pdf

the values i choose is :

n=5
m=6
Dj=100000
Kj=20000
fi=1000
Cij=2000

 

[mavi]

can you understand the problem? can you help me?

 

[patrickmuldoon99]

I can't see the question as I am on a work computer and cannot download the european fonts required. any other way to get detail across?

 

[mavi]

ok i am sending the formula