E-Books sind auch über alle bekannten E-Book Shops erhältlich.
Kurzbeschreibung Today, anyone who builds a spreadsheet model can call on optimization techniques without any need to learn about specialized software. Focusing exclusively on spreadsheet optimization models, Optimization Modeling with Spreadsheets provides a solid introduction to optimization (mathematical programming). This extensively classroom-tested Second Edition provides a systematic introduction to Data Envelopent Analysis (DEA). Coverage on linear programming, nonlinear programming, integer programming, and heuristic programming is included as well as an emphasis on model building using Excel and Solver. The text's accessible approach is suitable for MBA students and modeling practitioners.
Aus dem Inhalt Preface.
Chapter 1. Introduction to Spreadsheet Models for Optimization.
1.1 Elements of Model.
1.2 Spreadsheet Models.
1.3 A Hierarchy for Analysis.
1.4 Optimization Software.
1.5 Using Solver.
Chapter 2. Linear Programming: Allocation, Covering and Blending Models.
2.1 Linear Models.
2.2 Allocation Models.
2.3 Covering Models.
2.4 Blending Models.
2.5 Modeling Errors in Linear Programming.
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 Yields.
3.6 General Network Models with Yields.
3.7 General Network Models with Transformed Flows.
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.
Chapter 5. Linear Programming: Data Envelopment Analysis.