OPR
Case description
This case is about The Darby Company, a manufacturer and distributor of meters used in
measuring electrical consumption. The company is attempting to address the efficiency
issue of its current distribution system.
The Darby Company s
OPR 320: Additional Practice Questions for the Exam
Key Elements in LP Sensitivity Report by Excel
1. Shadow price of a constraint is the change in the objective for a unit increase of the R.H.S. of the
constraint (e.g., the amount of resource available).
OPR 320: LINEAR MODELS IN DECISION MAKING
Fall 2015-2016
ASSIGNMENT # 1
(Due at the beginning of class on Tuesday, October 6th)
1) Every LP must fall into one of the following cases:
Case 1: The LP has unique optimal solution.
Case 2: The LP has alterna
Example: A Blending Problem
Agri-Pro is a company that sells agricultural products to farmers in several
states. One service it provides to customers is custom feed mixing, whereby a
farmer can order a specific amount of livestock feed and specify the am
Loan Policy
OPR 320
Linear Models for Decision Making
A bank is in the process of devising a loan policy that involves a
maximum of $12 million. The following table provides the pertinent
data about available types of loans.
Bad debts are unrecoverable
Recap: Sensitivity analysis
OPR 320
Linear Models for Decision Making
Class 6: Sensitivity Analysis Part 2
More Examples on Sensitivity Analysis
Reduced Costs, Changes in Constraint Coefficients
LP gives a solution while assuming the parameters (unit cos
Marketing: Media Selection for Relax-and-Enjoy LDC
OPR 320
Linear Models for Decision Making
Class 7: Linear Programing Applications in Marketing
Relax-and-Enjoy Lake Development Corp (R&E) is developing a lakeside
community at a privately owned lake. The
PROBLEM 1
Departure gates
Flight A
Flight B
G1
G2
15
9
G3
0
10
10
6
Distance Between Gates
1 to 2
8
1 to 3
9
2 to 3
4
G1
A
B
0
0
A
B
Possible flight to gate assignments
G2
G3
Total Distance
B
0
186
A
0
0
A
B
0
B
A
0
0
B
0
0
A
0
Arrival gates
A
B
G1
G2
1
0
PROBLEM 1
mm“
.1
1‘
Distance Between Gates
—a
—a
I
n
_a
_Arri\'lai gtes ' _§51
_-a
_—au
Obiective: Minimize Total Distance Traveled by Passengers
r-‘I'Aq: '-u
,-
u- k
0E ~5¥€Iémﬂ x IN
IS
_. w _
. .,.
w?
‘
19' v
.V' r
i’ ~
, . ._
“4L;
_ 44,;
Recap: An Introductory LP Modeling Example.
!
OPR 320
Linear Models for Decision Making
The Philadelphia Liquor Company owns a small brewery that produces both wine-cooler
and beer for wholesale distribution. Two basic materials, hops and malt, are used t
Linear programming Example: Hot Tubs
Blue Ridge Hot Tubs manufactures and sells two models of hot tubs: the
Aqua-Spa and the Hydro-Lux.
Howie, the company owner, installs the same type of pump into both hot tubs.
The maximum availability of pumps for the
Ship
From
1 Newark
1 Newark
2 Boston
3 Columbus
5 Atlanta
5 Atlanta
5 Atlanta
6 Mobile
7 Jacksonville
7 Jacksonville
7 Jacksonville
To
Unit Cost
2 Boston
30
4 Richmond
40
3 Columbus
50
5 Atlanta
35
3 Columbus
40
4 Richmond
30
6 Mobile
35
5 Atlanta
25
4 Ri
Loading the Solver Add-in for Excel
Click the File tab, and then click Options.
Click Add-Ins, and then in the Manage box, select Excel Add-ins.
Click Go.
In the Add-Ins available box, select the Solver Add-in check box,
and then click OK.
After you load
Linear programming: An introductory example.
!
OPR 320
Linear Models for Decision Making
The Philadelphia Liquor Company owns a small brewery that produces both wine-cooler
and beer for wholesale distribution. Two basic materials, hops and malt, are used
Profit (Objection Funtion)
Amount to Produce
Profit Per Ton
Contstraints
Hops
Malt
Diversity
Demand
Cell Color Guide
Cells I can enter values in
manually
Cells Excel Solver Will
Select (Decision Variables)
Cells Automatically
Calculated
12.66666667
Wine C
Profit (Objection Funtion)
26740
Watermelons
Amount to Produce
Profit Per Acre
Contstraints
Water
Fertilizer
Acre
Cell Color Guide
Cells I can enter values in
manually
Cells Excel Solver Will
Select (Decision Variables)
Cells Automatically
Calculated
Cant
Problem 1 Excel
Profit (Objection Funtion)
Amount to Produce
Profit Per Acre
Contstraints
Water
Fertilizer
Acre
Cell Color Guide
Cells I can enter values in
manually
Cells Excel Solver Will
Select (Decision
Variables)
Cells Automatically
Calculated
26740
Profit (Objection Funtion)
70
A
Amount to Produce
Profit Per Ton
Contstraints
Greater than 10 ounces
Less than 15 ounces
At Least 1 A for every B
Half C equal to every A
Cell Color Guide
Cells I can enter values in
manually
Cells Excel Solver Will
Select
OPR 320 Linear Models for Decision Making
Syllabus
Fall 2015-16
(Revised September 16th)
Class Meets:
Tuesdays and Thursdays 4:00pm - 5:50pm, 219 G Hall
Instructor:
Dr. Oben Ceryan
Email:
[email protected]
Office Hours:
Tuesdays and Thursdays: 2:00pm - 3
1)
For Minimum Cost Network
Apply This Balance-of-Flow Rule At Each Node:
Flow Problems Where:
Total Supply > Total Demand Outflow -Inflow Supply or Demand
Total Supply < Total Demand Outflow -Inflow Supply or Demand
Total Supply = Total Demand Outflow -I
Introduction
!
!
Routine decisions: Short-term decisions
made on daily or weekly basis.
!
Non-routine decisions: Decisions that
have long-term consequences.
!
OPR 320
Linear Models for Decision Making
Businesses face many routine and/or
non-routine decisi
1
Instructor:AlexisGerardFingerTelephone:2158956818/2022
OfficeHours:Mon.Fri,after10:00Office:#48,Room109
Place:PSRC,Room104Email:[email protected]/
CRN30366
Humanities006:OralCommunicationSkillsforNonNativeSpeakers
1.All the worlds a stage and all the
Allocation of decision rights and the investment strategy of mutual funds
Nishant Dass, Vikram Nanda, Qinghai Wang
Strategy Overview
This paper studies how the allocation of control rights in mutual funds
affects their investment strategies using a sample
Auto-pay
Year 1
Revenues
Product/Service Costs
Marketing Costs
Customer Profit
% Customers that remain active
Profit expected on average
Discount Factor
Present Value of Expected Porfits
Installation Charge
Revenues from installation
Customer Lifetime Val