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

dent question I am having trouble formulating the objective function and constraints. Jeremy Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder rods is $1800 and the cost required to set up the production line for the 6-cylinder rods is $3200. Manufacturing costs are $16 for each 4-cylinder connecting rod and $20 for each 6-cylinder connecting rod. The production capacities are 5800 and 7200 for 6 and 4 cylinder rods respectively. The operating budget is $100,000. The selling prices are $55 per 4-cylinder rod and $70 per 6-cylinder rod. What is the optimal number of 4 and 6 cylinder rods that should be produced by the company? Identify the type of integer programming framework (Total Integer, Mixed Integer or Binary) that applies to this problem, develop the appropriate formulation (decision variables, objective function and constraints)
Question Primer Inc. offers plumbing and air conditioning services to customers in Kumasi, Ghana. The company’s product strategy is to solve the customer’s problem irrespective of what it takes, at the time the customer needs it solved. The company provides same day service for customers, and theaim is to make the customer happy before leaving.The services of the company are available 24 hours a day, 7 days a week for customers. There is no extra charge for requests made on holidays, odd hours of the day, or in festive seasons. The company aims to be available at the call of customers without charging a pesewa extra, even at times when rival firms won’t get out of bed. The company fixes the price of the service before it begins, and customers can be assured of no extra charges. Irrespective of the customer’s location in the city, Primer Inc. does not charge additional fees for transportation. For all services, the company provides a one year guarantee on all parts and labour used,…
18 see picture to solve
23 see both pictures to solve
13 ANSWER LETTER G ONLY
Question 3 A research collaboration can be enhanced by: Limiting the communication between researchers and industry partners. Avoiding the issue of which journal to target since research team members might disagree. Discussing intellectual property issues while the collaboration is forming. Waiting to discuss authorship issues until after data collection. Question 4 In any collaboration, data ownership is typically determined by: The research team with access to the best lawyers. The individual who does the most work on the project. The type and source of funds used to support the project. The relevant department chairs.
Need d
Which of the following is the hotel’s process of recording financial transactions? Question 16 options: a) Bookkeeping b) Auditing c) Forecasting d) Budgeting
*Question on LP*A company produces two products that are processed on two assembly lines. Assembly line one has 100 available hours and assembly two has 42 available hours. Each product requires 10 hours of processing time in assemble line one. Whilst on assemble line two, product one requires 7 hours and product two 3 hours. The profit for product one is ghc 6 per unit. The profit for product two is ghc 4 per unit. Management wishes to know how many units of each product to produce in order to maximize total profit. a) Define the decision variables for this Linear Programming problem b) Formulate a LP model for this problem c) Solve this model using graphical analysis.
Question content area Part 1 Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 45% in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. This new process will require that the ovens be loaded by hand, requiring additional manpower. This is the only thing to be changed. (Productivity remains the same.) (Hint: Each worker works 160 hours per month.) Part 2 If the bakery currently makes 1,500 loaves per month with a labor productivity of 2.344 loaves per labor hour, then Lackey will need to add enter your response here worker(s) to meet the increased demand (recall that each worker works 160 hours per month and round your response…
Question: You want to buy electric energy. You can buy from company A, B, C, or D, but you must choose only one. You obtain past data on these four suppliers, and you then determine that the prices for some of them have been quite volatile, influenced by the state of the economy (recession, stagnation, and inflation). You assess this data given in the table in the picture attached. a) Assuming that you simply want to minimize your average costs over the long run, determine the expected costs for all energy suppliers. Select the supplier based on minimum expected cost. b) Assuming that you cannot afford any surprises and therefore want to minimize his uncertainty, determine the standard deviation for each supplier. Select the supplier based on minimum variance (same as minimum standard deviation).
Question FACTS: Noel is a computer programmer at Jonadel Corporation. He was delighted to know that part of the company’s athletic program is a mixed doubles tennis tournament to be held at the corporate tennis court. Grace, who works in the same department, used to play with Noel on many occasions and the two would like to compete in the tournament. They feel that there is a great chance to win the annual tennis competition. There is a growing interest among employees who are tennis players in the corporation as it develops more productivity at work. The management themselves are all tennis enthusiasts. The tournament is scheduled on Friday afternoon and management declared this as a “tennis holiday”. It is a day of fun and workers can cheer for their respective teams. Management supported the program with free snacks and fun fairs to make the occasion memorable. It was a four – consecutive Friday’s tournament. Noel and Grace advance to the final round. They were leading in the third…

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