Skip to content

Spreadsheet Modeling and Applications Essentials of Practical Management Science

Spend $50 to get a free movie!

ISBN-10: 0534380328

ISBN-13: 9780534380328

Edition: 2005

Authors: S. Christian Albright, Wayne Winston

List price: $174.95
Blue ribbon 30 day, 100% satisfaction guarantee!
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!

Knowing spreadsheets can save your job? Absolutely. SPREADSHEET MODELING AND APPLICATIONS: ESSENTIALS OF PRACTICAL MANAGEMENT SCIENCE shows you how with just a little spreadsheet magic you can solve real life business problems. It's relevant, it's simple and it comes with DecisionTools Suite. With DecisionTools Suite you'll get the spreadsheet add-ins to make homework a snap.
Customers also bought

Book details

List price: $174.95
Copyright year: 2005
Publisher: Brooks/Cole
Publication date: 4/21/2004
Binding: Hardcover
Pages: 600
Size: 8.25" wide x 10.00" long x 2.25" tall
Weight: 3.586

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 spreadsheet modeling
Introduction to Modeling
A Waiting Line Example
Modeling Versus Models
The Seven-Step Modeling Process
A Successful Management Science Application
Why Study Management Science? Software Included in This Book
Introductory Spreadsheet Modeling
Basic Spreadsheet Modeling: Concepts and Best Practices
Cost Projections
Breakeven Analysis
Ordering with Quantity Discounts and Demand Uncertainty
Decisions Involving the Time Value of Money
Appendix: Tips for Editing and Documenting Spreadsheets
Decision making under certainty
Introduction to Optimization Modeling
Introduction to Optimization
A Two-Variable Model
Sensitivity Analysis
Properties of Linear Models
Infeasibility and Unboundedness
A Product Mix Model
A Multiperiod Production Model
A Comparison of Algebraic and Spreadsheet Models
A Decision Support System
Appendix: Information on Solvers
Linear Programming Models
Advertising Models
Static Workforce Scheduling Models
Aggregate Planning Models
Blending Models
Production Process Models
Financial Models
Network Models
Transportation Models
Assignment Models
Minimum Cost Network Flow Models
Shortest Path Models
Project Scheduling Models
Linear Optimization Models with Integer Variables
Overview of Optimization with Integer Variables
Capital Budgeting Models
Fixed-Cost Models
Set Covering Models and Location/Assignment Models
Nonlinear Optimization Models
Basic Ideas of Nonlinear Optimization
Pricing Models
Advertising Response and Selection Models
Facility Location Models
Models for Rating Sports Teams
Portfolio Optimization Models
Decision making under uncertainty
Decision Making Under Uncertainty
Elements of a Decision Analysis
The PrecisionTree Add-In
Bayes? Rule
Multistage Decision Problems
Incorporating Attitudes Toward Risk
Introduction to Simulation Modeling
Real Applications of Simulation
Probability Distributions for Input Variables
Simulation with Built-In Excel Tools
Introduction to @RISK
The Effect of Input Distributions on Results
Simulation Models
Operations Models
Financial Models
Marketing Models
Simulating Games of Chance
Queuing Models
Elements of Queuing Models
The Exponential Distribution
Important Queueing
Analytical Queuing Models
Queuing Simulation Models
Regression and Forecasting Models
Overview of Regression Models
Simple Regression Models
Multiple Regression Models
Overview of Time Series Models
Moving Averages Models
Exponential Smoothing Models