Thomson – 2007, 840 p.
ISBN: 0324656637
Spreadsheets are one of the most popular and ubiquitous software packages on the planet. Every day, millions of business people use spreadsheet programs to build models of the decision problems they face as a regular part of their work activities. As a result, employers look for experience and ability with spreadsheets in the people they recruit.
Spreadsheets have also become the standard vehicle for introducing undergraduate and graduate students in business and engineering to the concepts and tools covered in the introductory OR/MS course. This simultaneously develops students’ skills with a standard tool of today’s business world and opens their eyes to how a variety of OR/MS techniques can be used in this modeling environment. Spreadsheets also capture students’ interest and add a new relevance to OR/MS, as they see how it can be applied with popular commercial software being used in the business world.
Spreadsheet Modeling & Decision Analysis provides an introduction to the most commonly used OR/MS techniques and shows how these tools can be implemented using Microsoft Excel 2007. Prior experience with Excel is certainly helpful, but is not a requirement for using this text. In general, a student familiar with computers and the spreadsheet concepts presented in most introductory computer courses should have no trouble using this text. Step-by-step instructions and screen shots are provided for each example, and software tips are included throughout the text as needed.
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 & Evolutionary Optimization.
Regression Analysis.
Discriminant Analysis.
Time Series Forecasting.
Introduction to Simulation using Crystal Ball.
Queuing Theory.
Project Management.
Decision Analysis.