Management Decision Making
Spreadsheet Modeling, Analysis and Application

A spreadsheet-based introduction to the tools and techniques of modern managerial decision making.

George E. Monahan (Author)

9781108835022, Cambridge University Press

Hardback, published 17 August 2000

0 pages
25.4 x 20.3 x 4 cm, 1.724 kg

Management Decision Making is a spreadsheet-based introduction to the tools and techniques of modern managerial decision making. The author shows how to formulate models in Microsoft Excel that can be used to analyse complex problems taken from all the functional areas of management, including finance, marketing, operations, and human resources. A broad range of analytical methods is discussed, including linear programming, integer linear programming, decision analysis, decision trees, queues, and Monte Carlo simulation. The book is aimed at students of business, economics and engineering, including those taking MBA courses. It will also be of great interest to business managers who want to learn more about practical spreadsheet modeling.

1. The science of managerial decision making
Part I. Decision Making Using Deterministic Models: 2. Introduction to linear programming models
3. Developing model formulation skills
4. More advanced linear decision problems
5. Output analysis I: small changes
6. Output analysis II: large changes
7. Integer linear programs
Part II. Decision Making Under Uncertainty: 8. Introduction to probability models
9. Decision making under uncertainty
10. Decision trees
11. Management of congested service systems
12. Monte Carlo simulation
Appendix. An Excel primer.

Subject Areas: Management & management techniques [KJM]