ie 3340 operations researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... ·...

69
IE 3340 Operations Research Lecture 3: Formulation of Linear Programming Problems Eduardo Perez, Ph.D. Ingram School of Engineering Texas State University 601 University Dr., San Marcos, TX 78666 [email protected] http://uweb.txstate.edu/~e_p86 E. Perez IE TXSTATE 1 Ch.2 Modeling with Linear Programming

Upload: vokhuong

Post on 02-Apr-2019

226 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

IE 3340 – Operations Research Lecture 3: Formulation of Linear Programming Problems

Eduardo Perez, Ph.D.

Ingram School of Engineering

Texas State University

601 University Dr., San Marcos, TX 78666

[email protected]

http://uweb.txstate.edu/~e_p86

E. Perez IE TXSTATE 1

Ch.2 Modeling with Linear Programming

Page 2: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Learning Objectives

E. Perez IE TXSTATE 2

Learn how to formulate linear programming models of real-life

situations

Page 3: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Today’s Agenda

Guidelines for Model Formulation

Diet Problem

Production Planning and Inventory Control

Multi-period Production Planning and Inventory Control

Manpower Planning

Bus Scheduling Model

Post Office

Urban Development Planning

Project Selection

Blending and Refining

E. Perez IE TXSTATE 3

Page 4: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Guidelines for Model Formulation

E. Perez IE TXSTATE 4

Page 5: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Formulation is like a Chess Game

E. Perez IE TXSTATE 5

I can teach you the rules, review “standard moves”, and discuss

examples.

But every game (problem) is different and requires thought.

Apply what you know: does this new problem fit a “standard

structure”?

Build a library of experience with a variety of problem types.

Page 6: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

The Formulation Process

E. Perez IE TXSTATE 6

Identify ___________________: what must be decided?

Identify & formulate the __________ of the problem (e.g., max profit or

min cost)

Identify __________: what resources are in limited supply?

Identify how decision variables must be ________ in constraints &

formulate constraints

Constraints must define the feasible values of all decision variables

Make dimensional analyses to make sure that the _________ and

each ___________ are consistent

Formulation is an iterative process

Propose a reasonable definition of variables and begin model formulation

If you cannot incorporate all issues, you will have learned how to redefine

variables to do so

decision variables

objective

constraints

related

objective

constraint

Page 7: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Diet Problem

E. Perez IE TXSTATE 7

Page 8: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

Many LP models arise from situations in which a decision maker

wants to minimize the cost of meeting certain requirements

Example: Bob wants to plan a nutritious diet, but he is on a limited

budget, so he wants to spend as little money as possible. His

nutritional requirements are as follows:

E. Perez IE TXSTATE 8

1. 2000 kcal

2. 55 g protein

3. 800 mg calcium

Page 9: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

Nutritional values

Bob is considering the following foods:

E. Perez IE TXSTATE 9

Food Serving Size Energy (kcal) Protein (g) Calcium (mg) Price per serving

Oatmeal 28 g 110 4 2 $0.30

Chicken 100 g 205 32 12 $2.40

Eggs 2 large 160 13 54 $1.30

Whole milk 237 cc 160 8 285 $0.90

Cherry pie 170 g 420 4 22 $0.20

Pork and beans 260 g 260 14 80 $1.90

Page 10: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

Question to be answered

Indices

Decision Variables

We can represent the number of servings of each type

of food in the diet by the variables:

E. Perez IE TXSTATE 10

How many servings of each type of food?

i = type of food

xi = number of servings food type i

x1 servings of oatmeal

x2 servings of chicken

x3 servings of eggs

x4 servings of milk

x5 servings of cherry pie

x6 servings of pork and beans

Page 11: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

Objective Function

E. Perez IE TXSTATE 11

Minimize Cost

Food Serving Size Energy (kcal) Protein (g) Calcium (mg) Price per serving

Oatmeal 28 g 110 4 2 $0.30

Chicken 100 g 205 32 12 $2.40

Eggs 2 large 160 13 54 $1.30

Whole milk 237 cc 160 8 285 $0.90

Cherry pie 170 g 420 4 22 $2.00

Pork and beans 260 g 260 14 80 $1.90

