Managerial Decision Modeling with Spreadsheets, 3rd edition
Published by Pearson (December 31, 2011) © 2012
  • Nagraj Balakrishnan
  • Barry Render
  • Ralph M. Stair

Title overview

For courses on decision modeling through the use of spreadsheets.

The perfect balance between decision modeling and spreadsheet use.

It’s important that textbooks support decision modeling courses by combining student’s ability to logically model and analyze diverse decision-making scenarios with software-based solution procedures. Balakrishnan offers the perfect balance of the decision modeling process and the use of spreadsheets to set up and solve decision models.

The third edition has been updated to reflect the latest version of Excel.

 

For courses on decision modeling through the use of spreadsheets.

 

The perfect balance between decision modeling and spreadsheet use.

 

It’s important that textbooks support decision modeling courses by combining student’s ability to logically model and analyze diverse decision-making scenarios with software-based solution procedures. Balakrishnan offers the perfect balance of the decision modeling process and the use of spreadsheets to set up and solve decision models.

 

The third edition has been updated to reflect the latest version of Excel.


NEW! Present the latest: Updated Software Coverage.

  • All of the Excel coverage in this text has been updated to Excel 2007/2010.
  • The illustration of Microsoft Project and Crystal Ball has been updated to their latest versions.
  • The software program, Excel Modules, that accompanies this text has also been updated to suit Excel 2010 as well as 32-bit and 64-bit systems.

Provide a balanced approach: Three-step Framework. In this three-step framework, steps 1 and 3 (formulation and interpretation) call upon the manager’s expertise. Mastering the following steps will give students a competitive advantage later in the marketplace, when it’s necessary to make business decisions:

    1. Formulation or problem setup
    2. Model solution
    3. Interpretation of the results and what-if analysis

NEW! Offer plenty of practice: New and Revised End-of-chapter Problems. This edition includes many revised and several new exercises in the end-of-chapter material. On average, there are more than 45 end-of-chapter exercises per chapter. Many of these exercises include multipart questions, giving instructors a rich pool of questions from which to select.

 

NEW! Show today’s new techniques: New Topics. This text explains new techniques in linear programming, unbalanced transportation and transshipment models, and OptQuest.

 

Highlight the real-world implications: Decision Modeling in Action Boxes. These boxes summarize published articles that illustrate how real-world organizations have used decision models to solve problems.

 

NEW! Present the latest: Updated Software Coverage.

  • All of the Excel coverage in this text has been updated to Excel 2007/2010.
  • The illustration of Microsoft Project and Crystal Ball has been updated to their latest versions.
  • The software program, Excel Modules, that accompanies this text has also been updated to suit Excel 2010 as well as 32-bit and 64-bit systems.

NEW! Offer plenty of practice: New and Revised End-of-chapter Problems. This edition includes many revised and several new exercises in the end-of-chapter material. On average, there are more than 45 end-of-chapter exercises per chapter. Many of these exercises include multipart questions, giving instructors a rich pool of questions from which to select.

 

NEW! Show today’s new techniques: New Topics. This text explains new techniques in linear programming, unbalanced transportation and transshipment models, and OptQuest.

 

Highlight the real-world implications: Decision Modeling in Action Boxes. These boxes summarize published articles that illustrate how real-world organizations have used decision models to solve problems.

 

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

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

Online Chapter 12: Inventory Control Models

Appendix A: Probability Concepts and Applications
Appendix B: Useful Excel 2010 Commands and Procedures for Installing ExcelModules

Appendix C: Areas Under the Standard Normal Curve

Appendix D: Brief Solutions to All Odd-Numbered End-of-Chapter Problems

Loading...Loading...Loading...