MOMENTAN AUSVERKAUFT

Spreadsheet Modeling and Applications : Essentials of Practical Management Science by Wayne Winston and S. Christian Albright (2004, Hardcover)

Über dieses Produkt

Product Identifiers

PublisherBrooks/Cole
ISBN-100534380328
ISBN-139780534380328
eBay Product ID (ePID)30513116

Product Key Features

Number of Pages600 Pages
LanguageEnglish
Publication NameSpreadsheet Modeling and Applications : Essentials of Practical Management Science
Publication Year2004
SubjectManagement Science, Desktop Applications / Spreadsheets, Statistics
TypeTextbook
Subject AreaComputers, Business & Economics
AuthorWayne Winston, S. Christian Albright
FormatHardcover

Dimensions

Item Height2 in
Item Weight57.7 Oz
Item Length10.4 in
Item Width8.3 in

Additional Product Features

Intended AudienceCollege Audience
LCCN2004-102060
Dewey Edition22
ReviewsI like the real-world examples interlaced in the problems and prose. In particular, it is refreshing that the authors admit that the mathematical models take into account several assumptions in order to establish a frame of reference or starting point in solving them., Part I: INTRODUCTION TO SPREADSHEET MODELING.1. 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.2. 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.Part II: DECISION MAKING UNDER CERTAINTY.3. 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. 4. Linear Programming Models.Introduction. Advertising Models. Static Workforce Scheduling Models. Aggregate Planning Models. Blending Models. Production Process Models. Financial Models. Conclusion.5. Network Models.Introduction. Transportation Models. Assignment Models. Minimum Cost Network Flow Models. Shortest Path Models. Project Scheduling Models. Conclusion.6. 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.7. 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.Part III: DECISION MAKING UNDER UNCERTAINTY.8. Decision Making Under Uncertainty.Introduction. Elements of a Decision Analysis. The PrecisionTree Add-In. Bayes? Rule. Multistage Decision Problems. Incorporating Attitudes Toward Risk. Conclusion.9. 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.10. Simulation Models.Introduction. Operations Models. Financial Models. Marketing Models. Simulating Games of Chance. Conclusion.11. Queuing Models.Introduction. Elements of Queuing Models. The Exponential Distribution. Important Queueing. Relationships. Analytical Queuing Models. Queuing Simulation Models. Conclusion.12. 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., In fact, the exercises are graded (not formally) in their level of difficulty, and there are plenty of them, giving the instructor plenty of room to assign a subset of the exercises that the instructor deems to be appropriate for the backgrounds and skill levels of the students studying from the book., The level of difficulty of the examples is varied, so that some examples are quite readily absorbed, whereas others require deeper study. The examples are nicely designed to lead into the exercise sets that follow them.
IllustratedYes
Dewey Decimal650.0285/554
Table Of ContentPart I: INTRODUCTION TO SPREADSHEET MODELING. 1. 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. 2. 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. Part II: DECISION MAKING UNDER CERTAINTY. 3. 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. 4. Linear Programming Models. Introduction. Advertising Models. Static Workforce Scheduling Models. Aggregate Planning Models. Blending Models. Production Process Models. Financial Models. Conclusion. 5. Network Models. Introduction. Transportation Models. Assignment Models. Minimum Cost Network Flow Models. Shortest Path Models. Project Scheduling Models. Conclusion. 6. 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. 7. 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. Part III: DECISION MAKING UNDER UNCERTAINTY. 8. Decision Making Under Uncertainty. Introduction. Elements of a Decision Analysis. The PrecisionTree Add-In. Bayes Rule. Multistage Decision Problems. Incorporating Attitudes Toward Risk. Conclusion. 9. 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. 10. Simulation Models. Introduction. Operations Models. Financial Models. Marketing Models. Simulating Games of Chance. Conclusion. 11. Queuing Models. Introduction. Elements of Queuing Models. The Exponential Distribution. Important Queueing. Relationships. Analytical Queuing Models. Queuing Simulation Models. Conclusion. 12. 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.
SynopsisKnowing 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., 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.
LC Classification NumberHF5695