Patience, it sometimes takes a while for these people to come up with
solutions.
I didn't find the calculus of this problem to be that difficult:
TC=$1*M+$1*L
Q=L^4*M^6
L=(Q*M^-6)^1/4: Assume L must be 0 so that negative root is ignored.
TC=$1*M+$1*(Q*M^-6)^1/4
Take derivative, set equal to 0, solve for M, then obtain L from 3rd
eqn, then check to make sure this represents a minimum.
Solver can obtain the same results, it's just a little more tedious,
because you either have to manually call solver for each row, or you
need to write a VBA Sub procedure that will loop through the rows and
call solver for you. Either way, the basic setup is:
L=(Q*M^-6)^1/4
M=initial guess for M
TC=$1*M+$1*L
Set solver to minimize TC by changing M.
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=510645