Optimization is a process for making something (as a design, system, or decision) as fully perfect, functional, or effective as possible using mathematical procedures such as as finding the maximum of a function or solve problems like :
This category of tools and add-ins enable you to solve tough problems with ease... all within the familiar Excel environment. Of all the tools you can combine with simulation, optimization is the one with the biggest bang for the buck.
Oracle Crystal Ball is the easiest way to perform Monte Carlo simulations in your own Excel spreadsheets and models. Crystal Ball automatically calculates thousands of different "what if" cases, revealing the range of possible outcomes, their probability