MTU Library Catalogue

Syndetics cover image
Image from Syndetics

Spreadsheet modeling and decision analysis: a practical introduction to management science / Cliff T. Ragsdale.

By: Ragsdale, Cliff T, 1960-.
Material type: materialTypeLabelBookPublisher: Cincinnati : South-Western College Publishing, 1998Description: x, 742 p. ; 26 cm.ISBN: 0538867566.Subject(s): Management science -- Computer simulation | Operations research -- Computer simulation | Electronic spreadsheets | Decision making -- Computer simulationDDC classification: 658.403
Contents:
Introduction to modeling and decision analysis -- Introduction to optimization and linear programming -- Modeling and solving LP problems in a spreadsheet -- Sensitivity analysis and the simplex method -- Network modeling -- Integer linear programming -- Goal programming and multiple objective optimization -- Nonlinear programming -- Regression analysis -- Discriminant analysis -- Time series analysis -- Simulation -- Simulation using @risk -- Queueing theory -- Project management -- Decision analysis.

Enhanced descriptions from Syndetics:

Provides an introduction to the most commonly used management science techniques and shows how these tools can be implemented using Microsoft Excel 5.0 for Windows. It also focuses on developing both algebraic and spreadsheet modeling skills.

Diskette to accompany book available at desk.

Includes bibliographical references and index.

Introduction to modeling and decision analysis -- Introduction to optimization and linear programming -- Modeling and solving LP problems in a spreadsheet -- Sensitivity analysis and the simplex method -- Network modeling -- Integer linear programming -- Goal programming and multiple objective optimization -- Nonlinear programming -- Regression analysis -- Discriminant analysis -- Time series analysis -- Simulation -- Simulation using @risk -- Queueing theory -- Project management -- Decision analysis.

Table of contents provided by Syndetics

  • 1 Introduction to Modeling and Decision Analysis
  • 2 Introduction to Optimization and Linear Programming
  • 3 Modeling and Solving LP Problems in a Spreadsheet
  • 4 Sensitivity Analysis and The Simplex Method
  • 5 Network Modeling
  • 6 Integer Linear Programming
  • 7 Goal Programming and Multiple Objective Optimization
  • 8 Nonlinear Programming
  • 9 Regression Analysis
  • 10 Discriminant Analysis
  • 11 Time-Series Analysis
  • 12 Introduction to Simulation using Crystal Ball
  • 13 Queuing Theory
  • 14 Project Management
  • 15 Decision Analysis