Skip to content

Practical Management Science Spreadsheet Modeling and Applications

Spend $50 to get a free DVD!

ISBN-10: 0534371353

ISBN-13: 9780534371357

Edition: 2nd 2001

Authors: Albright Winston, S. Christian Albright, Wayne L. Winston

List price: $258.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!

Customers also bought

Book details

List price: $258.95
Edition: 2nd
Copyright year: 2001
Publisher: Brooks/Cole
Publication date: 7/25/2000
Binding: Hardcover
Pages: 976
Size: 8.25" wide x 10.00" long x 1.25" tall
Weight: 4.334
Language: English

S. Christian Albright received his B.S. degree in mathematics from Stanford in 1968 and his Ph.D. in operations research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. His current interest is in spreadsheet modeling, including development of VBA applications in Excel. Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability as well as a number of…    

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and the recipient of more than 30 teaching awards. For the past 20 years, Wayne has also taught Fortune 500 companies how to use Excel to make smarter business decisions. He has written 15 books on Excel, management science, and mathematics in sports.

Introduction to Modeling
Introduction
A Waiting-Line Example
Modeling versus Models
The Seven-Step Modeling Process
Successful Management Science Applications
Why Study Management Science?
Software Included in This Book
Conclusion
Introductory Spreadsheet Modeling
Introduction
Basic Spreadsheet Modeling Concepts
Modeling Examples
Conclusion
Tips for Editing and Documenting Spreadsheets
Introduction to Optimization Modeling
Introduction
A Brief History of Linear Programming
Introduction to LP Modeling
Sensitivity Analysis and the Solver Table Add-In
The Linear Assumptions
Graphical Solution Method
Infeasibility and Unboundedness
A Multiperiod Production Problem
A Decision Support System
Conclusion
Information on Solvers
Shelby Shelving
Linear Programming Models
Introduction
Static Workforce Scheduling Models
Aggregate Planning Models
Dynamic Workforce Planning Models
Blending Models
Production Process Models
Dynamic Financial Models
Data Envelopment Analysis (DEA)
Conclusion
Lakefield Corporation's Oil Trading Desk
Foreign Currency Trading
Network Models
Introduction
Transportation Models
More General Logistics Models
Non-Logistics Network Models
Project Scheduling Models
Conclusion
Optimized Motor Carrier Selection at Westvaco
Linear Optimization Models with Integer Variables
Introduction
Approaches to Optimization with Integer Variables
Capital Budgeting Models
Fixed-Cost Models
Lockbox Models
Plant and Warehouse Location Models
Set-Covering Models
Models with Either-Or Constraints
Cutting Stock Models
Conclusion
Giant Motor Company I
Nonlinear Optimization Models
Introduction
Basic Ideas of Nonlinear Optimization
Pricing Models
Sales Force Allocation Models
Facility Location Models
Rating Sports Teams
Estimating the Beta of a Stock
Portfolio Optimization
Conclusion
GMS Stock Hedging
Durham Asset Management
Evolutionary Solver: An Alternative Optimization Procedure
Introduction
Introduction to Genetic Algorithms
Introduction to the Evolutionary Solver
Nonlinear Pricing Models
Combinatorial Models
Fitting an S-Shaped Curve
Portfolio Optimization
Cluster Analysis
Discriminant Analysis
Conclusion
Assigning MBA Students to Teams
Multi-Objective Decision Making
Introduction
Goal Programming
Pareto Optimality and Trade-off Curves
The Analytic Hierarchy Process
Conclusion
Play Time Toy Company
Decision Making Under Uncertainty
Introduction
Elements of a Decision Analysis
More Single-Stage Examples
Multistage Decision Problems
Bayes' Rule
Incorporating Attitudes Toward Risk
Conclusion
GMC Motor Company II
Jogger Shoe Company
Westhouser Paper Company
Introduction to Simulation Modeling
Introduction
Real Applications of Simulation
Generating Uniformly Distributed Random Numbers
Simulation with Built-In Excel Tools
Generating Random Numbers from Other Probability Distributions
Introduction to @ Risk
Correlation in @ Risk
Conclusion
Ski Jacket Production
Ebony Bath Soap
Simulation Models
Introduction
Operations Models
Financial Models
Marketing Models
Simulating Games of Chance
Using TopRank with @ Risk for Powerful Modeling
Conclusion
A College Fund Investment Decision
Bond Investment Strategy
Financials at Carco
Inventory Models
Introduction
Categories of Inventory Models
Types of Costs in Inventory Models
Economic Order Quantity (EOQ) Models
Probabilistic Inventory Models
Ordering Simulation Models
Supply Chain Models
Conclusion
Subway Token Hoarding
Retail Pricing Using Retailer
Queueing Models
Introduction
Elements of Queueing Models
The Exponential Distribution
Important Queueing Relationships
Analytical Models
Queueing Simulation
Conclusion
The Catalog Company Problem
Regression Analysis
Introduction
Scatterplots: Graphing Relationships
Correlations: Indicators of Linear Relationships
Simple Linear Regression
Multiple Regression
The Statistical Model
Inferences About the Regression Coefficients
Multicollinearity
Modeling Possibilities
Prediction
Conclusion
Quantity Discounts at the FirmChair Company
Demand for French Bread at Howie's
Investing for Retirement
Heating Oil at Dupree Fuels Company
Forecasting Overhead at Wagner Printers
Time Series Analysis and Forecasting
Introduction
General Concepts
Random Series
The Random Walk Model
Autoregression Models
Regression-Based Trend Models
Moving Averages
Exponential Smoothing
Deseasonalizing: The Ratio-to-Moving-Averages Method
Estimating Seasonality with Regression
Conclusion
Arrivals at the Credit Union
Forecasting Weekly Sales at Amanta
References
Index