Decision Modeling With Microsoft Excel

by Moore, Jeffrey H.; Moore, Jeffrey H.; Weatherford, Lawrence R.

• ISBN13: 9780130177896
• ISBN10: 013017789X
• Edition: 6th
• Format: Hardcover
• Copyright: 2001-01-01
• Publisher: PRENTICE HALL

Summary

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.

Table of Contents

Preface	xii
Part 1 MODELS AND MODELING	1	(70)
Introduction to Modeling	2	(26)
Spreadsheet Modeling	28	(43)
Part 2 OPTIMIZATION MODELING	71	(326)
Linear Optimization	72	(67)
Linear Optimization: Sensitivity Analysis	139	(77)
Linear Optimization: Applications	216	(69)
Integer Optimization	285	(38)
Nonlinear Optimization	323	(74)
Part 3 PROBABILISTIC MODELS	397	(180)
Decision Analysis	399	(60)
Monte Carlo Simulation	459	(73)
Discrete Event Simulation	532	(45)
Part 4 IMPLEMENTATION	577	(24)
Implementation	578	(23)
APPENDICES	601
Appendix A Basic Concepts in Probability	601
Appendix B Excel Features Useful for Modeling	612
Appendix C Solver Tips and Messages	645
Appendix D Answers to Odd-Numbered Problems	664
CD-ROM CHAPTERS
Multi-Objective Decision Making and Heuristics	1
Forecasting	1
Project Management: PERT and CPM	1
Queuing	1
CD-Rom Enrichment Topics
Degeneracy	1
The Branch-and-Bound ILP Algorithm	1
Evolutionary Solver Advanced Features	1
Conditional Probability and Bayes' Theorem	1
Index	I-1