English version

• polskie
podział tematyczny
 
• anglojęzyczne
podział tematyczny
 
Newsletter:

• Zamów informacje o nowościach z wybranego tematu
 
Informacje:

• o księgarni

• koszty wysyłki

• kontakt

• Cookies na stronie

Decision Modeling with Microsoft Excel

For undergraduate/MBA-level courses in Management Science and Decision Modeling.

This text introduces students to the key ideas of modeling and management decision making that will be important to them throughout their careers. Addressing the needs of students interested in both business administration and decision science careers, it provides a conceptual foundation for all topics and the role of spreadsheet modeling techniques in the larger context of business decision-making. It features a wealth of realistic, relevant examples updated to reflect the latest Excel 2000 version, and actively engages students in model building and analysis. An accompanying CD-ROM contains extensive software application packages students will use long after the course is completed.

Features
NEW--Revised chapter on general modeling with Excel.
NEW--More examples--Particularly simpler, introductory models.
NEW--Streamlined, integrated, single-chapter coverage of graphical and sensitivity analysis--Introduces SolverTable, an add-in that extends Excel's Data Table to perform parametric analysis of optimization models, including all solution numbers and also tabulations of Sensitivity Report numbers, such as shadow prices.
NEW--Introduction of new Evolutionary Solver--Based upon a genetic search algorithm.

Illustrates applications that previously frustrated students' attempts to analyze highly non-linear models that make use of Excel's non-smooth functions, such as =IF().
NEW--Expanded chapter on Monte Carlo Simulation featuring Crystal Ball Software--Includes examples on optimization of Excel simulation models via OptQuest.
NEW--New chapter on discrete event simulation--Introduces discrete event simulation with Extend.
NEW--Expanded chapter on Project Management--Includes both approaches to project modeling, activities on arcs, and activities on nodes via use of the software package MS Project for Windows.
NEW--New chapter on Implementation--Focuses on organizational and management issues surrounding institutionalization of a model, and includes an extensive real-world case for class discussion of this critically important topic.
NEW--Additional case material--Features over a dozen new cases added across chapters; an optional evolving six-part theme case for applying optimization topics; and a new chapter with an extensive real-world case devoted to practical problems of implementing models.
NEW--Many more problems--At the end of most chapters (both basic skill problems and more advanced application problems).
NEW--Optional Enrichment Topics--Moved to the book's CD-ROM. Considers, for example, degeneracy, branch and bound algorithms, Evolutionary Solver advanced features, and conditional probability and Bayes' theorem.
Strong conceptional foundations developed for all major topics--E.g., Modeling Philosophy; General Excel Modeling; Optimization; Decision Analysis; Multi-Objective Decision Making; Forecasting; Probability Theory.
A strong focus on models--What they are, how they are created, how they are used, what kinds of insights they provide--and on the critical importance of managerial judgment in utilizing those insights.

Introduces students to both modeling philosophy and practical implementation issues.
A very "hands on" approach--To modeling many different challenges a business may face in the areas of operations, finance, human resources, marketing, the public sector, etc.

Students learn marketable skills they will use immediately in their careers, and they develop valuable modeling habits and insights of longer term benefit.
Spreadsheet applications and examples in Microsoft Excel--Features step-by step instructions for building and analyzing decision making models in Excel, with emphasis on "hands on" use of Excel and its add-ins (e.g., Solver, Crystal Ball, @Risk, and TreePlan).

CD-ROM CONTENTS
The graphic visualization program, GLP-For interactive optimization of linear programming models.
Premium Edition Solver for Education-Including infeasibility and non-linear diagnostic reports.
Aids students in debugging their optimization models.
SolverTable add-in software-For parametric analysis, including tabulating Sensitivity Report numbers, of optimization models.
Evolutionary Solver (Part of Premium Edition Solver for Education)-For performing genetic search on models having highly nonlinear or nonsmooth relationships.
Professional (time-limited) version of the Monte Carlo simulation add-in, Crystal Ball.
Professional (time-limited) version of the Monte Carlo simulation optimizer OptQuest.
Decision analysis add-in software, TreePlan.
Student version of the discrete event simulation package Extend.
Student versions of the Manufacturing and BusinessProcess Reengineering simulation library extensions to the simulation package Extend.
Voice annotated "playback" demonstrations-On use of the major Excel modeling techniques and add-ins.
Excel templates for queuing model calculations.
Excel spreadsheet files-For all in-text examples and any relevant data for end-of-chapter problems and cases.

Table of Contents

I. MODELS AND MODELING.

1. Introduction to Modeling.
2. Spreadsheet Modeling.

II. OPTIMIZATION.

3. Linear Optimization.
4. Linear Programming: Sensitivity Analyis.
5. Linear Programming Applications.
6. Integer Optimization.
7. Nonlinear Optimization.

III. PROBABILISTIC MODELS.

8. Decision Analysis.
9. Monte Carlo Simulation.
10. Discrete-Event Simulation.

IV. IMPLEMENTATION.

11. Implementation.

CD CHAPTERS.

12. Multi-Objective Decision Making and Heuristics.
13. Forecasting.
14. Project Management.

ENRICHMENT TOPICS (ON CD).

Degeneracy.
Branch & Bound.

Instructors Supplements

Instructor's Solutions Manual (ISBN: 0130406279)
Test Item File (ISBN: 0130406295)
WIN PH Test Manager (ISBN: 0130406201)
Instructor's Resource CD (ISBN: 0130406317)

Paperback
693 pages + CD