عنوان

Optimization modeling with spreadsheets /

شابک

1118937708

شابک

1118937732

شابک

9781118937709

شابک

9781118937730

شابک اشتباه

1118937694

شابک اشتباه

9781118937693

شماره ناشر

EB00626695

منبع

Recorded Books

عنوان اصلي

Optimization modeling with spreadsheets /

نام عام مواد

[Book]

نام نخستين پديدآور

Kenneth R. Baker.

وضعيت ويراست

Third edition.

محل نشرو پخش و غیره

Hoboken, New Jersey :

نام ناشر، پخش کننده و غيره

John Wiley & Sons, Inc.,

تاریخ نشرو بخش و غیره

2015.

نام خاص و کميت اثر

1 online resource

متن يادداشت

Revised edition of the author's Optimization modeling with spreadsheets, 2011.

متن يادداشت

Includes bibliographical references and index.

متن يادداشت

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.

بدون عنوان

0

بدون عنوان

8

بدون عنوان

8

متن يادداشت

"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"--

منبع سفارش / آدرس اشتراک

Safari Books Online

شماره انبار

CL0500000671

عنوان

Optimization modeling with spreadsheets.

شماره استاندارد بين المللي کتاب و موسيقي

9781118937693

موضوع مستند نشده

Electronic spreadsheets.

موضوع مستند نشده

Managerial economics-- Mathematical models.

موضوع مستند نشده

Mathematical optimization.

موضوع مستند نشده

Programming (Mathematics)

موضوع مستند نشده

BUSINESS & ECONOMICS-- Management Science.

موضوع مستند نشده

BUSINESS & ECONOMICS-- Project Management.

موضوع مستند نشده

Electronic spreadsheets.

موضوع مستند نشده

Managerial economics-- Mathematical models.

موضوع مستند نشده

Mathematical optimization.

موضوع مستند نشده

Programming (Mathematics)

موضوع مستند نشده

TECHNOLOGY & ENGINEERING-- Industrial Engineering.

موضوع مستند نشده

BUS-- 042000

موضوع مستند نشده

BUS-- 101000

موضوع مستند نشده

TEC-- 009060

شماره

ويراست

شماره رده

شماره رده

کد سيستم

مستند نام اشخاص تاييد نشده

Baker, Kenneth R.,1943-

تاريخ عمليات

20200824105859.0

قواعد فهرست نويسي ( بخش توصيفي )

pn

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y