Ewing Oil 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 600,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 1000 barrels costs $6300 at Dallas and $5700 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 600,000 barrels per day. The costs of shipping 100,000 barrels of oil (refined or unrefined) between cities are shown in the file P05_74.xlsx. a. Determine how to minimize the total cost of meeting all demands. b. If each refinery had a capacity of 500,000 barrels per day, how would you modify the model in part a?

BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
Chapter 5, Problem 74P
Textbook Problem

Ewing Oil 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 600,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 1000 barrels costs $6300 at Dallas and $5700 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 600,000 barrels per day. The costs of shipping 100,000 barrels of oil (refined or unrefined) between cities are shown in the file P05_74.xlsx.

  1. a. Determine how to minimize the total cost of meeting all demands.
  2. b. If each refinery had a capacity of 500,000 barrels per day, how would you modify the model in part a?

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 5 Solutions

Practical Management Science
Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.3 - The city of Spring View is taking bids from six...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.4 - The RedBrand Company produces a tomato product at...Ch. 5.5 - Maude Jenkins, a 90-year-old woman, is planning to...Ch. 5.5 - Maude Jenkins, a 90-year-old woman, is planning to...Ch. 5.5 - Maude Jenkins, a 90-year-old woman, is planning to...Ch. 5.5 - VanBuren Metals is a manufacturing company that...Ch. 5.5 - Maude Jenkins, a 90-year-old woman, is planning to...Ch. 5.5 - VanBuren Metals is a manufacturing company that...Ch. 5.5 - VanBuren Metals is a manufacturing company that...Ch. 5.5 - VanBuren Metals is a manufacturing company that...Ch. 5.5 - VanBuren Metals is a manufacturing company that...Ch. 5 - The town of Busville has three school districts....Ch. 5 - A truck must travel from New York to Los Angeles....Ch. 5 - You are trying to help the MCSCC (Monroe County...Ch. 5 - A school system has 16 bus drivers that must cover...Ch. 5 - The government is auctioning off oil leases at two...Ch. 5 - The 7th National Bank has two check-processing...Ch. 5 - The Amorco Oil Company controls two oil fields....Ch. 5 - Touche Young has eight auditors. Each can work up...Ch. 5 - Five employees are available to perform four jobs....Ch. 5 - Based on Machol (1970). A swimming coach is...Ch. 5 - A company is taking bids on four construction...Ch. 5 - A company manufactures widgets at two factories,...Ch. 5 - General Ford produces cars in Los Angeles and...Ch. 5 - Sunco Oil produces oil at two wells. Well 1 can...Ch. 5 - Nash Auto has two plants, two warehouses, and...Ch. 5 - Edsel Motors produces cars in Detroit and Dallas....Ch. 5 - Each year, Data Corporal produces up to 10,000...Ch. 5 - It costs 300 to buy a lawn mower from a lawn...Ch. 5 - Suppose it costs 30,000 to purchase a new car. The...Ch. 5 - At the beginning of year 1, a new machine must be...Ch. 5 - Delko is considering hiring people for four types...Ch. 5 - Powerhouse produces capacitors at three locations:...Ch. 5 - Based on Hansen and Wendell (1982). During the...Ch. 5 - Three professors must be assigned to teach six...Ch. 5 - Based on Denardo et al. (1988). Three fires have...Ch. 5 - Allied Freight supplies goods to three customers....Ch. 5 - Referring to the previous problem, suppose that...Ch. 5 - Based on Glover and Klingman (1977). The...Ch. 5 - There are 15 jobs that must be done by 10...Ch. 5 - Bloomington has two hospitals. Hospital 1 has four...Ch. 5 - In Problem 55, assume that before being shipped to...Ch. 5 - Rework the previous problem under the assumption...Ch. 5 - Ewing Oil has oil fields in San Diego and Los...Ch. 5 - At present, 40,000 long-distance calls must be...Ch. 5 - Eight students need to be assigned to four dorm...Ch. 5 - Based on Ravindran (1971). A library must build...Ch. 5 - Kellwood, a company that produces a single...Ch. 5 - You have put four valuable paintings up for sale....Ch. 5 - A company produces several products at several...Ch. 5 - You want to start a campus business to match...Ch. 5 - It is essential to constrain all shipments in a...Ch. 5 - What is the relationship between transportation...Ch. 5 - Unlike the small logistics models presented here,...Ch. 5 - Optimized Motor Carrier Selection at Westvaco A...

Additional Business Textbook Solutions

Find more solutions based on key concepts
On the summary screen, you should sec an interactive chart. Typically, you can chart performance over the last ...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

What is venture capital? An angel investor? A private placement?

Foundations of Business (MindTap Course List)

Label the blanks in the column heads as either Debit or Credit.

College Accounting (Book Only): A Career Approach

Why do companies hold short-term investments?

Cornerstones of Financial Accounting