Management Science with Spreadsheet Modeling

Preface

Chapter 1 Introduction to Management Science
Introduction
What Is a Model?
The Modeling Process
Mathematical Models
Example 1: Building a Mathematical Model for Down to Earth Pottery
Summary
Key Terms
Exercises

Chapter 2 Spreadsheet Model Design in Excel
Introduction
Spreadsheet Design
Spreadsheet Formatting Tips
Using Excel
Example: Down to Earth Pottery  
Summary
Key Terms
Bibliography
Exercises

Chapter 3 Optimization of Linear Models
Introduction
Graphical Solution to Two Variable Linear Programs
Graphical Analysis of the Down to Earth Pottery Model
Optimal Solutions
Impact of Adding Constraints
Impact of Removing Constraints
Solving Linear Programs Using Excel with the Solver Add-in
Sensitivity Analysis
Summary
Key Terms
Exercises

Chapter 4 Optimization Applications
Introduction  
Multi-Period Production and Inventory Planning
Marketing Research
Summary of LP Formulation
Workforce Scheduling
Summary
Key Terms
Exercises

Chapter 5 Non-Linear Optimization
Introduction
Formulation of a Nonlinear Program (NLP)
Global and Local Optimal Solutions
Applications
Using Solver
Location Analysis
Asset Allocation in Financial Portfolios
Summary
Key Terms
Exercises

Chapter 6 Integer Modeling and Applications
Introduction
Integer and Binary Constraints
Formulating Integer Linear Programs
LP Relaxation
Solver Options with Integer Linear Programs  
Modeling Logical Conditions with Binary Variables
Integer Linear Programming Applications
Capital Budgeting
Spreadsheet Model
Fixed Cost Problems
Summary
Key Terms
Exercises

Chapter 7 Simulation Modeling
Introduction
Deterministic and Stochastic Models
Process for Developing and Using a Simulation Model
Simulation with Built-In Excel Functions
@RISK 142 Excel Reports
@RISK Simulations with Several Input Variables
Summary
Key Terms
Exercises

Chapter 8 Project Management
Introduction
Critical Path Method (CPM)
Critical Path Method Network Diagram
Models with Uncertain Activity Times
Time-Cost Trade Offs (Project Crashing)
Summary
Key Terms
Exercises

Chapter 9 Decision Analysis
Introduction
Decision Structure
Decision Criteria
Expected Value of Perfect Information (EVPI)
Decision Trees
Risk Analysis
Decision Analysis Software
Changing Probabilities and Values in Trees
Sensitivity Analysis Using PrecisionTree
Interpreting the Sensitivity Analysis Output
Tornado Chart
Summary
Key Terms
Exercises

Chapter 10 Multiple Criteria Decision Analysis
Introduction
domination and Efficient Solutions
Goal Programming
Frazee Motor Company
Solving the Goal Program
Summary
Key Terms
Exercises