Modeling

[Deuce Sapp]

I have a worksheet that I am using to create a model environment. I have
five cells that contain percentages, a calculated cell that tells the output
of the model based on the percentages, another cell that has a maximum value
that the calculated cell should be and finally a cell that represents the
total cost. In other words, I am running five machines and the percentages
make up the load on each machine. When I change the percent values it is
showing me the output of the machines. The fixed amount is the highest
output I need. And the cost is the cost of running the machines at the
given loads.

What I am trying to figure out is if there is a way to have Excel go through
the permutations of possible percent values for the machine to result in the
maximum output needed, but result in the lowest cost.

Any ideas would be greatly appreciated.

 

[Niek Otten]

From your description, I find it difficult to understand whether you want to
vary just one variable, or more.
In the first case: have a look at Tools>Goal seek, in the second: try
Tools>Solver, which is a lot more sophisticated, and a lot more complex to
use.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Deuce Sapp]

Thanks...the "Solver" was definitely the way to go. I didn't have the
Add-In installed so I didn't see it until you brought it to my attention.