Download
1 / 20
200 likes | 351 Views
Project 2: Petroleum Industry Management. Jack Porter Jarrod Phillips Scott Simon Weon Kim. Introduction.
E N D
Project 2: Petroleum Industry Management Jack Porter Jarrod Phillips Scott Simon WeonKim
Introduction • Our group provides consulting services to a petroleum company. We are to advise them on how to meet the demands of their customers for motor oil, diesel oil, and gasoline. The company has three plants and has decided not to store any excess production. • From a barrel of crude oil, factory #1 can produce 20 gallons of motor oil, 10 gallons of diesel oil, and 5 gallons of gasoline. Factory #2 can produce 4 gallons, 5 gallons, and 12 gallons, respectively, of motor oil, diesel oil, and gasoline. Factory #3 can produce 4 gallons, 5 gallons, and 12 gallons of motor oil, diesel oil, and gasoline.
Setting up a System of Equations • From the given specifications, we can set up a system of equations to represent the output of the factories: Motor Oil: 20f1 + 4f2 + 4f3 = x1 Diesel Oil: 10f1 + 14f2 + 5f3 = x2 Gasoline: 5f1 + 5f2 + 12f3 = x3 • Where f1,f2 , andf3 are the number of barrels of oil provided to each factory, and x1 ,x2 ,and x3 are the outputs of each product, respectively. We can then use these equations to find the amount of oil to give to each factory to meet a given demand.
Situation 1: First Demand • The first demand to meet is 5000 gallons of motor oil, 8500 gallons of diesel oil, and 10000 gallons of gasoline. Solving the system of equations gives us the input for each factory in barrels of oil, as shown in the table below:
Situation 2: Doubling the First Demand • Next, we are given the situation where the demand has doubled. The solution for the new system of equations is shown below: • It is observed that if demand doubles, then the barrels of oil doubles as well.
Situation 3: Second Demand • We are now given a different set of demands to meet: 2000 gallons of motor oil, 4000 gallons of diesel oil, and 4000 gallons of gasoline.
Situation 4: Adding the First and Second Demand • We now add the first and second demand to get 7000 gallons of motor oil, 12500 gallons of diesel oil, and 14000 gallons of gasoline. • The solution to the added demands is simply the solution of both demands added together. Each of these solutions is said to be unique because there is only one combination of inputs that allows the company to meet the required demand.
Sensitivity Analysis • Sensitivity analysis is performed by varying coefficients in the production equations and noting how this affects the solution. • We performed sensitivity analysis on our factories by varying the output of the first factory by ±3% individually for each product and recalculating the output for each variation. • A system that does not change much for modest changes in parameters is said to be robust.
Plant Three Shut Down In our next situation, factory #3 is shut down by the EPA. We need to find a way for the first two factories to meet the original demand. We can do this by using a least squares approximation. Let A be a 3 x 2 matrix representing the outputs of the first two factories and b the demand vector. A least squares approximation can be found for the input vector x with the following formula: (AT*A) -1AT*b = x This method gives an approximation for the inconsistent solution, but because it is an approximation, the estimate can be inexact. The table in the next slide demonstrates that in this case it is impossible for the two factories to produce exactly enough gasoline without severely overproducing diesel oil and motor oil.
Adding a 4th Plant The situation with the EPA has caused enough concern that the CEO of our company is considering buying another plant identical to the third. We can create another system of equations for this situation and solve it for our original demand:
Disposing of Paraffin Waste Each factory produces a certain amount of paraffin as waste per barrel of oil used. Specifically, factory #1 produces 3 gallons per barrel of oil, while factory #2 produces 5 gallons, and factory #3 produces 2 gallons. Supposing our petroleum company finds a candle company that will purchase the waste paraffin, we can use the amount of oil used for the original demand to determine how much paraffin can be supplied to the candle company.
Eliminating the First Plant • Due to aging equipment and high labor costs, the company is considering selling factory #1. They want to know how this would affect production capability. • Reverting to two factories would prevent the company from meeting the initial demand. This is because the initial demand is not a linear combination of the output of the two factories. • The company could again attempt to approximate production, but as shown earlier, approximation can result in extreme overproduction or underproduction.
Overdetermined Systems • With two factories producing three products, the demands that can be satisfied are severely limited. • When a system of equations has more equations than variables, that system is said to be overdetermined. An overdetermined system usually has no solutions. Eliminating the first plant would produce such a system. • In this situation, if the company added another plant that was identical to plant #2 or #3, the system would still be generally inconsistent since the output of the new plant would be a scalar multiple of an existing plant. To provide versatility, the output of any new factories should be linearly independent of existing ones.
Underdetermined Systems • Conversely, when a system of equations has more variables than equations, that system is said to be underdetermined. The earlier example with a 4th factory was an underdetermined system. • Underdetermined systems generally have an infinite number of solutions. • As far as our petroleum company is concerned, having more factories than products would allow for increased flexibility when meeting demand, especially if the output of the additional factories were linearly independent.
Unique Solutions • Finally, when a system of equations has the same amount of variables as equations, it generally has a unique solution. The first few situations in this presentation were all examples of unique solutions.
Conclusion • In conclusion, it is best for the company’s production to be an underdetermined system. This allows for increased flexibility, since a problem in one factory doesn’t prohibit the company from meeting demand. • A unique solution to the company’s production is also good, but in this case a factory shutdown will put production into an overdetermined situation, in which case it is impossible for the company to meet demand without overproducing any products.
