Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All,
I have built a solver solution to optimally allocate marketing budget across 4 regions to optimise sales. The governing equations of sales as function of inputs are non-linear in nature (sales=ax^3+bx^2+cx). Is there any way I can check if the solver solution is indeed optimum? How will I prove that the solution is optimum? Can any body help please? Thanks, Regi |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do it by hand.
Regi wrote: Hello All, I have built a solver solution to optimally allocate marketing budget across 4 regions to optimise sales. The governing equations of sales as function of inputs are non-linear in nature (sales=ax^3+bx^2+cx). Is there any way I can check if the solver solution is indeed optimum? How will I prove that the solution is optimum? Can any body help please? Thanks, Regi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I save a solver solution in VBA | Excel Discussion (Misc queries) | |||
Using Solver - integer solution | Excel Discussion (Misc queries) | |||
Solver solution hessian | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Solver does not find correct solution??? | Excel Discussion (Misc queries) |