Optimization Modeling with Spreadsheets

Nonfiction, Science & Nature, Technology, Engineering, Industrial, Business & Finance, Management & Leadership, Management Science, Management
Cover of the book Optimization Modeling with Spreadsheets by Kenneth R. Baker, Wiley
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Kenneth R. Baker ISBN: 9781118937730
Publisher: Wiley Publication: June 15, 2015
Imprint: Wiley Language: English
Author: Kenneth R. Baker
ISBN: 9781118937730
Publisher: Wiley
Publication: June 15, 2015
Imprint: Wiley
Language: English

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 coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:

  • An emphasis on model building using Excel Solver as well as appendices 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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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 coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, Optimization Modeling with Spreadsheets, Third Edition features:

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.

More books from Wiley

Cover of the book Cities in Relations by Kenneth R. Baker
Cover of the book Introduction to Statistics Through Resampling Methods and R by Kenneth R. Baker
Cover of the book Radionuclides in the Environment by Kenneth R. Baker
Cover of the book Models and Analysis for Distributed Systems by Kenneth R. Baker
Cover of the book How to Be the Employee Your Company Can't Live Without by Kenneth R. Baker
Cover of the book Teacher's Skills Tests For Dummies by Kenneth R. Baker
Cover of the book The Crowd Funding Services Handbook by Kenneth R. Baker
Cover of the book Cognitive Interviewing Methodology by Kenneth R. Baker
Cover of the book Pension Revolution by Kenneth R. Baker
Cover of the book Office Home and Student 2010 All-in-One For Dummies by Kenneth R. Baker
Cover of the book Introduction to Strategies for Organic Synthesis by Kenneth R. Baker
Cover of the book Managing Foundations and Charitable Trusts by Kenneth R. Baker
Cover of the book A Practical Guide to the Histology of the Mouse by Kenneth R. Baker
Cover of the book Sustainable Steel Buildings by Kenneth R. Baker
Cover of the book China and Russia by Kenneth R. Baker
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy