Spreadsheet Modeling and Applications Essentials of Practical Management Science

Name: Spreadsheet Modeling and Applications Essentials of Practical Management Science
Availability: InStock
ISBN: 9780534380328

ISBN-10: 0534380328

ISBN-13: 9780534380328

Edition: 2005

Authors: S. Christian Albright, Wayne Winston

List price: $174.95

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/13/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $8.14

Marketplace

3 new & used from $4.21

what's this?

Rush Rewards U
Members Receive:

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.

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


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