Question

In: Advanced Math

An oil company produces gasoline from five inputs. The cost, density, viscosity, and sulfur content, and...

An oil company produces gasoline from five inputs. The cost, density, viscosity, and sulfur content, and the number of barrels available of each input are listed in the file PO4_78.xlsx. Gasoline sells for $75 per barrel. Gasoline can have a density of at most .95 units per barrel, a viscosity of at most 35 units per barrel, and a sulfur content of at most 3.3 units per barrel. How can the company maximize its profit.

Solutions

Expert Solution


Related Solutions

Compare the differences in viscosity and density of water (SG = 1) and gasoline (SG =...
Compare the differences in viscosity and density of water (SG = 1) and gasoline (SG = 0.803). Determine the pressure at the bottom of a 8m high tank that is filled with water, and compare it to the pressure at the bottom if the tank is filled with gasoline. Calculate the volumetric and mass flow rates of the two fluids in a 0.10m diameter pipe moving at a velocity of 4.2 m/s.
Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30...
Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline contains 0.6 gallons of grade A crude oil. For the next production period, Southern has 18,000 gallons of grade A crude oil available. The refinery used to produce the gasolines has a production...
Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30...
Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline contains 0.6 gallons of grade A crude oil. For the next production period, Southern has 18,000 gallons of grade A crude oil available. The refinery used to produce the gasolines has a production...
Seastrand Oil Company produces two grades of gasoline: regular and high octane. Both gasolines are produced...
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  ...
Problem 7-41 Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions...
Problem 7-41 Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline contains 0.6 gallons of grade A crude oil. For the next production period, Southern has 18,000 gallons of grade A crude oil available. The refinery used to produce the gasolines has...
Brown Oil Company transports gasoline to its distributors by truck.  The company recently contracted to supply gasoline...
Brown Oil Company transports gasoline to its distributors by truck.  The company recently contracted to supply gasoline distributors in southern Ohio, and it has $1,600,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks (e.g. capital expenditures).   Three models of gasoline tank trucks are available:   Truck Model Monthly Truck Capacity (Gallons) Purchase Cost Monthly Operating Cost, including Depreciation Sub 100 75000 $200,000 $1,550 Oiler J 62500 $160,000 $1,425 Texan 30000 $100,000 $1,350 The company estimates that the...
How should we expect the cost of oil to affect the cost of producing gasoline, diesel...
How should we expect the cost of oil to affect the cost of producing gasoline, diesel and other oil-based products in the US and other parts of the world? Why?
Ko-Ka-Ku Limited produces three main products from a joint manufacturing process. Fuel oil, gasoline, Kerosene and...
Ko-Ka-Ku Limited produces three main products from a joint manufacturing process. Fuel oil, gasoline, Kerosene and Crude-I are the products emerging from the joint manufacturing process. Crude-I is aby-product and is sold at split-off, while the joint products fuel oil, gasoline and kerosene need to be processed further. Additional inventory and sales volume information (all in litres) is as follows: Products Opening inventory Sales units Closing inventory Fuel oil 1 000 10 000 2 000 Gasoline 2 000 12 000...
Oil and Gas Prices The average gasoline price per gallon (in cities) and the cost of...
Oil and Gas Prices The average gasoline price per gallon (in cities) and the cost of a barrel of oil are shown below for a random selection of weeks in 2015 . Oil ( $ ) Gasoline ( $ ) 55.78 2.654 41.96 2.269 52.08 2.445 57.28 2.710 58.15 2.805 67.59 3.071 The correlation coefficient for the data is =r0.978 and =α0.01 . Should regression analysis be done? The regression analysis should not be done. The regression analysis should be...
Oil and Gas Prices The average gasoline price per gallon (in cities) and the cost of...
Oil and Gas Prices The average gasoline price per gallon (in cities) and the cost of a barrel of oil are shown below for a random selection of weeks in 2015. Oil ($) Gasoline ($) 55.78 2.654 41.96 2.269 52.08 2.445 57.28 2.710 58.15 2.805 67.59 3.071
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT