Login

Baker, Kenneth R.

Optimization Modeling with Spreadsheets

Baker, Kenneth R. - Optimization Modeling with Spreadsheets, ebook

119,30€

Ebook, ePUB with Adobe DRM
ISBN: 9781118937730
DRM Restrictions

Printing118 pages with an additional page accrued every 7 hours, capped at 118 pages
Copy to clipboard5 excerpts

An accessible introduction to optimization analysis using spreadsheets

Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes model-building skills in optimization analysis. By emphasizing both spreadsheet modeling and optimization tools in the freely available Microsoft® Office Excel® Solver, the book illustrates how to find solutions to real-world optimization problems without needing additional specialized software.

The Third Edition includes many practical applications of optimization models as well as a systematic framework that illuminates the common structures found in many successful models. With focused coverageon linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:

  • An emphasis on model building using ExcelSolver as well as an appendix with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver
  • Additional space devoted to formulation principles and model building as opposed to algorithms
  • New end-of-chapter homework exercises specifically for novice model builders
  • Presentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver
  • Classification of problem types to help readers see the broader possibilities for application
  • Specific chapters devoted to network models and data envelopment analysis
  • A companion website with interactive spreadsheets and supplementary homework exercises for additional practice

Optimization Modeling with Spreadsheets, Third Edition
is an excellent textbook for upper-undergraduate and graduate-level courses that include deterministic models, optimization, spreadsheet modeling, quantitative methods, engineering management, engineering modeling, operations research, and management science. The book is an ideal reference for readers wishing to advance their knowledge of Excel and modeling and is also a useful guide for MBA students and modeling practitioners in business and non-profit sectors interested in spreadsheet optimization.

Keywords:

optimization, operations research, Microsoft Office Excel, mathematical modeling, deterministic models, spreadsheet modeling, engineering, management science, mathematical programming, software applications, spreadsheet optimization, spreadsheet engineering, model building, optimization analysis, Excel Solver

,

optimization, operations research, Microsoft Office Excel, mathematical modeling, deterministic models, spreadsheet modeling, engineering, management science, mathematical programming, software applications, spreadsheet optimization, spreadsheet engineering, model building, optimization analysis, Excel Solver

,

optimization, operations research, Microsoft Office Excel, mathematical modeling, deterministic models, spreadsheet modeling, engineering, management science, mathematical programming, software applications, spreadsheet optimization, spreadsheet engineering, model building, optimization analysis, Excel Solver

, Management Science / Operations Research
Author(s)
Publisher
John Wiley and Sons, Inc.
Publication year
2016
Language
en
Edition
3
Page amount
392 pages
Category
Technology, Energy, Traffic
Format
Ebook
eISBN (ePUB)
9781118937730
Printed ISBN
9781118937693

Similar titles