Description

Features

• Standard layout and format for creating effective Excel models–The authors use a standardized layout and format for creating spreadsheet models for all linear, integer, goal, and nonlinear programming problems.

  • Provides a consistent approach more suited to the beginning student of these decision models.

• Pedagogical use of color in the spreadsheets–As part of the standardized layout and format for the spreadsheet models, the authors have used colors in a consistent manner so that the various components of the models are easily identifiable.

  • Permits students to quickly identify the various components of each model so that they can focus on understanding the underlying decision model, rather than the Excel formulas.

• Numerous screen captures of Excel outputs with detailed callouts–Each screen shot has been annotated with detailed callouts explaining the important entries and components of the model.

  • Permits students to quickly understand the logic of the spreadsheet layout, and identify the appropriate Excel formulas and procedures for the various decision modeling techniques discussed in the text.

• Balance–Describes the algebraic model and its spreadsheet implementation for ALL examples. The spreadsheet layout then closely follows the algebraic model for ease of understanding.

  • Permits students to understand what they are doing, and whythey are doing it, rather than just mechanically learning which Excel formula to use or which Excel key to press.

• Discussion of LP sensitivity analysis using the Solver report is more comprehensive than any competing textbook!

  • Permits students to understand and analyze several issues such as the value of each resource, effect of simultaneous changes, and pricing-out of new products.

• The ability to teach topics both with or without the use of additional add-ins or software. Several topics can be studied either using Excel's standard built-in commands or using additional Excel add-ins or other software. For example, the text explains how Excel's built-in Data Table procedure can be used to replicate large simulation models, or, how Crystal Ball 2000 can be used to develop simulation models. Likewise, we have discussed how Microsoft Project 2000 can be used to effectively manage large projects.

  • Permits students to make effective use of Excel to analyze decision models even when special add-ins are not installed or available.

• Software packages are provided free on the student CD-ROM–Crystal Ball Professional 2000, Student Edition (140 days), Premium Solver for Education, TreePlan. In addition, all examples, set up in Excel files, are provided on the CD.

  • Permits students to easily see how all examples discussed in the text were solved, and replicate these if desired.

Table of Contents



 1. Introduction to Managerial Decision Modeling.


 2. Linear Programming Models: Graphical and Computer Methods.


 3. Linear Programming Modeling Applications: With Computer Analyses in Excel.


 4. Linear Programming Sensitivity Analysis.


 5. Transportation, Assignment, and Network Models.


 6. Integer, Goal, and Nonlinear Programming Models.


 7. Project Management.


 8. Decision Theory.


 9. Queuing Models.


10. Simulation Modeling.


11. Forecasting Models.


12. Inventory Control Models.


Appendix A: Useful Excel Commands and Procedures for Installing Excel Modules.


Appendix B: Probability Concepts and Applications.


Appendix C: Areas Under the Standard Normal Curve.


Appendix D: Solutions to Selected Problems.


Appendix E: Solutions to Self-Tests.

Courses

Management Science/Decision Modeling  [COMPREHENSIVE TEXTS]   (Decision Science)

Companion Website - Render
Render
©2003  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0130472530  |  ISBN-13: 9780130472533
Online purchase price: $46.67More Info

Downloadable Instructor Resources

Show All Downloadable Files

Hide All Downloadable Files

|

Help Downloading Files

Review Copy Managerial Decision Modeling with Spreadsheets and Student CD-ROM
Render, Stair & Balakrishnan
©2003  |  Prentice Hall  |  Cloth Bound w/CD-ROM  |  Out of Stock
ISBN-10: 013078382X  |  ISBN-13: 9780130783820
More Info

Companion Website - Render
Render
©2003  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0130472530  |  ISBN-13: 9780130472533
Online purchase price: $46.67More Info

Back to top

Companion Website - Render
Render
©2003  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0130472530  |  ISBN-13: 9780130472533
Online purchase price: $46.67More Info

Companion Website - Render
Render
©2003  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0130472530  |  ISBN-13: 9780130472533
Online purchase price: $46.67More Info

Back to top

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.