Beschreibung:
This book fills a void for a balanced approach to spreadsheet-based decision modeling. In addition to using spreadsheets as a tool to quickly set up and solve decision models, the authors show how and why the methods work and combine the user's power to logically model and analyze diverse decision-making scenarios with software-based solutions. The book discusses the fundamental concepts, assumptions and limitations behind each decision modeling technique, shows how each decision model works, and illustrates the real-world usefulness of each technique with many applications from both profit and nonprofit organizations.
Table of Contents Chapter 1 Introduction to Managerial Decision Modeling¿ Chapter 2 Linear Programming Models: Graphical and Computer Methods Chapter 3 Linear Programming Modeling Applications with Computer Analyses in Excel¿65 Chapter 4 Linear Programming Sensitivity Analysis Chapter 5 Transportation, Assignment, and Network Models Chapter 6 Integer, Goal, and Nonlinear Programming Models Chapter 7 Project Management Chapter 8 Decision Analysis Chapter 9 Queuing Models Chapter 10 Simulation Modeling Chapter 11 Forecasting Models Chapter 12 Inventory Control Models¿ ¿ Appendix A Probability Concepts and Applications Appendix B Useful Excel 2010 Commands and Procedures for Installing Excel Modules Appendix C Areas Under the Standard Normal Curve Appendix D Brief Solutions to All Odd-Numbered End-of-Chapter Problems