Electronic Spreadsheet Modeling and Decision Analysis, 4th Edition

Author: CLIFFT, RAGSDALE
Publisher:
Publish Date: 2006-02-01
Features: Spreadsheets have become an important medium for teaching concepts and methods in introductory courses on management science/operations research. This book is a practical textbook for management science, primarily introducing commonly used management science/operations research methods and providing implementation methods using Microsoft Excel. In addition to the typical content of management science/operations research, such as linear programming, the simplex method and sensitivity analysis, network flow models, integer linear programming, goal programming and multi-objective optimization, nonlinear programming and iterative solution methods, simulation techniques, queuing problems, and decision analysis, the book also includes content on project management and statistical regression analysis, time series forecasting, and discriminant analysis. Using Microsoft Excel and some Excel add-ins as tools, it models and solves some common problems in actual business management. The book does not delve into mathematical derivations of the methods used but only briefly introduces the problems and then builds models in Microsoft Excel, using Microsoft Excel and its add-ins for solutions. This book is suitable as a textbook for undergraduate and graduate students studying management science courses, as well as for business professionals engaged in production management, operations management, and other fields, who can learn more methods and techniques for applying Microsoft Excel in business decision-making from this book.