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
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
Nagraj Balakrishnan, University of Michigan, USA, Barry Render, Ralph M. Stair, Jr., Charles L. Munson, Washington State University
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