| Document Type
|
:
|
BL
|
| Record Number
|
:
|
892710
|
| Main Entry
|
:
|
Baker, Kenneth R.,1943-
|
| Title & Author
|
:
|
Optimization modeling with spreadsheets /\ Kenneth R. Baker.
|
| Edition Statement
|
:
|
Third edition.
|
| Publication Statement
|
:
|
Hoboken, New Jersey :: John Wiley & Sons, Inc.,, 2015.
|
| Page. NO
|
:
|
1 online resource
|
| ISBN
|
:
|
1118937708
|
|
|
:
|
: 1118937732
|
|
|
:
|
: 9781118937709
|
|
|
:
|
: 9781118937730
|
|
|
:
|
1118937694
|
|
|
:
|
9781118937693
|
| Notes
|
:
|
Revised edition of the author's Optimization modeling with spreadsheets, 2011.
|
| Bibliographies/Indexes
|
:
|
Includes bibliographical references and index.
|
| Contents
|
:
|
Title Page -- Copyright Page -- Contents -- PREFACE -- CHAPTER 1 INTRODUCTION TO SPREADSHEET MODELS FOR OPTIMIZATION -- 1.1 ELEMENTS OF A MODEL -- 1.2 SPREADSHEET MODELS -- 1.3 A HIERARCHY FOR ANALYSIS -- 1.4 OPTIMIZATION SOFTWARE -- 1.5 USING SOLVER -- SUMMARY -- EXERCISES -- REFERENCES -- CHAPTER 2 LINEAR PROGRAMMING: ALLOCATION, COVERING, AND BLENDING MODELS -- 2.1 LINEAR MODELS -- 2.1.1 Linear Constraints -- 2.1.2 Formulation -- 2.1.3 Layout -- 2.1.4 Results -- 2.2 ALLOCATION MODELS -- 2.2.1 The Product Mix Problem -- 2.3 COVERING MODELS -- 2.3.1 The Staff-Scheduling Problem -- 2.4 BLENDING MODELS -- 2.5 MODELING ERRORS IN LINEAR PROGRAMMING -- 2.5.1 Exceptions -- 2.5.2 Debugging -- 2.5.3 Logic -- SUMMARY -- EXERCISES -- Case: JetGreen -- CHAPTER 3 LINEAR PROGRAMMING: NETWORK MODELS -- 3.1 THE TRANSPORTATION MODEL -- 3.2 THE ASSIGNMENT MODEL -- 3.3 THE TRANSSHIPMENT MODEL -- 3.4 FEATURES OF SPECIAL NETWORK MODELS -- 3.5 BUILDING NETWORK MODELS WITH BALANCE EQUATIONS -- 3.6 GENERAL NETWORK MODELS WITH YIELDS -- 3.6.1 Models with Yield Losses -- 3.6.2 Models with Yield Gains -- 3.7 GENERAL NETWORK MODELS WITH TRANSFORMED FLOWS -- SUMMARY -- EXERCISES -- Case: Casey's Famous Roast Beef -- Case: Hollingsworth Paper Company -- Production and Distribution Facilities -- Patterns of Distribution -- Expansion Proposals -- CHAPTER 4 SENSITIVITY ANALYSIS IN LINEAR PROGRAMS -- 4.1 PARAMETER ANALYSIS IN THE TRANSPORTATION EXAMPLE -- 4.2 PARAMETER ANALYSIS IN THE ALLOCATION EXAMPLE -- 4.3 THE SENSITIVITY REPORT AND THE TRANSPORTATION EXAMPLE -- 4.4 THE SENSITIVITY REPORT AND THE ALLOCATION EXAMPLE -- 4.5 DEGENERACY AND ALTERNATIVE OPTIMA -- 4.6 PATTERNS IN LINEAR PROGRAMMING SOLUTIONS -- 4.6.1 The Transportation Model -- 4.6.2 The Product Portfolio Model -- 4.6.3 The Investment Model -- 4.6.4 The Allocation Model -- 4.6.5 The Refinery Model -- SUMMARY.
|
|
|
:
|
8.5 LINEARIZATIONS -- 8.5.1 Linearizing the Maximum -- 8.5.2 Linearizing the Absolute Value -- SUMMARY -- EXERCISES -- Case: Delhi Foods -- CHAPTER 9 HEURISTIC SOLUTIONS WITH THE EVOLUTIONARY SOLVER -- 9.1 FEATURES OF THE EVOLUTIONARY SOLVER -- 9.2 AN ILLUSTRATIVE EXAMPLE: NONLINEAR REGRESSION -- 9.3 THE MACHINE-SEQUENCING PROBLEM REVISITED -- 9.4 THE TRAVELING SALESPERSON PROBLEM REVISITED -- 9.5 BUDGET ALLOCATION -- 9.6 TWO-DIMENSIONAL LOCATION -- 9.7 LINE BALANCING -- 9.8 GROUP ASSIGNMENT -- SUMMARY -- EXERCISES -- Case: Colgate Wave (Abridged) -- Introduction -- The Study -- Case Appendix: Market Share Simulation Model (Colgate.xls) -- Data -- Calculations -- Simulation -- APPENDIX 1 SUPPLEMENTAL FILES AND SOFTWARE -- A1.1 SUPPLEMENTAL Microsoft® Office Excel® FILES -- A1.2 ANALYTIC SOLVER PLATFORM FOR EDUCATION SOFTWARE -- A1.3 OPENSOLVER SOFTWARE -- APPENDIX 2 GRAPHICAL METHODS FOR LINEAR PROGRAMMING -- A2.1 AN EXAMPLE -- A2.2 GENERALITIES -- APPENDIX 3 THE SIMPLEX METHOD -- A3.1 AN EXAMPLE -- A3.2 VARIATIONS OF THE ALGORITHM -- REFERENCES -- Index -- EULA.
|
|
|
:
|
EXERCISES -- Case: Cox Cable and Wire Company -- Background -- The Contract -- The Analysis -- CHAPTER 5 LINEAR PROGRAMMING: DATA ENVELOPMENT ANALYSIS -- 5.1 A GRAPHICAL PERSPECTIVE ON DEA -- 5.2 AN ALGEBRAIC PERSPECTIVE ON DEA -- 5.3 A SPREADSHEET MODEL FOR DEA -- 5.4 INDEXING -- 5.5 REFERENCE SETS AND HCUs -- 5.6 ASSUMPTIONS AND LIMITATIONS OF DEA -- SUMMARY -- EXERCISES -- Case: Branch Performance at Nashville National Bank -- Branch Growth at NNB -- Assessing Branch Productivity -- Branch Managers Revolt -- Measuring Branches: Available Techniques -- The DEA Study -- CHAPTER 6 INTEGER PROGRAMMING: BINARY-CHOICE MODELS -- 6.1 USING SOLVER WITH INTEGER REQUIREMENTS -- 6.2 THE CAPITAL BUDGETING PROBLEM -- 6.3 SET COVERING -- 6.4 SET PACKING -- 6.5 SET PARTITIONING -- 6.6 PLAYOFF SCHEDULING -- 6.7 THE ALGORITHM FOR SOLVING INTEGER PROGRAMS -- SUMMARY -- EXERCISES -- Case: Motel Location for Nature's Inn -- CHAPTER 7 INTEGER PROGRAMMING: LOGICAL CONSTRAINTS -- 7.1 SIMPLE LOGICAL CONSTRAINTS: EXCLUSIVITY -- 7.2 LINKING CONSTRAINTS: THE FIXED COST PROBLEM -- 7.3 LINKING CONSTRAINTS: THE THRESHOLD LEVEL PROBLEM -- 7.4 LINKING CONSTRAINTS: THE FACILITY LOCATION MODEL -- 7.4.1 Capacitated Version -- 7.4.2 Uncapacitated Version -- 7.5 DISJUNCTIVE CONSTRAINTS: THE MACHINE-SEQUENCING PROBLEM -- 7.6 TOUR CONSTRAINTS: THE TRAVELING SALESPERSON PROBLEM -- SUMMARY -- EXERCISES -- Case: Hornby Products Company -- History -- Alternatives -- CHAPTER 8 NONLINEAR PROGRAMMING -- 8.1 ONE-VARIABLE MODELS -- 8.1.1 An Inventory Example -- 8.1.2 A Quantity Discount Example -- 8.2 LOCAL OPTIMA AND THE SEARCH FOR AN OPTIMUM -- 8.3 TWO-VARIABLE MODELS -- 8.3.1 Curve Fitting -- 8.3.2 Two-Dimensional Location -- 8.4 NONLINEAR MODELS WITH CONSTRAINTS -- 8.4.1 A Pricing Example -- 8.4.2 Sensitivity Analysis for Nonlinear Programs -- 8.4.3 The Portfolio Optimization Model.
|
| Abstract
|
:
|
"This book focuses on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver"--
|
|
|
:
|
"Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Third Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver. The focus on model building (rather than algorithms) is one feature that makes this book distinctive as most books devote more space to algorithmic details than to formulation principles. These days, however, it is not necessary to know a great deal about algorithms in order to apply optimization tools, especially when relying on the spreadsheet as a solution platform. This emphasis on spreadsheets is another feature that makes this book distinctive. Few books devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most books that emphasize model building ignore spreadsheets entirely. To address the capabilities of sensitivity analysis, the use of Excel's Sensitivity Toolkit is employed. In addition, the book's past use of the Risk Solver Platform for Education (RSPE) is not completely abandoned as the author does include instructions on the use of RSPE for solving optimization problems within an appendix"--
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Managerial economics-- Mathematical models.
|
| Subject
|
:
|
Mathematical optimization.
|
| Subject
|
:
|
Programming (Mathematics)
|
| Subject
|
:
|
BUSINESS ECONOMICS-- Management Science.
|
| Subject
|
:
|
BUSINESS ECONOMICS-- Project Management.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Managerial economics-- Mathematical models.
|
| Subject
|
:
|
Mathematical optimization.
|
| Subject
|
:
|
Programming (Mathematics)
|
| Subject
|
:
|
TECHNOLOGY ENGINEERING-- Industrial Engineering.
|
| Dewey Classification
|
:
|
005.54
|
| LC Classification
|
:
|
HB143.7
|
| NLM classification
|
:
|
BUS042000BUS101000TEC009060bisacsh
|