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.
CD-ROM contains: Crystal Ball 2000 2 Professional Student Edition; ProblemSolver for Education v.5, Tree Plan vl 64 and maunal, and data files for examples, cases and projects.
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.
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.
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.
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.
