10 Prescriptive Analytics Optimization and Simulation

Business Intelligence, Analytics, and Data
Science: A Managerial Perspective

Fourth Edition
Chapter 6
Prescriptive Analytics:
Optimization and
Simulation
Slides in this presentation contain hyperlinks. JAWS

users should be able to get a list of links by using
INSERT+F7
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Optimization via Mathematical
Programming
• Mathematical Programming
– A family of tools designed to help solve managerial
problems in which the decision maker must allocate
scarce resources among competing activities to
optimize a measurable goal
• Optimal solution: The best possible solution to a modeled
problem
– Linear programming (LP): A mathematical model for
the optimal solution of resource allocation problems.
All the relationships are linear.
LP Problem Characteristics
1. Limited quantity of economic resources

2. Resources are used in the production of products or
services
3. Two or more ways (solutions, programs) to use the
resources
4. Each activity (product or service) yields a return in terms
of the goal
5. Allocation is usually restricted by constraints
LP Problem Assumption
1. Returns from different allocations can be compared: that is,
they can be measured by common unit (E.g., dollars, utility)
2. The return from any allocation is independent of other
allocations
3. The total return is the sum of the returns yielded by the
different activities
4. All data are known with certainty
5. The resources are to be used in the most economical
manner
Linear Programming Steps
1. Identify the …
– Decision variables
– Objective function
– Objective function coefficients
– Constraints
▪ Capacities / Demands / …
2. Represent the model
– LINDO: Write mathematical formulation
– EXCEL: Input data into specific cells in Excel
3. Run the model and observe the results
Modeling in LP - An Example
The Product-Mix Linear Programming Model (for MBI Corporation)
• Decision variable: How many computers to build?

• Two types of mainframe computers: CC-7 and CC-8
• Constraints: Labor, Materials, and Marketing limits
Blank CC-7 CC-8 Rel Limit
Labor (days) 300 500 =
les than or equal to
200,000 /mo
Materials ($) 10,000 15,000 =
les than or equal to
8,000,000 /mo
Units 1 Blank =
greater than or equal to
100
Units Blank 1 =
greater than or equal to
200
Profit ($) 8,000 12,000 (Max) Blank
Objective: Maximize Total Profit / Month

LP Solution – Algebraic Formulations
LP Solution with Excel
Decision Variables:
X1  unit of CC - 7
X2  unit of CC - 8
Objective Function:
Maximize Z (profit)
z = 8000x1 + 12000x 2
Subject To
300X1 + 500X2  200K
10000X1 + 15000X 2  8000K
X1  100
X2  200
Illustrating the Power of Spreadsheet
Modeling Case Study 2
Modeling (1 of 3)
• Election Resource Allocation Problem (Data)
Modeling (2 of 3)
• Election Resource Allocation Problem (Formulation)
Multiple Goals, Sensitivity Analysis, What-
If Analysis, and Goal Seeking (1 of 4)
• Multiple Goals
– Simple-goal vs. multiple goals
– Vast majority of managerial problems has multiple
goals (objectives) to achieve
▪ Attaining all goals simultaneously
• Methods of handling multiple goals
– Goal programming
– Expression of goals as constraints, using LP
– A points system
• Certain difficulties may arise when analyzing multiple

goals:
– Difficult to obtain a single organizational goal
– The importance of goals change over time
– Goals and sub-goals are viewed differently
– Goals change in response to other changes
– Dynamics of groups of decision makers
– Assessing the importance (priorities)
• Sensitivity analysis
– It is the process of assessing the impact of change in
inputs on outputs
– Helps to …
▪ eliminate (or reduce) variables
▪ revise models to eliminate too-large sensitivities
▪ adding details about sensitive variables or scenarios
▪ obtain better estimates of sensitive variables
▪ alter a real-world system to reduce sensitivities
▪ …
– Can be automatic or trial and error
• What-if analysis
– Assesses solutions based on changes in variables or assumptions
(scenario analysis)
– What if we change our capacity at the milling station by 40% [what would
be the impact on output?]
• Goal seeking
– Calculate the values of the inputs necessary to achieve a desired level of
an output (goal)
– Backwards approach, starts with the goal and determines values of
inputs needed
– Example is break-even point determination
▪ In order to break even (profit = 0), how many products do we have to
sell each month?
What-If Analysis Example in Excel
Decision Analysis with Decision Tables and
Decision Trees
• Decision Tables – a tabular representation of the

