l l ; . : , t r t r r . l t r c r r r . t i r e r . r . . ! , r r , i r . l t r r . L r t :l lrr , r! i : o . r t e r a P n A . t n r
p . r f: : , .L l. L r ! : ! _ l l - c r : . n ; : r u C r : e S t
FORMAL
SYSTEMS
ANDARRANGEMENTS
IN ORGANIZATIONS
1 0 0 r g a nz a t i o ns t r u c t u r e
11 0rganizationaltechnology
1 2 C o n t r oal n dl o b d e s r g n
1 3 H u m a nT e s o u r cm
e a n a g e m e
Chapter 13
Queuing Theory
13.0 Introduction
Sometimes it seems as if we spend most of our lives waiting in lines. We wait in lines at
grocery stores, banks, airports, hotels, restaurants, theaters, th
Chapter 1
Introduction to Modeling
and Decision Analysis
1.0 Introduction
This book is titled Spreadsheet Modeling and Decision Analysis: A Practical Introduction to
Management Science, so lets begin
Index
801
Index
A
ACA problem. See American Car Association (ACA) problem
Accuracy measures, 486487
descriptions, 486487
goodness of t, 487. See also Fit
mean absolute deviation (MAD), 487
mean absolu
Chapter 6
Integer Linear Programming
6.0 Introduction
When some or all of the decision variables in an LP problem are restricted to assuming
only integer values, the resulting problem is referred to a
Chapter 12
Introduction to Simulation
Using Crystal Ball
12.0 Introduction
Chapter 1 discussed how the calculations in a spreadsheet can be viewed as a mathematical model that denes a functional relat
Chapter 4
Sensitivity Analysis
and the Simplex Method
4.0 Introduction
In Chapters 2 and 3, we studied how to formulate and solve LP models for a variety
of decision problems. However, formulating and
Chapter 2
Introduction to Optimization
and Linear Programming
2.0 Introduction
Our world is lled with limited resources. The amount of oil we can pump out of the
earth is limited. The amount of land a
Chapter 7
Goal Programming and Multiple
Objective Optimization
7.0 Introduction
Chapter 6 discussed the modeling techniques that apply to optimization problems that
require integer solutions. This cha
Chapter 14
Project Management
14.0 Introduction
At some point, almost every manager assumes responsibility for the completion of some
type of project. The project might be relatively simplesuch as pla
Chapter 15
Decision Analysis
15.0 Introduction
The previous chapters in this book describe a variety of modeling techniques that can
help managers gain insight and understanding about the decision pro
Chapter 5
Network Modeling
5.0 Introduction
A number of practical decision problems in business fall into a category known as
network ow problems. These problems share a common characteristicthey can
Chapter 8
Nonlinear Programming &
Evolutionary Optimization
8.0 Introduction
Up to this point in our study of optimization, we have considered only mathematical
programming models in which the objecti
Chapter 3
Modeling and Solving
LP Problems in a Spreadsheet
3.0 Introduction
Chapter 2 discussed how to formulate linear programming (LP) problems and how to
solve simple, two-variable LP problems gra
Chapter 10
Discriminant Analysis
10.0 Introduction
Discriminant analysis (DA) is a statistical technique that uses the information available
in a set of independent variables to predict the value of a
Chapter 9
Regression Analysis
9.0 Introduction
Regression analysis is a modeling technique for analyzing the relationship between a
continuous (real-valued) dependent variable Y and one or more indepe
Chapter 11
Time Series Forecasting
11.0 Introduction
A time series is a set of observations on a quantitative variable collected over time. For
example, every night the evening news reports the closin