0.3x1 + 2.40x2 + 1.30x3 + 0.90x4 + 2.0x5 + 1.9x6

Page 12: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

Constraints

E. Perez IE TXSTATE 12

Food Serving Size Energy (kcal) Protein (g) Calcium (mg) Price per serving

Oatmeal 28 g 110 4 2 $0.30

Chicken 100 g 205 32 12 $2.40

Eggs 2 large 160 13 54 $1.30

Whole milk 237 cc 160 8 285 $0.90

Cherry pie 170 g 420 4 22 $2.00

Pork and beans 260 g 260 14 80 $1.90

x1

x2

x3

x4

x5

x6

Nutritional requirements 1. 2000 kcal

2. 55 g protein

3. 800 mg calcium

KCAL constraint:

110x1 + 205x2 + 160x3 + 160x4 + 420x5 + 260x6 2000

Page 13: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

A Diet Problem

LP Formulation

E. Perez IE TXSTATE 13

110x1 + 205x2 + 160x3 + 160x4 + 420x5 + 260x6 2000

4x1 + 32x2 + 13x3 + 8x4 + 4x5 + 14x6 55

2x1 + 12x2 + 54x3 + 285x4 + 22x5 + 80x6 800

Minimize

subject to:

0,,,,, 654321 xxxxxx

Cost

Nutritional requirements

Bounds

0.3x1 + 2.40x2 + 1.30x3 + 0.90x4 + 2.0x5 + 1.9x6

Page 14: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Production Planning and Inventory Control

E. Perez IE TXSTATE 14

Page 15: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Single Period Production ModelExample:

In preparation for the winter season, a clothing company is manufacturing

parka and goose overcoats, insulated pants, and gloves.

All products are manufactured in four different departments: cutting, insulating,

sewing, and packaging.

The company has received firm orders for its products.

The contract stipulates a penalty for undelivered items.

Devise an optimal production plan for the company based on the following data:

E. Perez IE TXSTATE 15

Page 16: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 16

Single Period Production Model

How many units of each type of product to produce?

i = type of product

xi = number of units of product type i

Page 17: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective

Function

E. Perez IE TXSTATE 17

Maximize the net profit, defined as: Total profit - Total penalty

The total penalty requires the use of a new variables s representing the shortage in

demand for product j

Single Period Production Model

The total profit: 30x1 + 40x2 + 20x3 + 10x4

The total penalty: 15s1 + 20s2 + 10s3 + 8s4

The objective function:

Max z = 30x1 + 40x2 + 20x3 + 10x4 – (15s1 + 20s2 + 10s3 + 8s4 )

Page 18: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 18

Single Period Production Model

Page 19: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 19

Maximize

subject to:

Profit

Bounds

Single Period Production Model

Page 20: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Multiperiod Production Planning and

Inventory Control

E. Perez IE TXSTATE 20

Page 21: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Multiperiod Production Planning and Inventory Control

Example:

Acme Manufacturing Company has a contract to deliver 100, 250, 190, 140,

220, and 110 home windows over the next 6 months.

Production cost (labor, material, and utilities) per window varies by period and

is estimated to be $50, $45, $55, $48, $52, and $50 over the next 6 months.

To take advantage of the fluctuations in manufacturing cost, Acme can

produce more windows than needed in a given month and hold the extra units

for delivery in later months.

This will incur a storage cost at the rate of $8 per window per month, assessed

on end-of-month inventory.

Develop a linear program to determine the optimum production schedule.

E. Perez IE TXSTATE 21

Page 22: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 22

Multiperiod Production Planning and Inventory Control

How many units to produce per month?

How many units left in inventory per month?

i = month of the year

Page 23: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Variables

The variables of the problem include the monthly production

amount and the end-of-month inventory. For i = 1, 2, …, 6

The relationship between these variables and the monthly

demand over the 6-month horizon is represented schematically

in the Figure. The system starts empty

E. Perez IE TXSTATE 23

Multiperiod Production Planning and Inventory Control

Page 24: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 24

Minimize the total cost of production and end-of-month inventory:

Multiperiod Production Planning and Inventory Control

Total production cost: 50x1 + 45x2 + 55x3 + 48x4 + 52x5 + 50x6

