OM
to specify that X1 must be at least 75% of the blend of X1, X2, and X3, we must have a constraint of the form
0.75X1>_X1+X2+X3
in The Goal, who's the unwanted visitor in chapter 1
Bill Peach
a particularly useful excel function in the formulation of transportation problems is the
SUMIF function
what is not necessarily a property of a good model
The model is based on a well-known algorithm
on the hike, herbie illustrates
a bottleneck
in excel if we want to copy a formula to another cell, but want one part of the formula to refer to a certain fixed cell, we would give that part
an absolute address
if we were interested in a model that would help us decide which rooms classes were to be held, we would probably use
an assignment model
constraints that prevent the objective function from improving are known as
binding
solutions to linear programming problems
can have multiple optimal solutions regarding the decision variables
in a balanced plant
capacity matches market demand
A first step in determining how well a model fits reality is to
check whether the model is valid for the current situation
in a network diagram, depicting a transportation problem, nodes are
circles
the feasible region in all linear programming problems is bounded by
constraints
in The Goal, releasing additional materials
creates additional inventory
what is a useful tool for investigating what-if questions
data tables
In using excel to solve linear programming problems, the changing cells represent the
decision variables
in The Goal, Jonah's first cue to Alex includes
dependent events and statistical fluctuations
an advertising model in which we try to determine how many excess exposures we can get at different given budget levels is an example of a
dual objective model
the decision variables in transportation problems are
flows
making constraints "integer" causes
integer values for decision values
one major problem caused by functional departmentation at a second level is
it can lead to duplication of efforts
in The Goal, a "balanced plant"
matches capacity to market demand
which is the type of model that is key to virtually every management science application
mathematical model
the objective in transportation problems is typically to
minimize costs
management science has often been taught as a collection of
models
In an optimization model, there can only be one
objective function
what is not one of the components of a mathematical model
opinions
Linear programming models have three important properties. They are
proportionality, additivity, and divisibility
what is a type of constraint that is often required in blending problems
quality constraint
When the profit increases with a unit increase in a resource, this change in profit will be shown in solver's sensitivity report as the
shadow price
the add-in allowing sensitivity analysis for any inputs that displays in tabular and graphical form is a
solver table
Defining an organization's problem includes
specifying the organization's objectives
In excel, the function that allows us to add up all of the products of two variables is called
sumproduct
In an assignment model of machines to jobs, the machines are analogous to what in a transportation problem
suppliers
a key benefit of using solvertable is
testing for sensitivity varying one or two input variables and automatically generating graphical results
The condition of non negativity requires that
the decision variables cannot be less than zero
the choice of organizational structure must depend upon
the organizations strategy
problems dealing with direct distribution of products from supply locations to demand locations are called
transportation problems
what is not one of the required arguments for a VLOOKUP function
true or false
Before trusting the answers to what-if scenarios from a spreadsheet model, a manager should attempt to
validate the model
optimization models are useful for determining
what the manager should do
workforce scheduling problems in which the worker schedules continue week to week are
wraparound problems
