did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780534494742

Optimization Modeling with Spreadsheets (with CD-ROM)

by
  • ISBN13:

    9780534494742

  • ISBN10:

    0534494749

  • Edition: CD
  • Format: Hardcover
  • Copyright: 2005-07-15
  • Publisher: Cengage Learning
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $204.95

Summary

Ideal for students in managment and engineering, OPTIMIZATION MODELING WITH SPREADSHEETS (WITH CD-ROM) covers model building and include tutorials on the use of Excel's Solver, and, at a more advanced level, Frontline Systems' Premium Solver.

Table of Contents

Introduction to Spreadsheet Modeling for Optimization
Elements of a Model
Spreadsheet Models
A Hierarchy for Analysis
Optimization Software
Using Solver
Summary
Homework
Linear Programming Formulations: Allocation, Covering, and Blending Models
Linear Models
Allocation Models
Blending Models
Modeling Errors in Linear Programming
Summary
Homework
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
Summary
Homework
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
Summary
Homework
Linear Programming Formulations: Data Envelopment Analysis
A Graphical Perspective on DEA
An Algebraic Perspective on DEA
A Spreadsheet Model for DEA
Indexing
Finding Reference Sets and HCUs
Assumptions and Limitations of DEA
Summary
Homework
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
Summary
Homework
Nonlinear Programming
One-Variable Models
Local Optima and Search for an Optimum
Two-Variable Models
Nonlinear Models with Constraints
Linearizations
Summary
Homework
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
Summary
Homework
Software
Graphical Methods in Linear Programming
The Simplex Method
Stochastic Programming.
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program