Total inventory (storage) cost: 8 (I1 + I2 + I3 + I4 + I5 + I6)

The objective function:

Min z = 50x1 + 45x2 + 55x3 + 48x4 + 52x5 + 50x6 + 8 ( I1 + I2 + I3 + I4 + I5 + I6)

Page 25: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 25

Multiperiod Production Planning and Inventory Control

The constraints of the problem can be determined directly from the figure

using the following balance equation:

Beginning inventory + Production amount - Ending inventory = Demand

Page 26: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 26

Minimize

subject to:

Cost

Bounds

Multiperiod Production Planning and Inventory Control

Page 27: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Manpower Planning

E. Perez IE TXSTATE 27

Page 28: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Bus Scheduling ProblemExample:

Progress City is studying the feasibility of introducing a mass-transit bus

system to reduce in-city driving. The study seeks the minimum number of

buses that can handle the transportation needs.

The minimum number of buses needed fluctuated with time of the day

The required number of buses could be approximated by constant values over

successive 4-hour intervals.

To carry out the required daily maintenance, each bus can operate 8

successive hours a day only

Develop a linear program to determine the optimum number of buses in operation.

E. Perez IE TXSTATE 28

Page 29: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 29

Bus Scheduling Problem

How many buses are needed per shift?

i = shift number

xi = number of buses needed in shift i

Page 30: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Variables

The variables of the model are the number of buses needed in

each shift

E. Perez IE TXSTATE 30

Bus Scheduling Problem

Page 31: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 31

Minimize the total number of buses in operation:

Bus Scheduling Problem

The objective function: Min z = x1 + x2 + x3 + x4 + x5 + x6

Page 32: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 32

Because of the overlapping of the shifts, the number of buses for the

successive 4-hour periods can be computed as

Bus Scheduling Problem

Page 33: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 33

Minimize

subject to:

Number of buses

Bounds

Bus Scheduling Problem

Page 34: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Post Office ProblemProblem:

A post office requires different numbers of full-time employees on different

days of the week.

Union rules state that each fulltime employee must five consecutive days and

then two days off.

The post office wants to meet its daily requirements using only full-time

employees.

Formulate an LP that the post office can use to minimize the number of full time

employees who must be hired.

E. Perez IE TXSTATE 34

Page 35: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 35

Post Office Problem

How many employees begin to work on each day ?

i = day of the week

xi = number of employees beginning work on day i

Page 36: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 36

Minimize the total number of employees:

Post Office Problem

Number of full time employees = # of employees who start to work on Monday + #

of employees who start to work on Tuesday + … + # of employees who start to

work on Sunday

The objective function: Min z = x1 + x2 + x3 + x4 + x5 + x6 + x7

Page 37: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 37

The post office must ensure that enough employees are working every day

Who is working on Monday?

Everybody except the employees who begin to work on Tuesday or on

Wednesday

They get, respectively, Sunday and Monday, and Monday and Tuesday off

To ensure that at least 17 employees are working on Monday we require

that the constraint

Post Office Problem

x1 + x4 + x5 + x6 + x7 ≥ 17

Page 38: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 38

Adding similar constraints for the other six days of the week:

Post Office Problem

x1 + x4 + x5 + x6 + x7 ≥ 17 (Monday constraint)

x1 + x2 + x5 + x6 + x7 ≥ 13 (Tuesday constraint)

x1 + x2 + x3 + x6 + x7 ≥ 15 (Wednesday constraint)

x1 + x2 + x3 + x4 + x7 ≥ 19 (Thursday constraint)

x1 + x2 + x3 + x4 + x5 ≥ 14 (Friday constraint)

x2 + x3 + x4 + x5 + x6 ≥ 16 (Saturday constraint)

x3 + x4 + x5 + x6 + x7 ≥ 11 (Sunday constraint)

x1, x2, x3, x4, x5, x6, x7, ≥ 0

Page 39: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 39

Minimize

subject to:

Total number of employees

Bounds

Post Office Problem

Min z = x1 + x2 + x3 + x4 + x5 + x6 + x7

x1 + x4 + x5 + x6 + x7 ≥ 17 (Monday constraint)

x1 + x2 + x5 + x6 + x7 ≥ 13 (Tuesday constraint)

