In this book, Professor Roy Nersesian examines a wide range of common business problems that require an optimal solution, yet where no linearity exists. That is, he tackles problems that cannot accurately be solved using Excel’s Solver or other traditional linear optimization tools. Instead, Prof. Nersesian leverages the power of Evolver’s unique genetic algorithms to address issues ranging from managing a stock portfolio to the timing of new plants. The book also comes with detailed example spreadsheets you can use and modify to meet your company’s particular needs.

Topics covered include:

• Project management
• Managing a loan portfolio
• Managing a stock portfolio
• Materials requirements and planning
• Job shop and production floor scheduling
• Production planning
• Curve fitting for plant loading
• Warehouse location planning
• Multi-rate shipping and inter-warehouse exchanges
• Assigning shipments to trucks
• Scheduling trains to station stops
• Assigning routes
• New plant sizing and timing
• Pricing models
• Assessing unit costs
• Determining a royalty and tax structure
• …And more!