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.
The authors provide an introduction to managerial decision modeling, linear programming models, modeling applications and sensitivity analysis, transportation, assignment and network models, integer, goal, and nonlinear programming models, project management, decision theory, queuing models, simulation modeling, forecasting models and inventory control models.
The additional material files
Chapter 12
Excel files for each chapter
Excel modules for Windows
Excel modules for Mac
4th edition errata
can be found at https://www.degruyter.com/view/product/486941
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
