Baker K.R. Optimization Modeling with Spreadsheets

Baker K.R. Optimization Modeling with Spreadsheets
  • разное
  • pdf
  • 11.14 МБ
  • добавлен 07.12.2011
Wiley | 2011 | ISBN: 0470928638 | 432 pages
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.

Смотрите также


Powell S.G., Baker K.R. Management Science: The Art of Modeling with Spreadsheets

Powell S.G., Baker K.R. Management Science: The Art of Modeling with Spreadsheets

  • разное
  • pdf
  • 15.96 МБ
  • добавлен 07.12.2011
Wiley | 2010 | ISBN: 0470530677 | 528 pages
Now in its third edition, Management Science helps business professionals gain the essential skills needed to develop real expertise in business modeling. The biggest change in the text is the conversion of software from Crystal Ball to Risk Solver to reflect changes in the field. ...
Luptacik M. Mathematical Optimization and Economic Analysis

Luptacik M. Mathematical Optimization and Economic Analysis

  • разное
  • pdf
  • 1.61 МБ
  • добавлен 09.01.2012
Springer | 2009 | ISBN: 0387895515 | 294 pages
"Mathematical Optimization and Economic Analysis" is a self-contained introduction to various optimization techniques used in economic modeling and analysis such as geometric, linear, and convex programming and data envelopment analysis. Through a systematic approach, this book...
Hendrix E.M.T. Introduction to Nonlinear and Global Optimization

Hendrix E.M.T. Introduction to Nonlinear and Global Optimization

  • разное
  • pdf
  • 5.6 МБ
  • добавлен 05.02.2012
Springer – 2010, 208 pages
ISBN: 0387886699

Nonlinear Optimization is an intriguing area of study where mathematical theory, algorithms and applications converge to calculate the optimal values of continuous functions. Within this subject, Global Optimization aims at finding global optima for difficult problems in w...
Platen E., Heath D. A Benchmark Approach to Quantitative Finance

Platen E., Heath D. A Benchmark Approach to Quantitative Finance

  • разное
  • pdf
  • 11.69 МБ
  • добавлен 02.02.2012
Springer – 2009, 702 pages
ISBN: 3540262121

The benchmark approach provides a general framework for financial market modeling, which extends beyond the standard risk-neutral pricing theory. It permits a unified treatment of portfolio optimization, derivative pricing, integrated risk management and insurance risk mod...
Appa G.M., Pitsoulis L., Williams H.P. (Eds.) Handbook on Modelling for Discrete Optimization

Appa G.M., Pitsoulis L., Williams H.P. (Eds.) Handbook on Modelling for Discrete Optimization

  • разное
  • pdf
  • 14.93 МБ
  • добавлен 05.02.2012
Springer – 2006, 434 pages
ISBN 9780387329413

The primary objective underlying the Handbook on Modelling for Discrete Optimization is to demonstrate and detail the pervasive nature of Discrete Optimization. While its applications cut across an incredibly wide range of activities, many of the applications are only kn...
Chinchuluun A. et al Optimization and Optimal Control: Theory and Applications

Chinchuluun A. et al Optimization and Optimal Control: Theory and Applications

  • разное
  • pdf
  • 3.3 МБ
  • добавлен 05.02.2012
Sрringer – 2010, 510 pages
ISBN: 0387894950

Optimization and optimal control are the main tools in decision making. Because of their numerous applications in various disciplines, research in these areas is accelerating at a rapid pace. Optimization and Optimal Control: Theory and Applications brings together the lat...
Castillo E.D. Process Optimization: A Statistical Approach

Castillo E.D. Process Optimization: A Statistical Approach

  • разное
  • pdf
  • 13.34 МБ
  • добавлен 05.02.2012
Springer – 2007, 462 pages
ISBN 9780387714349

A Statistical Approach is a textbook for a course in experimental optimization techniques for industrial production processes and other "noisy" systems where the main emphasis is process optimization. The book can also be used as a reference text by Industrial, Quality a...
Zhu J. Quantitative Models for Performance Evaluation and Benchmarking: Data Envelopment Analysis with Spreadsheets

Zhu J. Quantitative Models for Performance Evaluation and Benchmarking: Data Envelopment Analysis with Spreadsheets

  • разное
  • pdf
  • 13.22 МБ
  • добавлен 21.07.2010
Springer | English | 2008 | ISBN: 0387859810 | 334 pages |
It is difficult to evaluate an organization's performance when there are multiple inputs and multiple outputs to the system. The difficulties are further enhanced when the relationships between the inputs and the outputs are complex and involve unknown tradeoffs. Thi...
Chen C.-H., Lee L.H. Stochastic Simulation Optimization: An Optimal Computing Budget Allocation

Chen C.-H., Lee L.H. Stochastic Simulation Optimization: An Optimal Computing Budget Allocation

  • разное
  • pdf
  • 2.07 МБ
  • добавлен 28.01.2012
World Scientific Publishing Co. Pte. Ltd. – 2010, 248 pages
ISBN: 9814282642

With the advance of new computing technology, simulation is becoming very popular for designing large, complex and stochastic engineering systems, since closed-form analytical solutions generally do not exist for such problems. However, the...
Gregoriou G.N., Hoppe C., When C.S. (Eds.) The Risk Modeling Evaluation Handbook: Rethinking Financial Risk Management Methodologies in the Global Capital Markets

Gregoriou G.N., Hoppe C., When C.S. (Eds.) The Risk Modeling Evaluation Handbook: Rethinking Financial Risk Management Methodologies in the Global Capital Markets

  • разное
  • pdf
  • 3.33 МБ
  • добавлен 02.02.2012
The McGraw-Hill Companies – 2010, 528 pages
ISBN: 0071663703

If we have learned anything from the global financial collapse of 2008, it is this: the mathematical risk models currently used by financial institutions are no longer adequate quantitative measures of risk exposure.
In The Risk Modeling Evaluation Han...