Spreadsheet Modeling and Decision Analysis


Book Description

Valuable software, realistic examples, and fascinating topics . . . everything you need to master the most widely used management science techniques using Microsoft Excel is right here! Learning to make decisions in today's business world takes training and experience. Cliff Ragsdale--the respected innovator in the field of management science--is an outstanding guide to help you learn the skills you need, use Microsoft Excel for Windows to implement those skills, and gain the confidence to apply what you learn to real business situations. SPREADSHEET MODELING AND DECISION ANALYSIS gives you step-by-step instructions and annotated screen shots to make examples easy to follow. Plus, interesting sections called The World of Management Science show you how each topic has been applied in a real company.




Management Decision Making


Book Description

CD-ROM contains: Crystal Ball -- TreePlan -- AnimaLP -- Queue -- ExcelWorkbooks.




Optimization Modeling with Spreadsheets


Book Description

Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features: Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models Network models that allow for a more general form of mass balance A systematic introduction to Data Envelopment Analysis (DEA) The identification of qualitative patterns in order to meaningfully interpret linear programming solutions An introduction to stochastic programming and the use of RSP to solve problems of this type Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office® Excel files to accompany the figures and data sets in the book. With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.




Business Analytics with Management Science Models and Methods


Book Description

This book is about prescriptive analytics. It provides business practitioners and students with a selected set of management science and optimization techniques and discusses the fundamental concepts, methods, and models needed to understand and implement these techniques in the era of Big Data. A large number of management science models exist in the body of literature today. These models include optimization techniques or heuristics, static or dynamic programming, and deterministic or stochastic modeling. The topics selected in this book, mathematical programming and simulation modeling, are believed to be among the most popular management science tools, as they can be used to solve a majority of business optimization problems. Over the years, these techniques have become the weapon of choice for decision makers and practitioners when dealing with complex business systems.




Decision Sciences


Book Description

This handbook is an endeavour to cover many current, relevant, and essential topics related to decision sciences in a scientific manner. Using this handbook, graduate students, researchers, as well as practitioners from engineering, statistics, sociology, economics, etc. will find a new and refreshing paradigm shift as to how these topics can be put to use beneficially. Starting from the basics to advanced concepts, authors hope to make the readers well aware of the different theoretical and practical ideas, which are the focus of study in decision sciences nowadays. It includes an excellent bibliography/reference/journal list, information about a variety of datasets, illustrated pseudo-codes, and discussion of future trends in research. Covering topics ranging from optimization, networks and games, multi-objective optimization, inventory theory, statistical methods, artificial neural networks, times series analysis, simulation modeling, decision support system, data envelopment analysis, queueing theory, etc., this reference book is an attempt to make this area more meaningful for varied readers. Noteworthy features of this handbook are in-depth coverage of different topics, solved practical examples, unique datasets for a variety of examples in the areas of decision sciences, in-depth analysis of problems through colored charts, 3D diagrams, and discussions about software.




Applied Management Science


Book Description

Emphasizes building the most appropriate model possible from the available data. * Major focus is on analysis and communication of results to management. Teaches readers how to conduct a management science study, analyze different situations, break down the steps of problem-solving, write a business report, and effectively communicate study results to management. * A supporting CD-ROM is packaged with every book to include three complete additional chapters, additional cases and problems for every chapter, coverage of key algorithms and derivations, a review of statistics, the complete WINQSB package developed by Yih-Long Chang, and Excel files for every chapter. * Computer Integrated Approach: Use of Excel, WinQSB, and LINDO for windows integrated throughout text for use in solving models.




Data Mining for Business Analytics


Book Description

Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python presents an applied approach to data mining concepts and methods, using Python software for illustration Readers will learn how to implement a variety of popular data mining algorithms in Python (a free and open-source software) to tackle business problems and opportunities. This is the sixth version of this successful text, and the first using Python. It covers both statistical and machine learning algorithms for prediction, classification, visualization, dimension reduction, recommender systems, clustering, text mining and network analysis. It also includes: A new co-author, Peter Gedeck, who brings both experience teaching business analytics courses using Python, and expertise in the application of machine learning methods to the drug-discovery process A new section on ethical issues in data mining Updates and new material based on feedback from instructors teaching MBA, undergraduate, diploma and executive courses, and from their students More than a dozen case studies demonstrating applications for the data mining techniques described End-of-chapter exercises that help readers gauge and expand their comprehension and competency of the material presented A companion website with more than two dozen data sets, and instructor materials including exercise solutions, PowerPoint slides, and case solutions Data Mining for Business Analytics: Concepts, Techniques, and Applications in Python is an ideal textbook for graduate and upper-undergraduate level courses in data mining, predictive analytics, and business analytics. This new edition is also an excellent reference for analysts, researchers, and practitioners working with quantitative methods in the fields of business, finance, marketing, computer science, and information technology. “This book has by far the most comprehensive review of business analytics methods that I have ever seen, covering everything from classical approaches such as linear and logistic regression, through to modern methods like neural networks, bagging and boosting, and even much more business specific procedures such as social network analysis and text mining. If not the bible, it is at the least a definitive manual on the subject.” —Gareth M. James, University of Southern California and co-author (with Witten, Hastie and Tibshirani) of the best-selling book An Introduction to Statistical Learning, with Applications in R




Handbook of Decision Analysis


Book Description

A ONE-OF-A-KIND GUIDE TO THE BEST PRACTICES IN DECISION ANALYSIS Decision analysis provides powerful tools for addressing complex decisions that involve uncertainty and multiple objectives, yet most training materials on the subject overlook the soft skills that are essential for success in the field. This unique resource fills this gap in the decision analysis literature and features both soft personal/interpersonal skills and the hard technical skills involving mathematics and modeling. Readers will learn how to identify and overcome the numerous challenges of decision making, choose the appropriate decision process, lead and manage teams, and create value for their organization. Performing modeling analysis, assessing risk, and implementing decisions are also addressed throughout. Additional features include: Key insights gleaned from decision analysis applications and behavioral decision analysis research Integrated coverage of the techniques of single- and multiple-objective decision analysis Multiple qualitative and quantitative techniques presented for each key decision analysis task Three substantive real-world case studies illustrating diverse strategies for dealing with the challenges of decision making Extensive references for mathematical proofs and advanced topics The Handbook of Decision Analysis is an essential reference for academics and practitioners in various fields including business, operations research, engineering, and science. The book also serves as a supplement for courses at the upper-undergraduate and graduate levels.




Business Analytics


Book Description

Now in its fifth edition, Powell and Baker’s Business Analytics: The Art of Modeling with Spreadsheets provides students and business analysts with the technical knowledge and skill needed to develop real expertise in business modeling. In this book, the authors cover spreadsheet engineering, management science, and the modeling craft. The briefness & accessibility of this title offers opportunities to integrate other materials –such as cases -into the course. It can be used in any number of courses or departments where modeling is a key skill.




Practical Management Science


Book Description

This text takes an active-learning approach, providing numerous examples and problems so students can practice extensively with a concept before moving on. Four types of problems -- skill-building, skill-extending, modeling, and cases are graded within sections and chapters to help instructors assign homework. Another important feature is the way that the text integrates modeling into all functional areas of business: finance, marketing, operations management using real examples and real data. The text emphasizes modeling over algebraic formulations and memorization of particular models. Shell files are also provided so that instructors can give students as much or as little information as they need.