x1 + x2 + x3 + x6 + x7 ≥ 15 (Wednesday constraint)

x1 + x2 + x3 + x4 + x7 ≥ 19 (Thursday constraint)

x1 + x2 + x3 + x4 + x5 ≥ 14 (Friday constraint)

x2 + x3 + x4 + x5 + x6 ≥ 16 (Saturday constraint)

x3 + x4 + x5 + x6 + x7 ≥ 11 (Sunday constraint)

x1, x2, x3, x4, x5, x6, x7, ≥ 0

Page 40: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Urban Development Planning

E. Perez IE TXSTATE 40

Page 41: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Urban Renewal ModelProblem:

The city of Erstville is faced with a severe budget shortage.

The city council votes to improve the tax base by condemning an

inner-city housing area and replacing it with a modern development.

The project involves two phases:

1. Demolishing substandard houses to provide land for the new

development and

2. Building the new development.

E. Perez IE TXSTATE 41

Page 42: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Urban Renewal ModelThe following is a summary of the situation:

1. As many as 300 substandard houses can be demolished. Each house

occupies a .25-acre lot. The cost of demolishing a condemned house is $2000.

2. Lot sizes for new single-, double-, triple-, and quadruple-family homes (units)

are .18, .28, .4, and .5 acre, respectively. Streets, open space, and utility

easements account for 15% of available acreage.

3. In the new development, the triple and quadruple units account for at least

25% of the total. Single units must be at least 20% of all units and double units

at least 10%.

4. The tax levied per unit for single, double, triple, and quadruple units is $1000,

$1900, $2700, and $3400, respectively.

5. The construction cost per unit for single-, double-, triple-, and quadruple-family

homes is $50,000, $70,000, $130,000, and $160,000, respectively.

6. Financing through a local bank is limited to $15 million.

How many units of each type should be constructed to maximize tax collection?

E. Perez IE TXSTATE 42

Page 43: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 43

Urban Renewal Model

How many units of each type should be constructed/demolish to

maximize tax collection?

i = type of home

xi = number of units of type of home i

Page 44: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Variables

The variables of the model are:

the number of units to be constructed of each type of housing,

the number houses must be demolished to make room for the new

development.

E. Perez IE TXSTATE 44

Urban Renewal Model

Page 45: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 45

Maximize total tax collection from all four types of homes

Urban Renewal Model

The objective function: Max z = 1000 x1 + 1900 x2 + 2700 x3 + 3400 x4

Page 46: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 46

The first constraint of the problem deals with land availability

The acreage needed for new homes =

To determine the available acreage, each demolished home occupies a .25-

acre lot, thus netting .25x5 acres.

Allowing for 15% open space, streets, and easements, the net acreage

available is .85 (.25x5 ) = .2125 x5 The resulting constraint is :

Urban Renewal Model

Page 47: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 47

The number of demolished homes cannot exceed 300, which translates to

The constraints limiting the number of units of each home type

Urban Renewal Model

Page 48: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 48

Keep the demolition/construction cost within the allowable budget

Expressing all the costs in thousands of dollars, we get

Urban Renewal Model

Page 49: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 49

Maximize

subject to:

Total tax collection

Bounds

Urban Renewal Model

Page 50: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Project Selection

E. Perez IE TXSTATE 50

Page 51: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Project Selection ProblemProblem: Star Oil Company is considering five different investment opportunities.

The cash out-flows and net present values (in millions) are given in the Table.

Star Oil has $40million available for investment now (time 0); it estimates that

one year from now (time1) $20 million will be available for investment.

Star Oil may purchase any fraction of each investment. In this case, the cash

outflows and NPV are adjusted accordingly. For example, if Star Oil purchases one-fifth of investment 3, then a cash outflow of (1/5)(5) =$1

million would be required at time 1. The one-fifth share of investment 3 would yield an NPV

of $3.2million.

Star Oil wants to maximize the NPV that can be obtained by investing

Formulate an LP that will help achieve this goal. Assume that any funds leftover at

time 0 cannot be used at time 1.

E. Perez IE TXSTATE 51

Page 52: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 52

Project Selection Problem

What fraction of each investment to purchase?

i = type of investment

xi = fraction of investment i to purchase by Star Oil

