How do I calculate maximum with variables.
 

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,

How do I calculate maximum with variables.
 

You can certainly do this with Excel's Solver tool!
See these links for information:
http://www.vertex42.com/ExcelArticle...-examples.html
http://support.microsoft.com/kb/843304

Regards,
Ryan---

--
RyGuy


"DanASU" wrote:

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,

How do I calculate maximum with variables.
 

Excel is not needed

Because x generates more money per unit than y, just maximize x.

Therefore x=200
y=75
tota value=11875

--
Gary''s Student - gsnu200791


"DanASU" wrote:

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,

How do I calculate maximum with variables.
 

Thank you for the advice. It seems that this is more complicated than I
originally anticipated, but I think I should be able to get it now.
"ryguy7272" wrote:

You can certainly do this with Excel's Solver tool!
See these links for information:
http://www.vertex42.com/ExcelArticle...-examples.html
http://support.microsoft.com/kb/843304

Regards,
Ryan---

--
RyGuy


"DanASU" wrote:

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,