An oil company has oil fields in San Diego and Los Angeles. The San Diego field...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. The refining cost at Dallas and Houston are the same. All of the refined oil is shipped to customers in Chicago and New York. The refineries do not store any finished products. 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 table below: Data From L.A. San Diego Dallas Houston Dallas $ 320.00 S 440.00 To Houston S 110.00 $ 100.00 N.Y. $ 1,195.00 $ 1,440.00 Chicago B. What is the total cost of shipment for the entire system? (2 points) $ 1,295.00 $ 1,500.00 A. Solve the formulation in Excel solver. Attach Excel Worksheet on Folio. (10 points) C. What is the optimum flow of materials between the following cities: Dallas to N.Y. and is the NY Demand solution binding? (4 points) D. What are the impact and the magnitude on total cost if the capacity in L.A. is reduced by 50,000 barrels? (4 points) E. What are the impact and the magnitude on total cost if the demand in N.Y. is increased by 250,000 barrels? (4 points) F. The transportation cost on the L.A. - Dallas leg increases to $325 per 100,000 barrels of shipment. Which of the statements given below is true? (2 points) a. There is no impact on the total cost b. There is no impact on the total flow of oil from L.A. - Dallas c. The shadow price will not change d. Cannot be solved G. Dallas wants to start supplying Chicago with oil. What should the Dallas refinery do? (4 points) 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. The refining cost at Dallas and Houston are the same. All of the refined oil is shipped to customers in Chicago and New York. The refineries do not store any finished products. 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 table below: Data From L.A. San Diego Dallas Houston Dallas $ 320.00 S 440.00 To Houston S 110.00 $ 100.00 N.Y. $ 1,195.00 $ 1,440.00 Chicago B. What is the total cost of shipment for the entire system? (2 points) $ 1,295.00 $ 1,500.00 A. Solve the formulation in Excel solver. Attach Excel Worksheet on Folio. (10 points) C. What is the optimum flow of materials between the following cities: Dallas to N.Y. and is the NY Demand solution binding? (4 points) D. What are the impact and the magnitude on total cost if the capacity in L.A. is reduced by 50,000 barrels? (4 points) E. What are the impact and the magnitude on total cost if the demand in N.Y. is increased by 250,000 barrels? (4 points) F. The transportation cost on the L.A. - Dallas leg increases to $325 per 100,000 barrels of shipment. Which of the statements given below is true? (2 points) a. There is no impact on the total cost b. There is no impact on the total flow of oil from L.A. - Dallas c. The shadow price will not change d. Cannot be solved G. Dallas wants to start supplying Chicago with oil. What should the Dallas refinery do? (4 points)
Expert Answer:
Answer rating: 100% (QA)
A The total cost of shipping oil from the San Diego and Los Angeles fields to the Dallas and Houston ... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
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...
-
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 400,000 barrels per day. Oil is sent...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
What categories of conflict occurred in this project? At what stage was the project?
-
The Orthopedic Sports Clinic purchases x-ray film and maintains it in inventory. The following amounts were purchased during 1998: Dec 31 Ending Inventory is 60 units What is the ending cost of...
-
Beacon Signals Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Beacon Signals Company prepared the following end-ofperiod spreadsheet at December...
-
Shells statement of business principles (Shell 1998: 24): Principle 6, on health, safety and the environment (HSE).Consistent with their commitment to contribute to sustainable development, Shell...
-
Match the parametric equations with the graphs labeled IVI. Give reasons for your choices. (Do not use a graphing device.) (a) x = t - 21, y=1-t (b) x = - 1, y = 2 - 1 (c) x= sin 31, y = sin 41 (d)...
-
Lukas company has annual sales of $10 million, cost of goods sold of 60 percent, average age of inventory of 80 days, average collection period of 35 days, average payment period of 30 days, and...
-
One subunit of Racer Sports Company had the following financial results last month: Requirements 1. Complete the performance evaluation report for this subunit (round to two decimal places). 2. Based...
-
12, where t is the number of hours after high tide. The depth of water in a port is modelled by the function d(t) = pcosqt +7.5, for 0ts At high tide, the depth is 9.7 metres. At low tide, which is 7...
-
How does postmodernist literature challenge traditional narrative structures, and in what ways does it reflect broader cultural shifts in the late 20th century ?
-
Texas health care provider ordered to pay former employees for mandating prayer and religious discussions by Don Byrd, BJC.com, Mar 29, 2021 A Shepherd, Texas health care clinic has been ordered to...
-
Frank's girlfriend works in a store, and he is going to meet her. When he arrives at the store, he sees his girlfriend at the counter facing a masked man with a gun pointed at her. Frank wants to...
-
Write an appropriate C++ program segment that use any repetition (loop) statements to perform the following steps: Prompt the user to input two integers: num1 and num2 (Assume: num1 must be less than...
-
A printer is publishing multiple copies of a specific document. While printing this document, ink is being used at a rate of r(t) = 0.2(1 + cos(t)),measured in ounces/min. If the printer started the...
-
Most of the directors of Dalm Company are members of the Kanwa family. The Kanwa family also runs the day-to-day operations of the company. There is no problem in the understanding of the family...
-
White Bolder Investments (WBI) You are an intern working for WBI, a large investment advisory services in Sydney. Among other regular customers, WBI has been providing advisory services for Jumbo...
-
Although the normal distribution is a reasonable input distribution in many situations, it does have two potential drawbacks: (1) It allows negative values, even though they may be extremely...
-
The percentage of examinees who took the GMAT (Graduate Management Admission) exam from June 1992 to March 1995 and scored below each total score is given in the file S05_72.xlsx. For example, 96% of...
-
Consider again the landowners decision problem described in Problem 39. Suppose now that, at a cost of $90,000, the landowner can request that a soundings test be performed on the site where natural...
-
A four-volume work is on a shelf in random order. What is the probabilty that the volumes stand in the proper order from left to right or from right to left?
-
There are \(M\) defective items in a lot consisting of \(N\) items. From this lot we select \(n(n
-
The numbers \(1,2,3,4,5\) are written on five cards. Three cards are drawn in succession and at random from the deck; the resulting digits are written from left to right. What is the probability that...
Study smarter with the SolutionInn App