Skip to content

Optimizing Modeling with Spreadsheets

Spend $50 to get a free DVD!

ISBN-10: 0534494749

ISBN-13: 9780534494742

Edition: 2006

Authors: Kenneth Baker

List price: $181.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Spreadsheet-based introduction to mathematical programming concepts and applications, intended for undergraduate and graduate students in management and engineering. Its emphasis on model building and its focus on formulation principles are key features that reinforce its practical approach. The text also includes a comprehensive tutorial on the use of Excel?s Solver, and, at a more advanced level, Frontline Systems? Premium Solver.
Customers also bought

Book details

List price: $181.95
Copyright year: 2006
Publisher: Brooks/Cole
Publication date: 7/15/2005
Binding: Hardcover
Pages: 368
Size: 7.50" wide x 9.50" long x 0.75" tall
Weight: 1.628
Language: English

Introduction to Spreadsheet Modeling for Optimization
Elements of a Model
Spreadsheet Models
A Hierarchy for Analysis
Optimization Software
Using Solver
Linear Programming Formulations: Allocation, Covering, and Blending Models
Linear Models
Allocation Models
Blending Models
Modeling Errors in Linear Programming
Linear Programming Formulations: Network Models
The Transportation Model
The Assignment Model
The Transshipment Model
Features of Special Network Models
Building Network Models with Balance Equations
General Network Models with Expanding Flows
General Network Models with Transformed Flows
Sensitivity Analysis Linear Programs
Sensitivity Analysis Transportation Example
Sensitivity Analysis in the Allocation Example
The Sensitivity Report and the Transportation Example
The Sensitivity Report and the Allocation Example
Degeneracy and Alternative Optima
Patterns in Linear Programming Solutions
Linear Programming Formulations: Data Envelopment Analysis
A Graphical Perspective on DEA
An Algebraic Perspective on DEA
A Spreadsheet Model for DEA
Finding Reference Sets and HCUs
Assumptions and Limitations of DEA
Integer Programming
Using Solver with Integer Requirements
Models with Binary Choice
Models with Qualitative Constraints
The Facility Location Model
The Algorithm for Solving Integer Programs
Nonlinear Programming
One-Variable Models
Local Optima and Search for an Optimum
Two-Variable Models
Nonlinear Models with Constraints
Heuristic Solutions with the Evolutionary Solver
Features of the Evolutionary Solver
An Illustrative Example: Nonlinear Regression
The Machine-Sequence Problem Revisited
The Traveling Salesperson Problem Revisited
Multi-Machine Scheduling
Two-Dimensional Location
Group Assignment
Graphical Methods in Linear Programming
The Simplex Method
Stochastic Programming.