HI

If someone knows this, pls help me . I am trying to use SOLVER to solve
the problem:

Ex: I have 8 products . Each of them need a different litre milk to
produce. We just have maximum 18,000,000 litre. I wanna have maximum
profit within my capacity.

I did like folowing pattern

Sale = quantity X price
varialle cost = quantiy X varibale cost per unit
Fixed cost = number
Input = quantity X milk required per unit

Profit = sale- total variable cost (8 items)- fixed cost(8 items)

My target cell: profit
My adjustatble celss: range of number for sale
contrainst that sum of input for 8 items <= 18,000,000

I put all formular in all cells.

After running , i shows only one item that should use all 18,000,000
litre of milk.

I dont know what happened/
Any body knows this, pls pls pls help me ?
Thanks


--
smallsun
------------------------------------------------------------------------
smallsun's Profile: http://www.excelforum.com/member.php...o&userid=23117
View this thread: http://www.excelforum.com/showthread...hreadid=373835