decision situation (alternatives)
• Investment example:
– Goal: maximize the yield after one year
– Yield depends on the status of the economy (the
state of nature)
▪ Solid growth
▪ Stagnation
▪ Inflation
Decision Table – Investment Example:
Possible Situations
1. If solid growth in the economy, bonds yield 12%;

stocks 15%; time deposits 6.5%
2. If stagnation, bonds yield 6%; stocks 3%; time deposits
6.5%
3. If inflation, bonds yield 3%; stocks lose 2%; time
deposits yield 6.5%
Decision Table Investment Example:
Decision Table
• Payoff decision variables (alternatives)
• Uncontrollable variables (states of economy)
• Result variables (projected yield)
• Tabular representation:
Table 6.3 Investment Problem Decision Table Model

State of Nature (Uncontrollable Variables)
Alternative Solid Growth (%) Stagnation (%) Inflation (%)
Bonds 12.0 6.0 3.0
Stocks 15.0 3.0 –2.0
CDs 6.5 6.5 6.5
Decision Table Investment Example:
Treating Uncertainty
• Optimistic approach vs. pessimistic approach

• Treating Risk/Uncertainty:
– Use known probabilities (expected values)
• Multiple goals: yield, safety, and liquidity
Table 6.4 Multiple Goals
Alternative Yield (%) Safety Liquidity

Bonds 8.4 High High
Stocks 8.0 Low High
CDs 6.5 Very high High
Decision Trees
• Graphical representation of relationships
– Can be induced (driven) from data [data mining]
– Can be driven from experts [knowledge-driven]
• Multiple criteria approach
• Demonstrates complex relationships
• Cumbersome, if many alternatives exist
• Many tools exist:
– Mind Tools Ltd., mindtools.com
– TreeAge Software Inc., treeage.com
– Palisade Corp., palisade.com
Simulation
• Simulation is the “appearance” of reality

• It is often used to conduct what-if analysis on the model of
the actual system
• It is a popular DSS technique for conducting experiments
with a computer on a comprehensive model of the system
to assess its dynamic behavior
• Often used when the system is too complex for other DSS
techniques
Major Characteristics of Simulation
• Imitates reality and captures its richness both in shape

and behavior
– “Represent” versus “Imitate”
• Technique for conducting experiments
• Descriptive, not normative tool
• Often to “solve” [i.e., analyze] very complex
systems/problems
• Simulation should be used only when a numerical
optimization is not possible
Advantages of Simulation
• The theory is fairly straightforward

• Experiment with different alternatives
• The model reflects manager’s perspective
• Can handle wide variety of problem types
• Can include the real complexities of problems
• Produces important performance measures
• Often it is the only DSS modeling tool for non-structured
problems
Disadvantages of Simulation
• Cannot guarantee an optimal solution

– It is a descriptive model that can help develop
prescriptive outcomes
• Time-demanding and costly construction process
• Cannot transfer solutions and inferences to solve other
problems (models are problem specific)
• So easy to explain/sell to managers, may lead to
overlooking analytical/optimal solutions
• Software may require special skills/experience
Simulation Methodology
Model Development Steps: 4. Design experiments

1. Define problem 5. Conduct experiments
2. Construct the model 6. Evaluate results
3. Test and validate model 7. Implement solution
End of Chapter 6
• Questions / Comments
Copyright

10 Prescriptive Analytics Optimization and Simulation

Uploaded by

Copyright:

Available Formats

10 Prescriptive Analytics Optimization and Simulation

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

10 Prescriptive Analytics Optimization and Simulation

Uploaded by

Copyright:

Available Formats

Business Intelligence, Analytics, and Data

Science: A Managerial Perspective

Slides in this presentation contain hyperlinks. JAWS

1. Limited quantity of economic resources

• Decision variable: How many computers to build?

Objective: Maximize Total Profit / Month

• Election Resource Allocation Problem (Data)

• Election Resource Allocation Problem (Formulation)

• Certain difficulties may arise when analyzing multiple

• Decision Tables – a tabular representation of the

1. If solid growth in the economy, bonds yield 12%;

Table 6.3 Investment Problem Decision Table Model

• Optimistic approach vs. pessimistic approach

Table 6.4 Multiple Goals

Alternative Yield (%) Safety Liquidity

• Simulation is the “appearance” of reality

• Imitates reality and captures its richness both in shape

• The theory is fairly straightforward

• Cannot guarantee an optimal solution

Model Development Steps: 4. Design experiments

You might also like