Page 53: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 53

Maximize the NPV earned from investments:

Project Selection Problem

The objective function: Max z = 13x1 + 16x2 + 16x3 + 14x4 + 39x5

Page 54: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 54

Star Oil’s constraints may be expressed as follows:

Constraint 1 Star cannot invest more than $40 million at time 0.

Constraint 2 Star cannot invest more than $20 million at time 1.

Constraint 3 Star cannot purchase more than 100% of investment

Project Selection Problem

Page 55: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 55

Constraint 1 Star cannot invest more than $40 million at time 0.

Constraint 2 Star cannot invest more than $20 million at time 1.

Constraint 3 Star cannot purchase more than 100% of investment

Project Selection Problem

Page 56: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 56

Maximize

subject to:

the NPV earned from investments

Bounds

Project Selection Problem

Page 57: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Blending and Refining

E. Perez IE TXSTATE 57

Page 58: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Blending and Refining Problem:

Shale Oil has a capacity of 1,500,000 bbl of crude oil per day.

The final products from the refinery include three types of unleaded

gasoline with different octane numbers (ON):

1. regular with ON = 87,

2. premium with ON = 89,and

3. super with ON = 92

The refining process encompasses three stages:

1. A distillation tower that produces feedstock (ON=82) at the rate of .2 bbl

per bbl of crude oil,

2. A cracker unit that produces gasoline stock (ON=98) by using a portion of

the feedstock produced from the distillation tower at the rate of .5 bbl per

bbl of feedstock, and

3. A blender unit that blends the gasoline stock from the cracker unit and the

feedstock from the distillation tower.

E. Perez IE TXSTATE 58

Page 59: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Blending and Refining Problem:

The company estimates the net profit per barrel of the three types of

gasoline to be $6.70, $7.20, and $8.10, respectively.

The input capacity of the cracker unit is 200,000 barrels of feedstock a

day.

The demand limits for regular, premium, and super gasoline are

50,000, 30,000, and 40,000 barrels, respectively, per day.

Develop a model for determining the optimum production schedule for the

refinery.

E. Perez IE TXSTATE 59

Page 60: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Question to be answered

Indices

Decision Variables

E. Perez IE TXSTATE 60

Blending and Refining

How many barrels/day to produce certain type of final product?

i = bbl/day of input stream i

j = blend of final product j

Page 61: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Variables

The variables can be defined in terms of two input streams to

the blender (feedstock and cracker gasoline) and the three final

products.

E. Perez IE TXSTATE 61

Blending and Refining

Page 62: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Objective Function

E. Perez IE TXSTATE 62

Maximize total profit

Blending and Refining

The objective function:

Max z = 6.70 (x11 + x21) + 7.20 (x12 + x22) + 8.10 (x13 + x23)

Page 63: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 63

Blending and Refining

Page 64: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 64

Blending and Refining

Daily crude oil supply does not exceed 1,500,000 bbl/day

Cracker unit input capacity does not exceed 200,000 bbl/day

Daily demand for regular does not exceed 50,000 bbl

Page 65: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 65

Blending and Refining

Daily demand for premium does not exceed 30,000:

Daily demand for super does not exceed 40,000 bbl::

Page 66: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 66

Blending and Refining

The octane number of a gasoline product is the weighted average of the

octane numbers of the input streams used in the blending process and can

be computed as:

Octane number (ON) for premium is at least 87:

Page 67: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Constraints

E. Perez IE TXSTATE 67

Blending and Refining

Octane number (ON) for premium is at least 89:

Octane number (ON) for premium is at least 92:

Page 68: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

LP Formulation

E. Perez IE TXSTATE 68

Maximize

subject to:

Revenue

Bounds

Blending and Refining

Page 69: IE 3340 Operations Researcheduardopr.weebly.com/uploads/9/1/3/6/9136035/lecture_optimization... · Many LP models arise from situations in which a decision maker wants to minimize

Questions?

E. Perez IE TXSTATE 69

Guidelines for Model Formulation

Diet Problem

Production Planning and Inventory Control

Multi-period Production Planning and Inventory Control

Manpower Planning

Bus Scheduling Model

Post Office

Urban Development Planning

Project Selection

Blending and Refining