Spreadsheet Modeling and Decision Analysis

by Ragsdale, Cliff

• ISBN13: 9780324021226
• ISBN10: 0324021224
• Additional ISBN(s): 9780324183993, 9780538867566
• Edition: CD
• Format: Hardcover
• Copyright: 2000-06-15
• Publisher: South-Western College Pub
• More Book Details
• Purchase Benefits

Summary

Valuable software, realistic examples, and fascinating topics . . . everything you need to master the most widely used management science techniques using Microsoft Excel is right here! Learning to make decisions in today's business world takes training and experience. Cliff Ragsdale--the respected innovator in the field of management science--is an outstanding guide to help you learn the skills you need, use Microsoft Excel for Windows to implement those skills, and gain the confidence to apply what you learn to real business situations. SPREADSHEET MODELING AND DECISION ANALYSIS gives you step-by-step instructions and annotated screen shots to make examples easy to follow. Plus, interesting sections called The World of Management Science show you how each topic has been applied in a real company.

Table of Contents

Introduction to Modeling and Decision Analysis	1	(15)
Introduction to Optimization and Linear Programming	16	(28)
Modeling and Solving LP Problems in a Spreadsheet	44	(93)
Sensitivity Analysis and the Simplex Method	137	(40)
Network Modeling	177	(53)
Integer Linear Programming	230	(67)
Goal Programming and Multiple Objective Optimization	297	(39)
Nonlinear Programming & Evolutionary Optimization	336	(71)
Regression Analysis	407	(52)
Discriminant Analysis	459	(29)
Time Series Forecasting	488	(72)
Introduction to Simulation Using Crystal Ball	560	(68)
Queuing Theory	628	(33)
Project Management	661	(52)
Decision Analysis	713	(76)
Index	789