{"product_id":"optimization-modeling-with-spreadsheets-isbn-9781118937693","title":"Optimization Modeling with Spreadsheets","description":"\u003cp\u003e\u003cb\u003eAn accessible introduction to optimization analysis using spreadsheets\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUpdated and revised, \u003ci\u003eOptimization Modeling with Spreadsheets, Third Edition \u003c\/i\u003eemphasizes 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.\u003c\/p\u003e \u003cp\u003eThe \u003ci\u003eThird Edition \u003c\/i\u003eincludes 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, \u003ci\u003eOptimization Modeling with Spreadsheets, Third Edition \u003c\/i\u003efeatures:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAn 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\u003c\/li\u003e \u003cli\u003eAdditional space devoted to formulation principles and model building as opposed to algorithms\u003c\/li\u003e \u003cli\u003eNew end-of-chapter homework exercises specifically for novice model builders\u003c\/li\u003e \u003cli\u003ePresentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver\u003c\/li\u003e \u003cli\u003eClassification of problem types to help readers see the broader possibilities for application\u003c\/li\u003e \u003cli\u003eSpecific chapters devoted to network models and data envelopment analysis\u003c\/li\u003e \u003cli\u003eA companion website with interactive spreadsheets and supplementary homework exercises for additional practice\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eOptimization Modeling with Spreadsheets, Third Edition \u003c\/i\u003eis 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.\u003c\/p\u003e \u003cp\u003ePreface ix\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Introduction to Spreadsheet Models for Optimization 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Elements of a Model 2\u003c\/p\u003e \u003cp\u003e1.2 Spreadsheet Models 4\u003c\/p\u003e \u003cp\u003e1.3 A Hierarchy for Analysis 7\u003c\/p\u003e \u003cp\u003e1.4 Optimization Software 8\u003c\/p\u003e \u003cp\u003e1.5 Using Solver 10\u003c\/p\u003e \u003cp\u003eSummary 16\u003c\/p\u003e \u003cp\u003eExercises 17\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Linear Programming: Allocation, Covering, and Blending Models 21\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Linear Models 22\u003c\/p\u003e \u003cp\u003e2.1.1 Linear Constraints 24\u003c\/p\u003e \u003cp\u003e2.1.2 Formulation 25\u003c\/p\u003e \u003cp\u003e2.1.3 Layout 27\u003c\/p\u003e \u003cp\u003e2.1.4 Results 28\u003c\/p\u003e \u003cp\u003e2.2 Allocation Models 29\u003c\/p\u003e \u003cp\u003e2.2.1 The Product Mix Problem 36\u003c\/p\u003e \u003cp\u003e2.3 Covering Models 38\u003c\/p\u003e \u003cp\u003e2.3.1 The Staff-Scheduling Problem 43\u003c\/p\u003e \u003cp\u003e2.4 Blending Models 47\u003c\/p\u003e \u003cp\u003e2.5 Modeling Errors in Linear Programming 52\u003c\/p\u003e \u003cp\u003e2.5.1 Exceptions 53\u003c\/p\u003e \u003cp\u003e2.5.2 Debugging 54\u003c\/p\u003e \u003cp\u003e2.5.3 Logic 56\u003c\/p\u003e \u003cp\u003eSummary 56\u003c\/p\u003e \u003cp\u003eExercises 57\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Linear Programming: Network Models 65\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 The Transportation Model 66\u003c\/p\u003e \u003cp\u003e3.2 The Assignment Model 71\u003c\/p\u003e \u003cp\u003e3.3 The Transshipment Model 75\u003c\/p\u003e \u003cp\u003e3.4 Features of Special Network Models 78\u003c\/p\u003e \u003cp\u003e3.5 Building Network Models with Balance Equations 79\u003c\/p\u003e \u003cp\u003e3.6 General Network Models with Yields 84\u003c\/p\u003e \u003cp\u003e3.6.1 Models with Yield Losses 84\u003c\/p\u003e \u003cp\u003e3.6.2 Models with Yield Gains 86\u003c\/p\u003e \u003cp\u003e3.7 General Network Models with Transformed Flows 91\u003c\/p\u003e \u003cp\u003eSummary 96\u003c\/p\u003e \u003cp\u003eExercises 96\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Sensitivity Analysis in Linear Programs 108\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Parameter Analysis in the Transportation Example 109\u003c\/p\u003e \u003cp\u003e4.2 Parameter Analysis in the Allocation Example 116\u003c\/p\u003e \u003cp\u003e4.3 The Sensitivity Report and the Transportation Example 123\u003c\/p\u003e \u003cp\u003e4.4 The Sensitivity Report and the Allocation Example 127\u003c\/p\u003e \u003cp\u003e4.5 Degeneracy and Alternative Optima 129\u003c\/p\u003e \u003cp\u003e4.6 Patterns in Linear Programming Solutions 133\u003c\/p\u003e \u003cp\u003e4.6.1 The Transportation Model 134\u003c\/p\u003e \u003cp\u003e4.6.2 The Product Portfolio Model 138\u003c\/p\u003e \u003cp\u003e4.6.3 The Investment Model 142\u003c\/p\u003e \u003cp\u003e4.6.4 The Allocation Model 144\u003c\/p\u003e \u003cp\u003e4.6.5 The Refinery Model 145\u003c\/p\u003e \u003cp\u003eSummary 149\u003c\/p\u003e \u003cp\u003eExercises 151\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Linear Programming: Data Envelopment Analysis 160\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 A Graphical Perspective on DEA 162\u003c\/p\u003e \u003cp\u003e5.2 An Algebraic Perspective on DEA 166\u003c\/p\u003e \u003cp\u003e5.3 A Spreadsheet Model for DEA 168\u003c\/p\u003e \u003cp\u003e5.4 Indexing 173\u003c\/p\u003e \u003cp\u003e5.5 Reference Sets and HCUs 174\u003c\/p\u003e \u003cp\u003e5.6 Assumptions and Limitations of DEA 178\u003c\/p\u003e \u003cp\u003eSummary 181\u003c\/p\u003e \u003cp\u003eExercises 181\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Integer Programming: Binary‐Choice Models 191\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Using Solver with Integer Requirements 193\u003c\/p\u003e \u003cp\u003e6.2 The Capital Budgeting Problem 198\u003c\/p\u003e \u003cp\u003e6.3 Set Covering 202\u003c\/p\u003e \u003cp\u003e6.4 Set Packing 205\u003c\/p\u003e \u003cp\u003e6.5 Set Partitioning 208\u003c\/p\u003e \u003cp\u003e6.6 Playoff Scheduling 211\u003c\/p\u003e \u003cp\u003e6.7 The Algorithm for Solving Integer Programs 215\u003c\/p\u003e \u003cp\u003eSummary 220\u003c\/p\u003e \u003cp\u003eExercises 220\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Integer Programming: Logical Constraints 227\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Simple Logical Constraints: Exclusivity 229\u003c\/p\u003e \u003cp\u003e7.2 Linking Constraints: The Fixed Cost Problem 231\u003c\/p\u003e \u003cp\u003e7.3 Linking Constraints: The Threshold Level Problem 237\u003c\/p\u003e \u003cp\u003e7.4 Linking Constraints: The Facility Location Model 238\u003c\/p\u003e \u003cp\u003e7.4.1 Capacitated Version 239\u003c\/p\u003e \u003cp\u003e7.4.2 Uncapacitated Version 243\u003c\/p\u003e \u003cp\u003e7.5 Disjunctive Constraints: The Machine‐Sequencing Problem 246\u003c\/p\u003e \u003cp\u003e7.6 Tour Constraints: The Traveling Salesperson Problem 251\u003c\/p\u003e \u003cp\u003eSummary 259\u003c\/p\u003e \u003cp\u003eExercises 260\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Nonlinear Programming 270\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 One‐Variable Models 271\u003c\/p\u003e \u003cp\u003e8.1.1 An Inventory Example 273\u003c\/p\u003e \u003cp\u003e8.1.2 A Quantity Discount Example 275\u003c\/p\u003e \u003cp\u003e8.2 Local Optima and the Search for an Optimum 277\u003c\/p\u003e \u003cp\u003e8.3 Two‐Variable Models 280\u003c\/p\u003e \u003cp\u003e8.3.1 Curve Fitting 280\u003c\/p\u003e \u003cp\u003e8.3.2 Two‐Dimensional Location 283\u003c\/p\u003e \u003cp\u003e8.4 Nonlinear Models with Constraints 285\u003c\/p\u003e \u003cp\u003e8.4.1 A Pricing Example 286\u003c\/p\u003e \u003cp\u003e8.4.2 Sensitivity Analysis for Nonlinear Programs 288\u003c\/p\u003e \u003cp\u003e8.4.3 The Portfolio Optimization Model 290\u003c\/p\u003e \u003cp\u003e8.5 Linearizations 293\u003c\/p\u003e \u003cp\u003e8.5.1 Linearizing the Maximum 294\u003c\/p\u003e \u003cp\u003e8.5.2 Linearizing the Absolute Value 296\u003c\/p\u003e \u003cp\u003eSummary 299\u003c\/p\u003e \u003cp\u003eExercises 301\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Heuristic Solutions with the Evolutionary Solver 307\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Features of the Evolutionary Solver 308\u003c\/p\u003e \u003cp\u003e9.2 An Illustrative Example: Nonlinear Regression 309\u003c\/p\u003e \u003cp\u003e9.3 The Machine‐Sequencing Problem Revisited 317\u003c\/p\u003e \u003cp\u003e9.4 The Traveling Salesperson Problem Revisited 319\u003c\/p\u003e \u003cp\u003e9.5 Budget Allocation 322\u003c\/p\u003e \u003cp\u003e9.6 Two‐Dimensional Location 324\u003c\/p\u003e \u003cp\u003e9.7 Line Balancing 327\u003c\/p\u003e \u003cp\u003e9.8 Group Assignment 331\u003c\/p\u003e \u003cp\u003eSummary 334\u003c\/p\u003e \u003cp\u003eExercises 336\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendices\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Supplemental Files and Software 348\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA1.1 Supplemental Microsoft\u003csup\u003e®\u003c\/sup\u003e Office Excel\u003csup\u003e®\u003c\/sup\u003e Files 348\u003c\/p\u003e \u003cp\u003eA1.2 Analytic Solver Platform for Education Software 348\u003c\/p\u003e \u003cp\u003eA1.3 Opensolver Software 349\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Graphical Methods for Linear Programming 350\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA2.1 An Example 350\u003c\/p\u003e \u003cp\u003eA2.2 Generalities 355\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 The Simplex Method 357\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA3.1 An Example 357\u003c\/p\u003e \u003cp\u003eA3.2 Variations of the Algorithm 362\u003c\/p\u003e \u003cp\u003eIndex 366\u003c\/p\u003e \u003cp\u003e\u003cb\u003eKenneth R. Baker, PhD,\u003c\/b\u003e is Nathaniel Leverone Professor of Management at the Tuck School of Business and Adjunct Professor of Engineering at Dartmouth College. A Fellow of the Institute for Operations Research and the Management Sciences (INFORMS), Dr. Baker has published extensively in his areas of research interest, which include mathematical modeling, spreadsheet engineering, and scheduling. He is also coauthor of \u003ci\u003ePrinciples of Sequencing\u003c\/i\u003e \u003ci\u003eand\u003c\/i\u003e \u003ci\u003eScheduling \u003c\/i\u003eand\u003ci\u003e Management Science: The Art of Modeling with Spreadsheets, Fourth Edition\u003c\/i\u003e, both published by Wiley.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAn accessible introduction to optimization analysis using spreadsheets\u003cbr\u003e\u003cbr\u003e\u003c\/b\u003eUpdated and revised, \u003ci\u003eOptimization Modeling with Spreadsheets, Third Edition\u003c\/i\u003e 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.  \u003cbr\u003e\u003cbr\u003eThe \u003ci\u003eThird Edition\u003c\/i\u003e 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, \u003ci\u003eOptimization Modeling with Spreadsheets, Third Edition\u003c\/i\u003e features:\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAn emphasis on model building using Excel Solver as well as an appendix with additional instructions on more advanced packages such as Analytic Solver Platform and OpenSolver\u003c\/li\u003e \u003cli\u003eAdditional space devoted to formulation principles and model building as opposed to algorithms\u003c\/li\u003e \u003cli\u003eNew end-of-chapter homework exercises specifically for novice model builders\u003c\/li\u003e \u003cli\u003ePresentation of the Sensitivity Toolkit for sensitivity analysis with Excel Solver\u003c\/li\u003e \u003cli\u003eClassification of problem types to help readers see the broader possibilities for application\u003c\/li\u003e \u003cli\u003eSpecific chapters devoted to network models and data envelopment analysis\u003c\/li\u003e \u003cli\u003eA companion website with interactive spreadsheets and supplementary homework exercises for additional practice\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003e\u003cbr\u003eOptimization Modeling with Spreadsheets, Third Edition\u003c\/i\u003e 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eKenneth R. Baker, PhD,\u003c\/b\u003e is Nathaniel Leverone Professor of Management at the Tuck School of Business and Adjunct Professor of Engineering at Dartmouth College. A Fellow of the Institute for Operations Research and the Management Sciences (INFORMS), Dr. Baker has published extensively in his areas of research interest, which include mathematical modeling, spreadsheet engineering, and scheduling. He is also coauthor of \u003ci\u003ePrinciples of Sequencing and Scheduling\u003c\/i\u003e and \u003ci\u003eManagement Science: The Art of Modeling with Spreadsheets, Fourth Edition\u003c\/i\u003e, both published by Wiley.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989722808549,"sku":"NP9781118937693","price":98.5,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118937693.jpg?v=1761785249","url":"https:\/\/k12savings.com\/products\/optimization-modeling-with-spreadsheets-isbn-9781118937693","provider":"K12savings","version":"1.0","type":"link"}