Optimization Modeling with Spreadsheets

Author: Kenneth R. Baker
Publisher: John Wiley & Sons
ISBN: 1118008979
Release Date: 2012-01-10
Genre: Business & Economics

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.

Optimization Modeling with Spreadsheets

Author: Kenneth R. Baker
Publisher: John Wiley & Sons
ISBN: 9781118937730
Release Date: 2015-06-15
Genre: Business & Economics

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.

Optimization Modeling with Spreadsheets

Author: Kenneth R. Baker
Publisher: John Wiley & Sons
ISBN: 9781118937709
Release Date: 2015-06-15
Genre: Business & Economics

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.

Optimization Modeling with Spreadsheets

Author: Baker
Publisher: Thomson Brooks/Cole
ISBN: 0495108154
Release Date: 2005-09-21
Genre: Electronic spreadsheets

Spreadsheet-based introduction to mathematical programming concepts and applications, intended for undergraduate and graduate students in management and engineering. Its emphasis on model building and its focus on formulation principles are key features that reinforce its practical approach. The text also includes a comprehensive tutorial on the use of Excel’s Solver, and, at a more advanced level, Frontline Systems’ Premium Solver.

Management Science The Art of Modeling with Spreadsheets 4th Edition

Author: Stephen G. Powell
Publisher: Wiley Global Education
ISBN: 9781118801277
Release Date: 2013-09-24
Genre: Business & Economics

Management Science provides students and business analysts with the technical knowledge and skill needed to develop real expertise in business modeling. The authors cover spreadsheet engineering, management science, and the modeling craft. The text is designed to improve modeling efficiency and modeling effectiveness by focusing on the most important tasks and tools.

Pyomo Optimization Modeling in Python

Author: William E. Hart
Publisher: Springer Science & Business Media
ISBN: 9781461432265
Release Date: 2012-02-15
Genre: Mathematics

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.

Business Analytics The Art of Modeling With Spreadsheets 5th Edition

Author: Powell
Publisher: Wiley Global Education
ISBN: 9781119298311
Release Date: 2016-11-16
Genre: Business & Economics

Now in its fifth edition, Powell and Baker’s Business Analytics: The Art of Modeling with Spreadsheets provides students and business analysts with the technical knowledge and skill needed to develop real expertise in business modeling. In this book, the authors cover spreadsheet engineering, management science, and the modeling craft. The briefness & accessibility of this title offers opportunities to integrate other materials –such as cases -into the course. It can be used in any number of courses or departments where modeling is a key skill.

Data Analysis Optimization and Simulation Modeling

Author: S. Christian Albright
Publisher:
ISBN: 0538476761
Release Date: 2011
Genre: Decision making

DATA ANALYSIS, OPTIMIZATION, AND SIMULATION MODELING, 4e, International Edition is a teach-by-example approach, learner-friendly writing style, and complete Excel integration focusing on data analysis, modeling, and spreadsheet use in statistics and management science. The Premium Online Content Website (accessed by a unique code with every new book) includes links to the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, RISKOptimizer, NeuralTools, and Evolver); and SolverTable, allowing users to do sensitivity analysis. All of the add-ins is revised for Excel 2007 and notes about Excel 2010 are added where applicable.

Data Smart

Author: John W. Foreman
Publisher: John Wiley & Sons
ISBN: 9781118839867
Release Date: 2013-10-31
Genre: Business & Economics

Data Science gets thrown around in the press like it's magic. Major retailers are predicting everything from when their customers are pregnant to when they want a new pair of Chuck Taylors. It's a brave new world where seemingly meaningless data can be transformed into valuable insight to drive smart business decisions. But how does one exactly do data science? Do you have to hire one of these priests of the dark arts, the "data scientist," to extract this gold from your data? Nope. Data science is little more than using straight-forward steps to process raw data into actionable insight. And in Data Smart, author and data scientist John Foreman will show you how that's done within the familiar environment of a spreadsheet. Why a spreadsheet? It's comfortable! You get to look at the data every step of the way, building confidence as you learn the tricks of the trade. Plus, spreadsheets are a vendor-neutral place to learn data science without the hype. But don't let the Excel sheets fool you. This is a book for those serious about learning the analytic techniques, the math and the magic, behind big data. Each chapter will cover a different technique in a spreadsheet so you can follow along: Mathematical optimization, including non-linear programming and genetic algorithms Clustering via k-means, spherical k-means, and graph modularity Data mining in graphs, such as outlier detection Supervised AI through logistic regression, ensemble models, and bag-of-words models Forecasting, seasonal adjustments, and prediction intervals through monte carlo simulation Moving from spreadsheets into the R programming language You get your hands dirty as you work alongside John through each technique. But never fear, the topics are readily applicable and the author laces humor throughout. You'll even learn what a dead squirrel has to do with optimization modeling, which you no doubt are dying to know.

