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

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 solution with Solver.

Transcribed Image Text:

Storage/ Distribution Refineries Supply: Demand: 1 4 200 250 20 35 150 2 220 45 Xs 50 50 Xm 40 350 200 3 700 670 28 29 Storage/ Distribution Refineries Supply: Demand: 1 4 200 250 20 35 150 2 220 45 Xs 50 50 Xm 40 350 200 3 700 670 28 29

Answer rating: 100% (QA)

Let the varibles for no of barrels transported from a refinery to a storage f... View the full answer