# Question: An oil company has oil fields in San Diego and

An oil company has oil fields in San Diego and Los Angeles. The San Diego field can produce up to 500,000 barrels per day, and the Los Angeles field can produce up to 400,000 barrels per day. Oil is sent from the fields to a refinery, either in Dallas or in Houston. (Assume that each refinery has unlimited capacity.) To refine 100,000 barrels costs $700 at Dallas and $900 at Houston. Refined oil is shipped to customers in Chicago and New York. Chicago customers require 400,000 barrels per day, and New York customers require 300,000 barrels per day. The costs of shipping 100,000 barrels of oil (refined or unrefined) between cities are shown in the file S14_101.xlsx.

a. Determine how to minimize the total cost of meeting all demands.

b. If each refinery had a capacity of 380,000 barrels per day, how would you modify the model in part a?

a. Determine how to minimize the total cost of meeting all demands.

b. If each refinery had a capacity of 380,000 barrels per day, how would you modify the model in part a?

## Answer to relevant Questions

An electrical components company produces capacitors at three locations: Los Angeles, Chicago, and New York. Capacitors are shipped from these locations to public utilities in five regions of the country: northeast (NE), ...Use the RAND function and the Copy command to generate a set of 100 random numbers.a. What fraction of the random numbers are smaller than 0.5?b. What fraction of the time is a random number less than 0.5 followed by a ...We all hate to keep track of small change. By using random numbers, it is possible to eliminate the need for change and give the store and the customer a fair deal. This problem indicates how it could be done.a. Suppose that ...If you add several normally distributed random numbers, the result is normally distributed, where the mean of the sum is the sum of the individual means, and the variance of the sum is the sum of the individual variances. ...Repeat Problem 23, but now make the second input variable triangularly distributed with parameters 50, 100, and 500. This time, verify not only that the correlation between the two inputs is approximately 0.7, but also that ...Post your question