Optimization Modeling with Spreadsheets

ISBN-10: 0470928638
ISBN-13: 9780470928639
Edition: 2nd 2011
Authors: Kenneth R. Baker
List price: $86.50 Buy it from $43.00
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming and heuristic programming; as well as an emphasis on model building using Excel and Solver. The  More...

New Starting from $131.36
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
History of Western Art Online content $4.95 $1.99
Add to cart
Study Briefs
History of World Philosophies Online content $4.95 $1.99
Add to cart
Study Briefs
American History Volume 1 Online content $4.95 $1.99
Add to cart
Study Briefs
History of Western Music Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $86.50
Edition: 2nd
Copyright year: 2011
Publisher: John Wiley & Sons, Limited
Publication date: 4/19/2011
Binding: Hardcover
Pages: 432
Size: 6.00" wide x 9.00" long x 1.00" tall
Weight: 1.738
Language: English

This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming and heuristic programming; as well as an emphasis on model building using Excel and Solver. The emphasis on model building (rather than algorithms) is one of the features that makes this book distinctive. 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. The 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. Thus, someone looking for a spreadsheet-based treatment would otherwise need to use a book that was designed for some other purpose, like a survey of management science topics, rather than one devoted to optimization. The model building emphasis derives from an attempt to be realistic about what readers need most when learning about optimization. At an introductory level, the most practical and motivating theme is the wide applicability of optimization tools. To apply optimization effectively, readers needs more than a brief exposure to a series of numerical examples, which is the way that most mathematical programming books treat applications. With a systematic modeling emphasis, readers can begin to see the basic structures that appear in optimization models and as a result, develop an appreciation for potential applications well beyond the examples in the book. Formulating optimization models is both an art and a science, and this book pays attention to both. The art can be refined with practice, especially supervised practice, just the way a student would learn sculpture or painting. The science is reflected in the structure that organizes the topics in this book. For example, there are several distinct problem types that lend themselves to linear programming formulations, and it makes sense to study these types systematically. In that spirit, the book builds a library of templates against which new problems can be compared. Analogous structures are developed for the presentation of other topics as well.

Preface
Introduction to Spreadsheet Models for Optimization
Elements of a Model
Spreadsheet Models
A Hierarchy for Analysis
Optimization Software
Using Solver
Summary
Exercises
References
Linear Programming: Allocation, Covering, and Blending Models
Linear Models
Linear Constraints
Formulation
Layout
Results
Allocation Models
The Product Mix Problem
Covering Models
The Staff-Scheduling Problem
Blending Models
Modeling Errors in Linear Programming
Exceptions
Debugging
Logic
Summary
Exercises
Case: JetGreen
Linear Programming: 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 Yields
Models with Yield Losses
Models with Yield Gains
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
Sensitivity Analysis in Linear Programs
Parameter Analysis in the Transportation Example
Parameter 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
The Transportation Model
The Product Portfolio Model
The Investment Model
The Allocation Model
The Refinery Model
Summary
Exercises
Case: Cox Cable and Wire Company
Background
The Contract
The Analysis
Linear Programming: 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
Exercises
Case: Branch Performance at Nashville National Bank
Branch Growth at Nashville National Bank
Assessing Branch Productivity
Branch Managers Revolt
Measuring Branches: Available Techniques
The DEA Study
Integer Programming: Binary Choice Models
Using Solver with Integer Requirements
The Capital Budgeting Problem
Set Covering
Set Packing
Set Partitioning
Playoff Scheduling
Solving a Large-Scale Set Partitioning Problem
The Algorithm for Solving Integer Programs
Summary
Exercises
Case: Motel Location for Nature's Inn
Integer Programming: Logical Constraints
Simple Logical Constraints: Exclusivity and Contingency
Linking Constraints: The Fixed Cost Problem
Linking Constraints: The Threshold Level Problem
Linking Constraints: The Facility Location Model
Capacitated Version
Uncapacilated Version
Disjunctive Constraints: The Machine Sequencing Problem
Tour and Subset Constraints: The Traveling Salesperson Problem
Summary
Exercises
Case: Hornby Products Company
History
Alternatives
Nonlinear Programming
One-variable Models
An Inventory Example
A Quantity Discount Example
Local Optima and the Search for an Optimum
Two-Variable Models
Curve Fitting
Two-dimensional Location
Nonlinear Models with Constraints
A Pricing Example
Sensitivity Analysis for Nonlinear Programs
The Portfolio Optimization Model
Linearizations
Linearizing the Maximum
Linearizing the Absolute Value
Summary
Exercises
Case: Delhi Foods
Heuristic Solutions with the Evolutionary Solver
Features of the Evolutionary Solver
An Illustrative Example: Nonlinear Regression
The Machine-Sequencing Problem Revisited
The Traveling Salesperson Problem Revisited
Two-dimensional Location
Line Balancing
Group Assignment
Summary
Exercises
Case: Colgate Wave (Abridged)
Introduction
The Study
Case Appendix: Market Share Simulation Model (CoIgate.xls)
Data
Calculations
Simulation
Appendices
Optimization Software and Supplemental Files
Risk Solver Platform
Supplemental Excel Files
Graphical Methods in Linear Programming
An Example
Generalities
The Simplex Method
An Example
Variations of the Algorithm
References
Stochastic Programming
One-Stage Decisions with Uncertainty
Two-Stage Decisions with Uncertainty
Using Solver
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×