Business students and business analysts.
· Provides effective methods for designing, building, and testing models, and for performing model-based analyses;
· Introduces non-technical, craft skills that expert modelers commonly employ, such as abstracting a situation, debugging a model, and translating model results into managerial insights; and
· Presents standard statistical and management science techniques used in business today, such as data analysis, simulation, and optimization.
· CD-ROM included with the book includes three of the leading software tools for business analysts: Premium Solver, Crystal Ball, and Sensitivity Toolkit.
Business professionals increasingly need to develop business models for application in their job. This updated edition provides the tools, software, and techniques to master spreadsheet modeling.
Successful business modeling is much more than a technical discipline; it's an art. The new Excel 2007 update of this innovative book covers spreadsheet engineering, management science techniques, and those essential craft skills needed to develop real expertise in business modeling. Readers will discover how to utilize effective methods for designing, building, and testing models, and for performing model-based analyses. And they'll learn about the standard statistical and management science techniques used in business today.
· Chapter 1: Introduction.
· Chapter 2 Modeling in a Problem-Solving Framework.
· Chapter 3 Basic Excel Skills.
· Chapter 4 Advanced Excel Skills.
· Chapter 5 Spreadsheet Engineering.
· Chapter 6 Analysis Using Spreadsheets.
· Chapter 7 Data Analysis for Modeling.
· Chapter 8 Regression Analysis.
· Chapter 9 Short-Term Forecasting.
· Chapter 10 Nonlinear Optimization.
· Chapter 11 Linear Programming.
· Chapter 12 Network Models.
· Chapter 13 Integer Programming.
· Chapter 14 Decision Analysis.
· Chapter 15 Monte Carlo Simulation.
· Chapter 16 Optimization in Simulation.
Modeling Cases.
Appendix: Basic Probability Concepts.
Index.
The new Excel 2007 update of this innovative book covers spreadsheet engineering, management science techniques, and those essential craft skills needed to develop real expertise in business modeling. Readers will discover how to utilize effective methods for designing, building, and testing models, and for performing model-based analysis.
· Chapter 1: Introduction.
· Chapter 2 Modeling in a Problem-Solving Framework.
· Chapter 3 Basic Excel Skills.
· Chapter 4 Advanced Excel Skills.
· Chapter 5 Spreadsheet Engineering.
· Chapter 6 Analysis Using Spreadsheets.
· Chapter 7 Data Analysis for Modeling.
· Chapter 8 Regression Analysis.
· Chapter 9 Short-Term Forecasting.
· Chapter 10 Nonlinear Optimization.
· Chapter 11 Linear Programming.
· Chapter 12 Network Models.
· Chapter 13 Integer Programming.
· Chapter 14 Decision Analysis.
· Chapter 15 Monte Carlo Simulation.
· Chapter 16 Optimization in Simulation.
Steve Powell is Professor at the Tuck School of Business at Dartmouth College. His primary research interest lies in modeling production and service processes, but he has also been active in research energy economics, marketing, and operations. At Tuck, he has developed a variety of courses in management science, including the core Decision Science course and electives in the Art of Modeling, Business Process Redesign, and Applications of Simulation. He originated the Teacher's Forum column in Interfaces, and has written a number of articles on teaching modeling to practitioners. He organized the Workshop on Teaching Management Science with Spreadsheet in the summer of 1998, and is the Academic Director of a new series of INFORMS workshops on teaching management science. In 2001, he was awarded the INFORMS Prize for the Teaching of Operations Research/Management Science Practice.
Ken Baker is a faculty member at Dartmouth College. He is currently Nathaniel Leverone Professor of Management at the Tuck School of Business and also Adjunct Professor at the Thayer School of Engineering. At Dartmouth, he has taught courses relating to Decision Science, Manufacturing Management, and Environmental Management. Over the years, much of his teaching and research has dealt with Production Planning and Control, and he is widely known for his textbook, Elements of Sequencing and Scheduling, in addition to a variety of technical articles. He has served as Tuck School's Associate Dean and directed the Tuck School's management development programs in the manufacturing area. In 2001, he was named a Fellow of INFORMS' Manufacturing and Service Operations Management (MSOM) Society.
