Route plan for getting crude oil from refineries to storage

Assignment Help Operation Management

Reference no: EM131692998

An oil company has three refineries and three storage/distribution facilities for its crude oil. The refining capacities and deman for each refinery and distribution facility, in the millions of barrels, and the avaiable routes and transportation costs, in thousands of dollars per million barrels, are given in the diagram below.

Supply Refinery Routes Storage/Distribution Demand

200 1 X14 (40) 4 250

1 X15 (30) 5 220

1 X16 (50) 6 200

150 2 X24 (35) 4

2 X25 (45) 5

2 X26 (40) 6

350 3 X34 (20) 4

3 X35 (50) 5

3 X36 (45) 6

Using your Excel/Solver toolset, determine the most efficient (least Costly) route plan for getting crude oil from refineries to storage/distribution facilities. Create a data table section with all data from the formulation in individual cells. Create a model section with cells for decision variables, objective function, and LHS and RHS columns of constraints. Find the optimal routing solution with solver.

Reference no: EM131692998

Questions Cloud

Tempted to go ahead regardless of high risks : Once money has been allocated to the process, people might become “hooked” into project and be tempted to go ahead regardless of high risks.

How the lean fundamentals of flow and inventory control : Determine how the lean fundamentals of flow and inventory control might improve one or more of the organizations:

Amoral and values-based and ethical : Compare and contrast Wicks' three theories of leadership: Amoral,Values-based and Ethical,

Opposition to business being involved in political process : Provide arguments in favor of and in opposition to business being involved in the political process.

Route plan for getting crude oil from refineries to storage : determine the most efficient (least Costly) route plan for getting crude oil from refineries to storage/distribution facilities.

What is the utilizatin of the gelato making process : hat is the capacity of the gelato making process (in kgs per hr)? What is the utilizatin of the gelato making process?

Financial ratios to measure wealth creation : What are the limitations of using only financial ratios to measure wealth creation?

Considering purchasing new blood analysis machine : Doctor J. is considering purchasing a new blood analysis machine to test for HIV;

You have noticed for each retailer in your response : What are the challenges you have noticed for each retailer in your response?

User Account

All Pages