Linear programming modeling.

User Generated

20C992

Engineering

Description

  • Correctly model the problem as a linear program. You must show the mathematical model. You must declare your decision variables, objective function, and constraints. Your solution must be written out completely and logically.
  • Solve your linear program using either the IBM ILOG CPLEX Optimization Studio or the Microsoft Excel Solver.
  • Please attach either the IBM ILOG CPLEX Optimization Studio or the Microsoft Excel Solver with the actual solution file.

Unformatted Attachment Preview

Coffeyville Resources Production Plan. Coffeyville Resources is a refinery located in Kansas. The refinery can process up to 100,000 barrels of crude oil per day into gasoline, diesel fuel, kerosene, asphalt base, and residual oil. Coffeyville Resources asked you to help the company determine an optimal production plan using a linear programming model. All products can be sold directly, other than residual oil, which must be blended with kerosene to generate heavy oil (composed of 10% of kerosene and 90% of residual oil) and light oil (composed of 20% of kerosene and 80% of residual oil). The refinery must comply with a contract that establishes a minimum and maximum number of barrels produced per day of each product. Table 1 shows these quantities and also the selling price of each product. Coffeyville Resources can buy crude oil from three different countries, which daily availabilities and purchase prices are presented in Table 2. Observe that at least 10,000 barrels per day must be purchased from Saudi Arabia. Due to U.S. regulations, each country is required to pre-process the number of barrels of crude oil purchased daily according to the percentages described in Table 2, so Coffeyville Resources can speed up their processing time in the U.S. Pre-processing each barrel of crude oil purchased from Kuwait, Saudi Arabia and Libya costs $0.90, $1.00, and $1.20, respectively
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is your assignment ;)

Gasoline

Diesel Fuel

Kerosene

Asphalt Base
...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags