Management Science: The Art of Modeling with Spreadsheets, 3rd Edition

by Stephen G. Powell (Dartmouth College); Kenneth R. Baker (Dartmouth College)

• ISBN13: 9780470530672
• ISBN10: 0470530677
• Edition: 3rd
• Format: Hardcover
• Copyright: 2010-10-01
• Publisher: Wiley

Summary

Now in its third edition, Management Science helps business professionals gain the essential skills needed to develop real expertise in business modeling. The biggest change in the text is the conversion of software from Crystal Ball to Risk Solver to reflect changes in the field.

More coverage of management science topics has been added. Broader coverage of Excel demonstrates how to create models. Additional open-ended case studies that are less structured have also been included along with new exercises. These changes will help business professionals learn how to apply the information in the field.

New to this edition :

-Risk Solver Platform used instead of Crystal Ball, Premium Solver, Sensitivity Toolkit, and Treeplan.

-Use of Excel 2010 to show examples of spreadsheet modeling.

-New Chapter 14 on Evolutionary Solver.

-Revised Chapter 17 on Simulation Optimization.

Table of Contents

Introduction

Modeling in a Problem-Solving Framework

Basic Excel Skills

Advanced Excel Skills

Spreadsheet Engineering

Analysis using Spreadsheets

Data Analysis for Modeling

Regression Analysis

Short-term Forecasting

Nonlinear Optimization

Linear Optimization

Optimization of Network Models

Integer Optimization

Optimization of Non-smooth Models

Decision Analysis

Monte Carlo Simulation

Optimization in Simulation

Modeling Cases

Appendix: Basic Probability Concepts

Table of Contents provided by Publisher. All Rights Reserved.