The AIMMS Optimization Modeling book provides not only an introduction to modeling but also a suite of worked examples. It is aimed at users who are new to modeling and those who have limited modeling experience. Both the basic concepts of optimization modeling and more advanced modeling techniques are discussed. The Optimization Modeling book is AIMMS version independent.
Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models 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 analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, 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 emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features: Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models Network models that allow for a more general form of mass balance A systematic introduction to Data Envelopment Analysis (DEA) The identification of qualitative patterns in order to meaningfully interpret linear programming solutions An introduction to stochastic programming and the use of RSP to solve problems of this type Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office® Excel files to accompany the figures and data sets in the book. With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.
Although a useful and important tool, the potential of mathematical modelling for decision making is often neglected. Considered an art by many and weird science by some, modelling is not as widely appreciated in problem solving and decision making as perhaps it should be. And although many operations research, management science, and optimization
This unique book describes how the General Algebraic Modeling System (GAMS) can be used to solve various power system operation and planning optimization problems. This book is the first of its kind to provide readers with a comprehensive reference that includes the solution codes for basic/advanced power system optimization problems in GAMS, a computationally efficient tool for analyzing optimization problems in power and energy systems. The book covers theoretical background as well as the application examples and test case studies. It is a suitable reference for dedicated and general audiences including power system professionals as well as researchers and developers from the energy sector and electrical power engineering community and will be helpful to undergraduate and graduate students.
This book provides a complete and comprehensive reference/guide to Pyomo (Python Optimization Modeling Objects) for both beginning and advanced modelers, including students at the undergraduate and graduate levels, academic researchers, and practitioners. The text illustrates the breadth of the modeling and analysis capabilities that are supported by the software and support of complex real-world applications. Pyomo is an open source software package for formulating and solving large-scale optimization and operations research problems. The text begins with a tutorial on simple linear and integer programming models. A detailed reference of Pyomo's modeling components is illustrated with extensive examples, including a discussion of how to load data from data sources like spreadsheets and databases. Chapters describing advanced modeling capabilities for nonlinear and stochastic optimization are also included. The Pyomo software provides familiar modeling features within Python, a powerful dynamic programming language that has a very clear, readable syntax and intuitive object orientation. Pyomo includes Python classes for defining sparse sets, parameters, and variables, which can be used to formulate algebraic expressions that define objectives and constraints. Moreover, Pyomo can be used from a command-line interface and within Python's interactive command environment, which makes it easy to create Pyomo models, apply a variety of optimizers, and examine solutions. The software supports a different modeling approach than commercial AML (Algebraic Modeling Languages) tools, and is designed for flexibility, extensibility, portability, and maintainability but also maintains the central ideas in modern AMLs.
This concise text contains the most commonly-encountered examination problems in the topic of Optimization Models and Methods, an important module in engineering and other disciplines where there exists an increasing need to operate optimally and sustainably under constraints, such as tighter resource availability, environmental consideration, and cost pressures. This book is comprehensive in coverage as it includes a diverse spectrum of problems from numerical open-ended questions that probe creative thinking to the relation of concepts to realistic settings. The book adopts many examples of design scenarios as context for curating sample problems. This will help students relate desktop problem-solving to tackling real-world problems. Succinct yet rigorous, with over a 100 pages of problems and corresponding worked solutions presented in detail, the book is ideal for students of engineering, applied science, and market analysis.
A reprint of one of the classic volumes on portfolio theory and investment, this book has been used by the leading professors at universities such as Stanford, Berkeley, and Carnegie-Mellon. It contains five parts, each with a review of the literature and about 150 pages of computational and review exercises and further in-depth, challenging problems.Frequently referenced and highly usable, the material remains as fresh and relevant for a portfolio theory course as ever.
Basic text on deterministic optimization methods. Techniques of modeling real world decision making problems, modeling examples that illustrate the use of modeling techniques, and a variety of problem classes are presented. Various types of algorithms with explanations of how each algorithm works and what conclusion can be drawn from its output, and a review of Matrix Algebra and Geometry and a chapter on Heuristic Methods.
This book offers a state-of-the-art introduction to the mathematical theory of supply chain networks, focusing on those described by partial differential equations. The authors discuss modeling of complex supply networks as well as their mathematical theory, explore modeling, simulation, and optimization of some of the discussed models, and present analytical and numerical results on optimization problems. Real-world examples are given to demonstrate the applicability of the presented approaches. Graduate students and researchers who are interested in the theory of supply chain networks described by partial differential equations will find this book useful. It can also be used in advanced graduate-level courses on modeling of physical phenomena as well as introductory courses on supply chain theory.