Optimization modeling with spreadsheets /

• Main Author: Baker, Kenneth R., 1943-
• Format: eBook
• Language: English
• Published: Hoboken, N.J. : Wiley, [2011]
• Edition: 2nd ed.
• Subjects: Mathematical optimization.; Managerial economics > Mathematical models.; Electronic spreadsheets.; Programming (Mathematics); Business.; Mathematics.; Computer science.; COMPUTERS > Desktop Applications > Spreadsheets.; Managerial economics / Mathematical models.; Electronic books.

"Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and...

Table of Contents:

• 1. Introduction to Spreadsheet Models for Optimization
• 2. Linear Programming: Allocation, Covering, and Blending Models
• 3. Linear Programming: Network Models
• 4. Sensitivity Analysis in Linear Programs
• 5. Linear Programming: Data Envelopment Analysis
• 6. Integer Programming: Binary Choice Models
• 7. Integer Programming: Logical Constraints
• 8. Nonlinear Programming
• 9. Heuristic Solutions with the Evolutionary Solver
• Appendices: 1. Optimization Software and Supplemental Files
• 2. Graphical Methods in Linear Programming
• 3. The Simplex Method
• 4. Stochastic Programming.