Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Solver "returns no value". Please help
I put a model together. I added all the constraints accordingly. I run
solver and I expect to maximize the "net profit", but for whatever reason no result is returned. I attempt to input manually 'reasonable' numbers to change cells (the yellow ones) and the logic seems to work OK. Can someone please tell me why Solver doesn't return values as it should ? Please find attached spreadsheet. |
#2
|
|||
|
|||
All I am trying to do is maximize profits by determining the "quantity" of
products I need t produce and "how many employees" to hire. "Marlon Brown" wrote in message ... I put a model together. I added all the constraints accordingly. I run solver and I expect to maximize the "net profit", but for whatever reason no result is returned. I attempt to input manually 'reasonable' numbers to change cells (the yellow ones) and the logic seems to work OK. Can someone please tell me why Solver doesn't return values as it should ? Please find attached spreadsheet. |
#3
|
|||
|
|||
Marlon,
The starting values in the variable cells can affect the solution. Solver might fail to find a solution or it might time out before reaching a solution. Enter values in variable cells that fall close to what you believe the final values will be. If Solver still reaches its iteration limit without arriving at a solution, you can adjust the starting values and restart or click Continue to use the maximum solution time. ---- Regards, John Mansfield http://www.pdbook.com "Marlon Brown" wrote: All I am trying to do is maximize profits by determining the "quantity" of products I need t produce and "how many employees" to hire. "Marlon Brown" wrote in message ... I put a model together. I added all the constraints accordingly. I run solver and I expect to maximize the "net profit", but for whatever reason no result is returned. I attempt to input manually 'reasonable' numbers to change cells (the yellow ones) and the logic seems to work OK. Can someone please tell me why Solver doesn't return values as it should ? Please find attached spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Solver Table missing in Data Menu of Excel2003. Where is it? | Excel Worksheet Functions |