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

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%?
Question ompletion A Moving to another question will save this response. uestion 1 If each orientation for an RPN costs approximately $3000, how many RPNS can the hospital plan to hire with an orientation budget of $96,000? O 16 O 32 O 64 O 96 A Moving to another question will save this response. tv PDF 15 MacBook Air 30 888 DII DD F4 F5 F6 F7 F8 F9 36 4 5 7 * 00 %24
1
Question 5 The Omega Industrial Company produces two products A and B. The raw materials requirements, space needed for the storage, production rates, and selling prices for these products are given in the table below. Storage Space (ft²/unit) Raw Material (lb/unit) Production rate (units/hr) Selling Price (Php/unit) O 5x1 + 6x2 ≤ 1800 O X1 + 2x2 ≤ 480 O X1 + 2x2 ≥ 480 O 5x1 + 6x2 ≥ 1600 A O X1 + 2x2 < 1800 5 6 60 15 Product B 6 The total amount of raw material available per day for both products is 1600 lbs. The total storage space for all products is 1800 ft² and a maximum of 8 hours per day can be used for production. What is the constraint in terms of storage space? 4 30 1 pts 12
Moving to another question will save this response. Question 12 A channel consisting of one or more independent producers, wholesalers, or retailers that seek to maximize their own profits - even at the expense of profits for the channel as a whole - is a(n): O a. vertical marketing system O b. corporate VMS Oc administered vertical marketing system O d. conventional distribution channel O e. horizontal marketing system A Moving to another question will save this response. hp

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