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 under Supplementary Materials

Les mer

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

Les mer

Produktdetaljer

ISBN
9781501515101
Publisert
2017-08-07
Utgiver
De Gruyter
Vekt
1529 gr
Høyde
240 mm
Bredde
170 mm
Aldersnivå
U, 05
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
828

Biografisk notat

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