Introduction to Management Science with Spreadsheets and Student CD

by Stevenson, William J.; Ozgur, Ceyhun

• ISBN13: 9780073252902
• ISBN10: 0073252905
• Edition: 1st
• Format: Hardcover
• Copyright: 2006-02-13
• Publisher: McGraw-Hill/Irwin

Summary

This text combines the market leading writing and presentation skills of Bill Stevenson with integrated, thorough, Excel modeling from Ceyhun Ozgur. Professor Ozgur teaches Management Science, Operations, and Statistics using Excel, at the undergrad and MBA levels at Valparaiso University --and Ozgur developed and tested all examples, problems and cases with his students. The authors have written this text for students who have no significant mathematics training and only the most elementary experience with Excel.

Table of Contents

Introduction to Management Science with Spreadsheets

Part 1 Introduction and Forecasting

1-Introduction to Management Science, Modeling, and Excel Spreadsheets

2- Forecasting

Part 2 Deterministic Decision Models

3-Linear Programming: Basic Concepts and Graphical Solutions

4-Linear Programming: Applications and Solutions

5- Linear Programming: Sensitivity Analysis, Duality, and Specialized Models.

6- Transportation, Assignment, and Transshipment Problems

7- Integer Programming

8- Network Optimization Models

9- Nonlinear Optimization Models

10- Multi-Criteria Models

Part 3 Probabilistic Decision Models

11- Decision Theory

12- Markov Analysis

13- Waiting Line Models

14- Simulation

CDRom Modules

Chapter 4S Simplex Algorithm

Chapter 6S Transportation and Assignment Solution

Procedures

Chapter 7S Branch and Bound Method for Integer

Programming Problems

Chapter 9S Mini Review: Differential Arithmetic