Decision Modeling with Microsoft Excel

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: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) Biographie de l'auteurJEFFREY 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 presentat