Managerial Decision Modeling: Business Analytics with Spreadsheets, Fourth Edition

by Nagraj (Raju) Balakrishnan, Barry Render, Ralph Stair, Charles Munson

Overview

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
• 4^th edition errata

can be found under Supplementary Materials

Product Details

ISBN-13:	9781501515101
Publisher:	De Gruyter
Publication date:	08/07/2017
Edition description:	4th ed.
Pages:	828
Product dimensions:	6.69(w) x 9.45(h) x (d)
Age Range:	18 Years

About the Author

Nagraj Balakrishnan, University of Michigan, USA, Barry Render, Ralph M. Stair, Jr., Charles L. Munson, Washington State University

Table of Contents

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