Spreadsheet Modeling and Applications Essentials of Practical Management Science (with CD-ROM and InfoTrac)

, by Albright, S. Christian; Winston, Wayne

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780534380328 | 0534380328
Cover: Hardcover
Copyright: 4/21/2004

Buy New

Currently Available, Usually Ships in 24-48 Hours

$172.39

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.

Introduction to spreadsheet modeling
Introduction to Modeling
Introduction
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
Conclusion
Introductory Spreadsheet Modeling
Introduction
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
Conclusion
Appendix: Tips for Editing and Documenting Spreadsheets
Decision making under certainty
Introduction to Optimization Modeling
Introduction
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
Conclusion
Appendix: Information on Solvers
Linear Programming Models
Introduction
Advertising Models
Static Workforce Scheduling Models
Aggregate Planning Models
Blending Models
Production Process Models
Financial Models
Conclusion
Network Models
Introduction
Transportation Models
Assignment Models
Minimum Cost Network Flow Models
Shortest Path Models
Project Scheduling Models
Conclusion
Linear Optimization Models with Integer Variables
Introduction
Overview of Optimization with Integer Variables
Capital Budgeting Models
Fixed-Cost Models
Set Covering Models and Location/Assignment Models
Conclusion
Nonlinear Optimization Models
Introduction
Basic Ideas of Nonlinear Optimization
Pricing Models
Advertising Response and Selection Models
Facility Location Models
Models for Rating Sports Teams
Portfolio Optimization Models
Conclusion
Decision making under uncertainty
Decision Making Under Uncertainty
Introduction
Elements of a Decision Analysis
The PrecisionTree Add-In
Bayes? Rule
Multistage Decision Problems
Incorporating Attitudes Toward Risk
Conclusion
Introduction to Simulation Modeling
Introduction
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
Conclusion
Simulation Models
Introduction
Operations Models
Financial Models
Marketing Models
Simulating Games of Chance
Conclusion
Queuing Models
Introduction
Elements of Queuing Models
The Exponential Distribution
Important Queueing
Relationships
Analytical Queuing Models
Queuing Simulation Models
Conclusion
Regression and Forecasting Models
Introduction
Overview of Regression Models
Simple Regression Models
Multiple Regression Models
Overview of Time Series Models
Moving Averages Models
Exponential Smoothing Models
Conclusion
Table of Contents provided by Publisher. All Rights Reserved.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Spreadsheet Modeling and Applications Essentials of Practical Management Science (with CD-ROM and InfoTrac)

Summary

Table of Contents

Supplemental Materials