Managerial Decision Modeling: Business Analytics with Spreadsheets, Fourth Edition

ISBN-13: 9781501515101 / Angielski / Miękka / 2017 / 828 str.

Nagraj (Raju) Balakrishnan; Barry Render; Ralph Stair

Opis

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.

Spis treści

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

O autorze

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