REQUIRED:d. Formulate and solve a spreadsheet model for this problem.6. The Texago Corporation has four oil fields, four refineries, and four distribution centers. A majorstrike involving the transportation industries now has sharply curtailed Texago's capacity to shipoil from the oil fields to the refineries and to ship petroleum products from the refineries to thedistribution centers. Using units of thousands of barrels of crude oil (and its equivalent in refinedproducts), the following tables show the maximum number of units that can be shipped per dayfrom each oil field to each refinery and from each refinery to each distribution center.Oil FieldTexasCaliforniaAlaskaMiddle EastRefineryNew OrleansCharlestonSeattleSt. LouisNew Orleans11578Pittsburgh58412Charleston7439RefineryAtlanta97611Seattle28124Distribution CenterKansas City6979St. Louis87615San Francisco4587The Texago management now wants to determine a plan for how many units to ship from eachoil field to each refinery and from each refinery to each distribution center that will maximize thetotal number of units reaching the distribution centers.

Answered: Image /qna-images/answer/91196c18-3c73-4c2c-a3e9-7b28bcf297b2.jpg

Answered: REQUIRED: d. Formulate and solve a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Q.1. a) Identify the challenges affecting the delivery performance and buffer levels in an in-house material handling system at BRL. (
Question 3 To keep up with the market demands, Dolphin Technologies allows overtime for each of the two departments. The cost per hour of overtime for the Chip Manufacturing Department is $20, and $12 for Case Fabricating Department. Formulate a linear programming model can be used to determine the optimal production quantities if overtime is made available.
Question 5: Suppose a brewery uses a Cobb-Douglas production function for his production. He studies the production process and finds the following. An additional machine-hour of fermentation capacity would increase output by 500 bottles per day (i.e. MPK = 500). An additional man-hour of labor would increase output by 1000 bottles per day (i.e. MPL = 1000). The price of a man-hour of labor is $50 per hour. The price of a machine-hour of fermentation capacity is $5 per hour. 3. Suppose that the price of a machine-hour of fermentation capacity rises to $25 per hour. How does this change the answer from part 1?
128 A company has a factory that is designed so that it is most efficient (average unit cost is minimized) when producing 28,500 units of output each month. However, it has an absolute maximum output capability of 35,000 units per month, and can produce as little as 7,000 units per month without corporate headquarters shifting production to another plant. If the factory produces 18,900 units in October, what is the capacity utilization rate in October for this factory? Note: Round your answer to 1 decimal place.
Observation A B C 1 10,8,7,9,6 7,4,3,2 11,9,10,9,11 2 1,2,1,4,2 6,7,6,5 4,3,6,4,3 3 3,2,3,3,4 2,1,2,3 5,6,4,5,5 Solve using two-way ANOVA method
Question b and c
QUESTION 3Reverse logistics is important in managing the supply chain. Distinguish between forward logisticsand reverse logistics in supply chain management. Note: answer this question about 160 words(maximum)
Linear programming question
Need d and e
Pls solve this question correctly in 5 min i will give u like Question # 2 A company produces two products, A and B. The sales volume for product A is at least 40% of the total sales of the two products. Both products use the same raw material, of which the daily availability is limited to 200 kg. Products A and B use this raw material at the rates of 5 kg/unit and 2 kg/unit, respectively. The sales prices for the two products are $50 and $20 per unit. Determine the following: a)Optimum volume of each product to be produced? b)What impact does the production mix have, in case the sales price of Product B decreases by 50%?
1
QUESTION 1 Kofi Kwakye is a 17-year old final year Senior High student from a wealthy home. His academic life had been quite eventful, as he had been part of the top 10 students in his class and had dropped to be part of the last 10 students during the past school term. On 28th May 2022, in the heat of the preparation towards the final examination, Kofi Kwakye took exeat from school to acquire some "provisions" to enable him cope during the final exam period, which was three months ahead. He entered a shop in Accra and, instead of focusing on the "provisions", he purchasee the following items: Microsoft Xbox, the latest iPhone, and a three-piece suit by Pierre Cardin. Kofi Kwakye did not have enough money to pay for all the items at once. He, therefore, agreed with the shop owner, Mr. Ametepe, to pay the outstanding amount owed in five instalments. However, after paying the first instalment, Kofi Kwakye fell into arrears. The two parties then entered into another arrangement under…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS