The Steps in Implementing an
LP Model in a Spreadsheet
Chapter 3
Modeling and Solving LP
Problems in a Spreadsheet
1
Lets Implement a Model for the
Blue Ridge Hot Tubs Example.
1. Organise the data for the model on the
spreadsheet.
2. Reserve separate cel
Introduction
Chapter 7
Most of the optimization problems considered to
this point have had a single objective.
Often, more than one objective can be identified
for a given problem.
Maximize Return or Minimize Risk
Maximize Profit or Minimize Pollution
G
Introduction
Chapter 6
When one or more variables in an LP problem
must assume an integer value we have an
Integer Linear Programming (ILP) problem.
Integer Linear Programming
ILPs occur frequently
Scheduling workers
Manufacturing airplanes
Integer vari
Introduction
A number of business problems can be
represented graphically as networks.
This chapter focuses on several such problems:
Chapter 5
Network Modeling
Transshipment Problems
Shortest Path Problems
Maximal Flow Problems
Transportation/Assignment
Introduction
Chapter 4
When solving an LP problem we assume
that values of all model coefficients are
known with certainty.
Such certainty rarely exists.
Sensitivity analysis helps answer
questions about how sensitive the optimal
solution is to changes in
Introduction
Chapter 2
We all face decision about how to use
limited resources such as:
Introduction to Optimisation
and Linear Programming
Oil in the earth
Land for dumps
Time
Money
Workers
1
Mathematical Programming.
2
Applications of Optimisation
Home Runs
in Management Science
Chapter 1
Xerox
Developed Lean Document Production
solutions for the printing industry
Provides productivity and cost
improvements for print shops
Benefits:
Introduction to Modeling
& Problem Solving
$200 million in incr
Math 1293 - Decision Analysis Lab Chapter 4
Use Risk Solver Platform for Education (RSPE) V11 to solve the following questions.
1. Perform sensitivity analysis on the Electro-Poly Corporation problem discussed in the lecture. You can
use the Fig3-19.xlsm
Math 1293 - Decision Analysis Lab Chapter 4
Use Risk Solver Platform for Education (RSPE) V11 to solve the following questions.
1. Perform sensitivity analysis on the Electro-Poly Corporation problem discussed in the lecture. You can
use the Fig3-19.xlsm
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 3
1. Steelco manufactures three types of steel at different plants. The
time required to manufacture 1 ton of steel (regardless of type) and
the costs at each plant are shown in Table 8. Each
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 3
1. Steelco manufactures three types of steel at different plants. The time
required to manufacture 1 ton of steel (regardless of type) and the costs at
each plant are shown in Table 8. Each
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 2
1. Steelco manufactures two types of steel at three different steel mills. During a given month, each steel
mill has 200 hours of blast furnace time available. Because of differences in the
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 2
1. Steelco manufactures two types of steel at three different steel mills. During a given month, each steel
mill has 200 hours of blast furnace time available. Because of differences in the
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 1
O.J. Juice Company sells bags of oranges and cartons of orange juice. O.J. grades oranges on a scale of 1
(poor) to 10 (excellent). O.J. now has on hand 100,000 lb of grade 9 oranges and 120
Name:
Student ID:
Math 1293 - Decision Analysis Class Exercise 1
O.J. Juice Company sells bags of oranges and cartons of orange juice. O.J. grades oranges on a scale of 1
(poor) to 10 (excellent). O.J. now has on hand 100,000 lb of grade 9 oranges and 120