At a specific oil refinery, the refining process requires the production of 1.5 gallons of gasoline for each gallon of fuel oil. To meet the refinery’s demand in the winter, the refinery will need to produce at least three million gallons of fuel oil a day. On the other hand, the demand for gasoline is predicted be no more than five million gallons a day. If gasoline sells for $1.80 per gallon and fuel oil sells for $1.60 per gallon, how much of each should be produced to maximize revenue, and how much revenue will the refinery earn?




At a specific oil refinery, the refining process requires the production of 1.5 gallons of gasoline...
File Home Insert Draw Page Layout Formulas Data Review View Help P ower Pivot Share Comments Calibri 0 T A D E 28 0 3 LA 11 C A A A General $ % === E ale Wrap Text Merge & Center er Paste BIU % 9 40.00 Insert Delete Format Ideas | Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas C23 X fic А в G...
please explain steps to solution using excel
9) You are hired as a consulting engineer to a small gasoline refinery. You must determine how many gallons of three different grades of gasoline should be produced to maximize total profit. The gallons produced should not exceed the storage capacity of each grade. Also, there is a maximum of 16,500 eallons of raw oil available to produce the gasoline. The material requirements to produce one gallon of each grade are summarized in...
(Blending & Refining LP optimization problem) American Oil of Middle East has a refinery in Kuwait. This refinery has access to two types of crude oils that come from Wafra Field: Ratawi Crude and Eocene Crude. The daily availability for Ratawi Crude and Eocene Crude are 300,000 bbl per day and 200,000 bbl per day, respectively. The Ratawi Crude costs the company $15 per bbl, and the Eocene Crude costs $20 per bbl. The refinery distills the crude oils and...
you are the manager of a large crude-oil refinery. as part of
the refining process, a ... Question: You are the manager of a
large crude-oil refinery. As part of the refining process, a
certain h... You are the manager of a large crude-oil refinery. As
part of the refining process, a certain heat exchanger (operated
at high temperatures and with abrasive material flowing through
it) must be replaced every year. The replacement and downtime cost
in the first year...
Problem 4 (15 Points) An oil refining company can purchase crude oil from 2 countries: Kuwait and Canada. One barrel of crude oil yields useable gasoline, jet fuel, and lubricant, in barrels, according to the following table (there is a 10% loss due to waste in the refining process): Product Yield (in barrels) Kuwait Canada 0.3 0.4 0.2 0.4 0.2 0.3 Gasoline Jet Fuel Lubricant Kuwait can offer up to 9000 barrels of crude oil at a cost of $20...
You are a Logistics manager for VKT Corp., and energy extraction and production company. A oil well in the company's portfolio is generating 10,000 barrels of crude oil per day in excess o present sale commitments. The crude oil can be sold as is on the commodities markets, or refined and converted into other products which may be sold for higher prices, and potential be worth more. You have been assigned to determine the company's best course of action. Prepare...
Seastrand Oil Company produces two grades of gasoline: regular and high octane. Both gasolines are produced by blending two types of crude oil. Although both types of crude oil contain the two important ingredients required to produce both gasolines, the percentage of important ingredients in each type of crude oil differs, as does the cost per gallon. The percentage of ingredients A and B in each type of crude oil and the cost per gallon are shown. Crude Oil Cost ...
Seastrand Oil Company produces two grades of gasoline: regular and high octane. Both gasolines are produced by blending two types of crude oil. Although both types of crude oil contain the two important ingredients required to produce both gasolines, the percentage of important ingredients in each type of crude oil differs, as does the cost per gallon. The percentage of ingredients A and B in each type of crude oil and the cost per gallon are shown. Crude Oil Cost...
Type or paste question here
A refinery produces two types of lubricating oil, type A and type B. To produce 1000 litres of type A oil requires two hours in process 1, two hours in process 2 and six hours in process 3. To produce 1000 litres of type B oil requires four hours in process 1, two hours in process 2 and three hours in process 3. The availability of the process 1 plant is twelve hours per day,...
Cal Overhaut operates an ExxonMobil gas station franchise in Fitzhugh, MD. The price of gasoline is volatile and varies greatly from day to day. The price per gallon varies based on the seasonal blend of gasoline, which is determined by clean-air requirements, and Cal's pricing choices are limited to the profit margin for his price. Base price of unleaded regular delivered in New York harbor (Sept 2018 060 Added cost to Cal: 0.335 0.184 0.090 0.030 He recently raised the...