Ratios with excel solver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In excel solver (2003) how do you enter a ratio? I assume it would require
entering an inequality, but I don't really know how this would work.
What I am trying to do:
Production of item A and item B must have between a 5:1 to 10:1 ratio.
(between 5-10 of product A for every product B)
 
arspiffyblue;

What are you trying to accomplish. Are you trying to verify if the ratio is
correct? Are you trying to adjust the total to match the ratio? Are you
trying to determine the days production ratio? I'm an idjut. Sorry. What
purpose does the solver serve?

I found something called solvsamp.xls on my hardrive. I would suggest you
search for this. It seems to be of interest to what you are trying to do. If
you can give more detail, you might not need this if you write your functions
and formulas correct.

God Bless

Frank Pytel
 
Hi. Here's one way: Your statement...

5< a/b <10

Multiply by 'b'
Trick is to make sure 'b is positive, otherwise the inequality might change.

5*b < a < 10*b

With Solver, it's best not to have a variable on the right-hand side.
I'd would add the two constraints like this.

a - 5*b >= 0
10*b - a >= 0

Good luck.
 
Back
Top