Optimization modeling with spreadsheets
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 Micros...
Saved in:
| Main Author: | |
|---|---|
| Format: | eBook Book |
| Language: | English |
| Published: |
Hoboken, N.J
Wiley
2015
John Wiley & Sons, Incorporated Wiley-Blackwell |
| Edition: | 3rd ed |
| Subjects: | |
| ISBN: | 1118937694, 9781118937693, 9781118937730, 1118937732 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | 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. |
|---|---|
| AbstractList | 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. 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. 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. |
| Author | Kenneth R. Baker |
| Author_xml | – sequence: 1 fullname: Baker, Kenneth R. |
| BackLink | https://cir.nii.ac.jp/crid/1130000796025101440$$DView record in CiNii |
| BookMark | eNqN0c9PwjAUB_AaxQjIX-AFExPigeS9_tp6VII_EhIu3Jt2dFAZ21ynRP56N8fBI5fXNt9PXvPaAbnKi9xdkJGKYkSMFYsiUJdkcDpIxXtkQAEFIIJU16SvQEgZA1c3ZBTCB0ATYiQ59MlkWdZ-74-m9kU-3hdrl_l8Mz74ejsOZeXMOmydq8Mt6aUmC250Wodk9TJfzd6mi-Xr--xpMTVcMcGnCVpkxjAhIbWCAQdphbBomorK2Nil1nAac5PEPKE0RSoRqYmplXbNhuSxa2vCzh3CtsjqoL8zZ4tiF_S_iRmcb0E1dtLZsio-v1yo9R9LXF5XJtPz51mEwKlgZ0hUDcO2591Juipzm0KfLlaK0zZ96NLce534tiKy5ukhUhKoQEDO2yHuO7Y31dfR5bqsfLP90S1t_o9Hiv0CmoWMDQ |
| ContentType | eBook Book |
| DBID | MOSFZ PS5 RYH YSPEL |
| DEWEY | 005.54 |
| DatabaseName | Maruzen eBook Library Maruzen eBook Library (Global) CiNii Complete Perlego |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Economics Computer Science |
| DocumentTitleAlternate | Optimization modeling with spreadsheets |
| EISBN | 9781118937709 1118937708 9781118937730 1118937732 |
| Edition | 3rd ed 3 1 Third edition. Third Edition. |
| ExternalDocumentID | 9781118937730 9781118937709 EBC7104253 EBC1953319 999429 BB20216003 3000110479 |
| Genre | Electronic books |
| GroupedDBID | 20A 38. AABBV ABARN ABQPQ ACBYE ACCPI ACLGV ACNAM ADNEN ADVEM AERYV AHWGJ AJFER ALMA_UNASSIGNED_HOLDINGS AMYDA AUKZS AZZ BBABE BPBUR CZZ JJU MOSFZ MYL NK1 NK2 OHILO OODEK PQQKQ PS5 WLZGU WYBTS YSPEL RYH |
| ID | FETCH-LOGICAL-a49354-c1b13aa3560fb530406b55b1ab5519ab8efba4284ac84c22f126112a82b6bd3 |
| ISBN | 1118937694 9781118937693 9781118937730 1118937732 |
| IngestDate | Fri Mar 28 10:37:34 EDT 2025 Tue Sep 23 06:34:44 EDT 2025 Wed Nov 26 03:20:30 EST 2025 Wed Oct 15 13:35:48 EDT 2025 Tue Dec 02 18:49:41 EST 2025 Thu Jun 26 21:42:37 EDT 2025 Tue Nov 18 20:17:16 EST 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCN | 2015011069 |
| LCCallNum_Ident | HB143.7 .B35 2015 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a49354-c1b13aa3560fb530406b55b1ab5519ab8efba4284ac84c22f126112a82b6bd3 |
| Notes | Includes bibliographical references and index Rev. ed. of the author's Optimization modeling with spreadsheets, 2011 |
| OCLC | 905668049 1347026528 |
| PQID | EBC1953319 |
| PageCount | 391 |
| ParticipantIDs | askewsholts_vlebooks_9781118937730 askewsholts_vlebooks_9781118937709 proquest_ebookcentral_EBC7104253 proquest_ebookcentral_EBC1953319 perlego_books_999429 nii_cinii_1130000796025101440 maruzen_primary_3000110479 |
| PublicationCentury | 2000 |
| PublicationDate | 2016/01/01 c2016 2015 2015-06-15 |
| PublicationDateYYYYMMDD | 2016-01-01 2015-01-01 2015-06-15 |
| PublicationDate_xml | – year: 2015 text: 2015 |
| PublicationDecade | 2010 |
| PublicationPlace | Hoboken, N.J |
| PublicationPlace_xml | – name: Hoboken, N.J – name: New York – name: Newark |
| PublicationYear | 2016 2015 |
| Publisher | Wiley John Wiley & Sons, Incorporated Wiley-Blackwell |
| Publisher_xml | – name: Wiley – name: John Wiley & Sons, Incorporated – name: Wiley-Blackwell |
| SSID | ssj0001517640 |
| Score | 1.9076691 |
| Snippet | An accessible introduction to optimization analysis using spreadsheets
Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes... An accessible introduction to optimization analysis using spreadsheets Updated and revised, Optimization Modeling with Spreadsheets, Third Edition emphasizes... |
| SourceID | askewsholts proquest perlego nii maruzen |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | BUSINESS & ECONOMICS Electronic spreadsheets Managerial economics Managerial economics -- Mathematical models Mathematical models Mathematical optimization Programming (Mathematics) |
| TableOfContents | SUMMARY -- 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 Intro -- 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 8.4.3 The Portfolio Optimization Model -- 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 |
| Title | Optimization modeling with spreadsheets |
| URI | https://elib.maruzen.co.jp/elib/html/BookDetail/Id/3000110479 https://cir.nii.ac.jp/crid/1130000796025101440 https://www.perlego.com/book/999429/optimization-modeling-with-spreadsheets-pdf https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=1953319 https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=7104253 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781118937709&uid=none https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781118937730 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3dixMxEB_PKpz3pJ5yPT1ZRPBBVpqv3c2jPU4E4RStcPiyZNLkLNa90m3L4V_vZDfb1gp-PPgSdkM2gd9kJ_ORmQF4ptAWxnKZYs5UKj0vUlSZpb0cHIYqG-PYNMUm8vPz4uJCv9-7sexiYVbTvKqK62s9-6-kpj4idgid_QdyryelDnomolNLZKd2RyJev7YUf0d__7cYVtlWuFkbWusZyYbj-otzi41Z3HQXKtrQnBcfXm6bANiuCaDhHz_phcTAghyStcUHdxJKD4ecDvasyZF6k7SNHtx69ent548b05RieSYHTV2lOI-M2bHW8x7Agam_Eh8mHr2oQ_UlM19-dxUd0dVkQu8zN5-6y6tfjrjm3B7dhV6I5bgHe666D_tdEHZ9CM-3wUo6sJIAVrIN1gMYvT4bnb5JY82I1EgtlEwtQyaMESTJeVSCeFSGSiEz1DJtsHAeDelc0thCWs49Ix2ScVNwzHAsHkKvuqrcESS5H3Bk3PmQy9ujQ-60tsaLwuWI6PvwdAuBcjVtvNt1uYEpH-i_GCQGfTiO6JWzNsVIKRpZPaT_78MJAVraSWhZcD6SVEdqJw_MVEr6-DBCXcaptSYZow9Jh3vZrBnv-pZnw9PgOSXO-7shJHcSMxfHf1j8EdzZ7MfH0FvMl-4EbtvVYlLPn8R99QMtEjiW |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Optimization+modeling+with+spreadsheets&rft.au=Baker%2C+Kenneth+R.&rft.date=2016-01-01&rft.pub=Wiley&rft.isbn=9781118937693&rft.externalDocID=BB20216003 |
| thumbnail_l | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fwww.perlego.com%2Fbooks%2FRM_Books%2Fwiley_hlvwyirv%2F9781118937730.jpg |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97811189%2F9781118937709.jpg http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97811189%2F9781118937730.jpg |