Decision Modeling with Microsoft® Excel: United States Edition
Autor Jeffrey H. Moore, Larry R. Weatherforden Limba Engleză Mixed media product – 15 ian 2001
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.
Preț: 724.29 lei
Preț vechi: 883.28 lei
-18% Nou
Puncte Express: 1086
Preț estimativ în valută:
138.59€ • 145.09$ • 114.68£
138.59€ • 145.09$ • 114.68£
Cartea nu se mai tipărește
Doresc să fiu notificat când acest titlu va fi disponibil:
Se trimite...
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9780130177896
ISBN-10: 013017789X
Pagini: 704
Dimensiuni: 203 x 254 mm
Greutate: 1.47 kg
Ediția:6Nouă
Editura: Pearson Education
Colecția Prentice Hall
Locul publicării:Upper Saddle River, United States
ISBN-10: 013017789X
Pagini: 704
Dimensiuni: 203 x 254 mm
Greutate: 1.47 kg
Ediția:6Nouă
Editura: Pearson Education
Colecția Prentice Hall
Locul publicării:Upper Saddle River, United States
Cuprins
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.
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.
Notă biografică
JEFFREY MOORE joined the faculty at Stanford's Graduate School of Business in 1972 after more than 10 years work as a Communications Engineer, Computer Systems Analyst, and Management Analyst. Since joining Stanford, he has designed and taught courses in the Operations and Information Technology area at the Executive, MBA and PHD levels. He teaches the core course in modeling and analysis and is a popular lecturer in six of Stanford's Senior Executive programs. In his research, he concentrates on decision support systems and computer use by senior executives. He has written more than 40 papers in these and other areas, and has done extensive consulting for private industry both nationally and internationally in the application of information technology and modeling for decision support. He has worked on several courseware projects to introduce Excel for modeling and decision support to graduate level MBA's and executives. This has included work under several grants from Microsoft, IBM, and Hewlett Packard, and early work with Frontline Systems in the testing and development of Excel's Solver, particularly the linear optimization options. In the late 1970s he pioneered one of the first courses to use spreadsheet modeling in a business school, and soon thereafter, orchestrated Stanford's conversion of its modeling core course to spreadsheets, the first major business school to do so. Since that time, he has been involved in the development of modeling and statistical applications of spreadsheets, and has developed GLP, Stanford's Graphical LP Optimizer, and Regress, an Excel-based regression add-in now used at Stanford, Duke, UCLA, and elsewhere. Earlier he served on the INFORMS Business School Educational Task Force which surveyed more than 300 university instructors in the teaching of management science and has made presentations at its conference on the important role spreadsheets should play in management education. He is also the Director of SunTELL, the Stanford Business School's Technology Educational Learning Laboratory, a facility funded by SUN Microsystems devoted to understanding the use of technology in management and in management education.
In 1996 and again in 1998, he received Stanford's Sloan Teaching Excellence Award for his core course in Decision Support Modeling. Dr. Moore holds a BSEE with specialty in digital circuit design from the University of Cincinnati, a joint MBA/CS degree from Texas A&M University, and a PhD in Business from the University of California at Berkeley. He also holds a Professional Engineer certification (E.E., Ohio).
LARRY R. WEATHERFORD is an Associate Professor in the College of Business at the University of Wyoming. He received his BA from Brigham Young University in 1982, and his MBA and PhD from the Darden Graduate School of Business at the University of Virginia in 1991. He received the Outstanding Teaching Award for the College of Business in his first year as a professor. In the ensuing years he has also earned the "Outstanding Faculty Member" award by Alpha Kappa Psi, the Outstanding Junior Research Award for the College of Business, and more recently the University-wide Ellbogen Meritorious Classroom Teaching Award. He has published 17 scholarly articles in such journals as Operations Research, Decision Sciences, Transportation Science, Naval Research Logistics, Cornell Hotel and Restaurant Administration Quarterly, International Journal of Technology Management, Journal of Combinatorial Optimization and Omega.
On the practitioner side, he has made over 48 presentations on five different continents to professional organizations. He has consulted with such major corporations as American Airlines, Northwest Airlines, Lufthansa, German Airlines, Swissair, Scandinavian Airlines, Air New Zealand, South African Airways, Unisys Corporation, Walt Disney World and Hilton Hotels, as well as many other smaller corporations.
On the personal side, Larry is married to the lovely Jenny and they 7 children (yes, they are all from the same union)! Most of his outside interests are centered in his family and church. Any other spare time is spent playing racquetball or golf or reading a fun book.
In 1996 and again in 1998, he received Stanford's Sloan Teaching Excellence Award for his core course in Decision Support Modeling. Dr. Moore holds a BSEE with specialty in digital circuit design from the University of Cincinnati, a joint MBA/CS degree from Texas A&M University, and a PhD in Business from the University of California at Berkeley. He also holds a Professional Engineer certification (E.E., Ohio).
LARRY R. WEATHERFORD is an Associate Professor in the College of Business at the University of Wyoming. He received his BA from Brigham Young University in 1982, and his MBA and PhD from the Darden Graduate School of Business at the University of Virginia in 1991. He received the Outstanding Teaching Award for the College of Business in his first year as a professor. In the ensuing years he has also earned the "Outstanding Faculty Member" award by Alpha Kappa Psi, the Outstanding Junior Research Award for the College of Business, and more recently the University-wide Ellbogen Meritorious Classroom Teaching Award. He has published 17 scholarly articles in such journals as Operations Research, Decision Sciences, Transportation Science, Naval Research Logistics, Cornell Hotel and Restaurant Administration Quarterly, International Journal of Technology Management, Journal of Combinatorial Optimization and Omega.
On the practitioner side, he has made over 48 presentations on five different continents to professional organizations. He has consulted with such major corporations as American Airlines, Northwest Airlines, Lufthansa, German Airlines, Swissair, Scandinavian Airlines, Air New Zealand, South African Airways, Unisys Corporation, Walt Disney World and Hilton Hotels, as well as many other smaller corporations.
On the personal side, Larry is married to the lovely Jenny and they 7 children (yes, they are all from the same union)! Most of his outside interests are centered in his family and church. Any other spare time is spent playing racquetball or golf or reading a fun book.
Textul de pe ultima copertă
This market-leading text emphasizes the fundamental concepts of modeling and the use of spreadsheets in a business decision-making context, taking a hands-on approach to creating decision models using spreadsheets. It exposes students to a variety of challenges a manager may face in the areas of marketing, finance, operations, and human resources so that students can develop appropriate modeling techniques to solve on-going business issues and provide clear solutions. This revised edition features a wealth of realistic, relevant examples to actively engage students in model building and analysis. All examples have been updated to reflect the latest Excel 2000 changes.
NEW TO THE SIXTH EDITION:
NEW TO THE SIXTH EDITION:
- Chapter on Discrete Event Simulation
- Chapter on Implementation
- Fully-updated chapter on Project Management
- Fully-updated chapter on Monte Carlo Simulation
- Additional Case Studies
- Additional basic and advanced homework problems at the end of most chapters
- Free Student CD-ROM containing:
- Premium Solver for Education
- Solver Table add-in software
- Crystal Ball Pro 2000 (140-day student version)
- Extend LT 4.0 (simulation software)
- TreePlan
- GLP, a graphic visualization program
- Excel templates (for in-text examples)
- Microsoft Project 2000 (120-day student version)
Caracteristici
- 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().
- 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. Ex.___
- 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. Ex.___
- Introduces students to both modeling philosophy and practical implementation issues. Ex.___
- 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. Ex.___
- Students learn marketable skills they will use immediately in their careers, and they develop valuable modeling habits and insights of longer term benefit. Ex.___
- 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).
- 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. Ex.___
- Aids students in debugging their optimization models. Ex.___
- 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.
This text is available for personalization in the PHCBR custom database program. Select only the chapters you require or supplement with recommended case studies all under one cover. CLICK HERE to go directly to the PHCBR book-build site or visit our product page for additional information at pearsoncustom.com/business.
Caracteristici noi
- --Revised chapter on general modeling with Excel.
- --More examples--Particularly simpler, introductory models.
- --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.
- --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().
- 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().
- --Expanded chapter on Monte Carlo Simulation featuring Crystal Ball Software--Includes examples on optimization of Excel simulation models via OptQuest.
- --New chapter on discrete event simulation--Introduces discrete event simulation with Extend.
- --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 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.
- --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.
- --Many more problems--At the end of most chapters (both basic skill problems and more advanced application problems).
- --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.