Modeling Analysis and Optimization of Process and Energy Systems

Author: F. Carl Knopf
Publisher: John Wiley & Sons
ISBN: 9781118121146
Release Date: 2011-12-14
Genre: Technology & Engineering

Energy costs impact the profitability of virtually all industrial processes. Stressing how plants use power, and how that power is actually generated, this book provides a clear and simple way to understand the energy usage in various processes, as well as methods for optimizing these processes using practical hands-on simulations and a unique approach that details solved problems utilizing actual plant data. Invaluable information offers a complete energy-saving approach essential for both the chemical and mechanical engineering curricula, as well as for practicing engineers.

Spreadsheet Modeling Decision Analysis A Practical Introduction to Business Analytics

Author: Cliff Ragsdale
Publisher: Cengage Learning
ISBN: 9781305947412
Release Date: 2016-12-05
Genre: Business & Economics

Written by an innovator in teaching spreadsheets and a highly regarded leader in business analytics, Cliff Ragsdale’s SPREADSHEET MODELING AND DECISION ANALYSIS: A PRACTICAL INTRODUCTION TO BUSINESS ANALYTICS, 8E helps readers master important spreadsheet and business analytics skills. Readers find everything needed to become proficient in today’s most widely used business analytics techniques using Microsoft Office Excel 2016. Learning to make effective decisions in today's business world takes training and experience. Author Cliff Ragsdale guides learners through the skills needed, using the latest Excel for Windows. Readers apply what they’ve learned to real business situations with step-by-step instructions and annotated screen images that make examples easy to follow. The World of Management Science sections further demonstrates how each topic applies to a real company. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Refinery Engineering

Author: Ai-Fu Chang
Publisher: John Wiley & Sons
ISBN: 9783527666850
Release Date: 2013-03-01
Genre: Technology & Engineering

A pioneering and comprehensive introduction to the complex subject of integrated refinery process simulation, using many of the tools and techniques currently employed in modern refineries. Adopting a systematic and practical approach, the authors include the theory, case studies and hands-on workshops, explaining how to work with real data. As a result, senior-level undergraduate and graduate students, as well as industrial engineers learn how to develop and use the latest computer models for the predictive modeling and optimization of integrated refinery processes. Additional material is available online providing relevant spreadsheets and simulation files for all the models and examples presented in the book.

Simulation and Optimization in Finance

Author: Dessislava A. Pachamanova
Publisher: John Wiley & Sons
ISBN: 0470882123
Release Date: 2010-09-23
Genre: Business & Economics

An introduction to the theory and practice of financial simulation and optimization In recent years, there has been a notable increase in the use of simulation and optimization methods in the financial industry. Applications include portfolio allocation, risk management, pricing, and capital budgeting under uncertainty. This accessible guide provides an introduction to the simulation and optimization techniques most widely used in finance, while at the same time offering background on the financial concepts in these applications. In addition, it clarifies difficult concepts in traditional models of uncertainty in finance, and teaches you how to build models with software. It does this by reviewing current simulation and optimization methodology-along with available software-and proceeds with portfolio risk management, modeling of random processes, pricing of financial derivatives, and real options applications. Contains a unique combination of finance theory and rigorous mathematical modeling emphasizing a hands-on approach through implementation with software Highlights not only classical applications, but also more recent developments, such as pricing of mortgage-backed securities Includes models and code in both spreadsheet-based software (@RISK, Solver, Evolver, VBA) and mathematical modeling software (MATLAB) Filled with in-depth insights and practical advice, Simulation and Optimization Modeling in Finance offers essential guidance on some of the most important topics in financial management.

Practical Management Science

Author: Wayne Winston
Publisher: Cengage Learning
ISBN: 9781111531317
Release Date: 2011-05-05
Genre: Business & Economics

This text takes an active-learning approach, providing numerous examples and problems so students can practice extensively with a concept before moving on. Four types of problems--skill-building, skill-extending, modeling, and cases--are graded within sections and chapters to help instructors assign homework. Another important feature is the way that the text integrates modeling into all functional areas of business: finance, marketing, operations management using real examples and real data. The text emphasizes modeling over algebraic formulations and memorization of particular models. Shell files are also provided so that instructors can give students as much or as little information as they need. This edition has been revised to be compatible with Excel 2010 and the corresponding add-ins for Excel 2010. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Managerial Decision Modeling with Spreadsheets

Author: Nagraj Balakrishnan
Publisher: Pearson Higher Ed
ISBN: 9780133071498
Release Date: 2012-03-05
Genre: Business & Economics

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Balakrishnan offers the perfect balance of the decision modeling process and the use of spreadsheets to set up and solve decision models. The third edition has been updated to reflect the latest version of Excel.