Multi-variable Equation Solving

T

Todd

I am trying to get Excel to find a solution to a 10
variable system of equations by supplying a range for one
variable. I work for a steel company and I am trying to
set up a spreadsheet calculating the cheapest option for
galvanizing steel at two different places with four
different size tanks and six different freight charges. I
have all 10 equations set up, but can't figure out how to
enter the variables in solver. I also need it to select a
minimun value for the range of numbers I give it. Two
variables in the below equations happen to be zero for
this particular problem:

x7 = 0
x10 = 0

x1 + x2 + x3 + x4 = 666.41

x5 + x6 + x7 = x8 + x9 + x10 = 666.41

x5 + x6 + x7 - x8 - x9 - x10 = 0

x1 + x2 - x3 - x4 = 0

x5 + x8 = 590.31

x6 + x9 = 76.1

x7 + x10 = 0

x1 + x2 - x5 -x6 - x7 = 0

x3 + x4 - x8 - x9 - x10 = 0

150x1 + 150x2 + 150x3 + 150x4 + 61.05x5 + 87.45x6 + 0x7 +
22.5x8 + 31.05x9 + 0x10 = ?

* To find a solution, I want the minimum value of '?' when
x1 = 0 to 666 in increments of 1.

Can anybody help me? I would really appreciate it.

Thanks,

Todd
 
K

Kevin Stecyk

Todd,

Is your email correct? I will try doing this on a spreadsheet and send you
the results.

Regards,
Kevin
 
K

Kevin Stecyk

Hi Todd,

I sent you a spreadsheet to your hotmail address.

It contains the solutions for X1 to X10 as well as your 1-666 iteration.

Be sure to look at the initial as well as the completed tabs of the
spreadsheet.

You should be on your way.

Regards,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top