if i use solver find the Maximization of net profit which is from factor that
generate by RAND()
e.g the sales is randomly generated with rand(), the changing cell is the
number of produce
then the net profit is affected by the rand() and solver couldnt solve it
out ...
is there any suggestion to solve this problem ?

Or is there anyway to lock those random number [ rand() ]

Please help!!!!