Optimization Modeling with Spreadsheets

• Main Author: Baker, Kenneth R. 1943- (Author)
• Format: Book
• Language: English
• Published: Belmont, CA Thomson Brooks/Cole 2006
• Series: Duxbury applied series
• Subjects: Programming (Mathematics) > Mathematical models; Electronic spreadsheets; Mathematical optimization; Managerial economics > Mathematical models
• Online Access: Click Here to View Status and Holdings.
• Item Description: Includes index
• Physical Description: xiv, 353 pages illustrations 25 cm 1 CD-ROM (4 3/4 in.)
• ISBN: 9780534494742; 0534494749

Thoroughly updated to reflect the latest topical and technical advances in the field, Optimisation Modelling with Spreadsheets, Second Edition, continues to focus on solving real-world optimisation problems through the creation of mathematical models and the use of spreadsheets to represent and analyse those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimisation tools effectively without the need to rely on specialised algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimisation, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasises the use of spreadsheet-based optimisation tools