Sale!

Optimization Modeling with Spreadsheets

Amazon.com Price:  $73.30 (as of 12/05/2019 20:12 PST- Details)

Description

An accessible introduction to optimization analysis the use of 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 to be had Microsoft® Place of business 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 in addition to a systematic framework that illuminates the common structures found in many successful models. With focused coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:

  • An emphasis on model building the use of Excel Solver in addition to appendices with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver
  • Additional space devoted to formulation principles and model building versus 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 assist 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 a very good textbook for upper-undergraduate and graduate-level courses that come with deterministic models, optimization, spreadsheet modeling, quantitative methods, engineering management, engineering modeling, operations research, and management science. The book is a perfect reference for readers wishing to advance their knowledge of Excel and modeling and may be a useful guide for MBA students and modeling practitioners in business and non-profit sectors interested in spreadsheet optimization.


Recent Products